Please Helo wih Group By SQL statement ...
Hello and thanks for reading this,I am trying to group a timestamp column by date onlyThe following statement does not work since the column date_entered includesboth date and time so the GRUP BY does not group the proper way I wish ittoSELECT SUM(subtotal), count(*), date_entered FRM orders WHE...
3 answers | 557 bytes |
I'm sorry for this spam :(
...
0 answers | 19 bytes |
Data replication - ASE -> Sybase IQ
HiI'm new to Sybase and my question is the following:What are the methods of data replication from ASE to Sybase IQ? I know thatI can use Sybase Replication Server, what about SQL Remote or MobiLink ?If you have some tutorials(or other materials)about it please send me I willbe very gratufu...
0 answers | 360 bytes |
Data replication from ASE to Sybase IQ
HiI'm new to Sybase and my question is the following:What are the methods of data replication from ASE to Sybase IQ? I know thatI can use Sybase Replication Server, what about SQL Remote or MobiLink ?If you have some tutorials(or other materials)about it please send me I willbe very gratufu...
0 answers | 360 bytes |
Data replication: ASE -> Sybase IQ
HiI'm new to Sybase and my question is the following:What are the methods of data replication from ASE to Sybase IQ? I know thatI can use Sybase Replication Server, what about SQL Remote or MobiLink ?If you have some tutorials(or other materials)about it please send me I willbe very gratufu...
0 answers | 360 bytes |
Replicating data from ASE to Sybase IQ
HiI'm new to Sybase and my question is the following:What are the methods of data replication from ASE to Sybase IQ? I know thatI can use Sybase Replication Server, what about SQL Remote or MobiLink ?If you have some tutorials(or other materials)about it please send me I willbe very gratufu...
0 answers | 360 bytes |
Replicating data from ASE to Sybase IQ
HiI have a question associated with Sybase IQ. I want to replicate data fromASE to Sybase IQ. I know that I can do it using Sybase Replication Server.Are there any other methods to do that ? I'm completely new to Sybase.Maybe Sybase IQ has something like MobiLink or SQL Remote, ?Thanks for...
0 answers | 340 bytes |
Can't get ASE OLEDB provider to work
Hi:I am trying to work with the oledb providers for Sybase 12 ( I have towork with this version). I installed them and it worked just fine.There was nothing to tell me it succeeded after the reboot through.If I try to add a server in the Sybase LEDB administrator it tells meit can't find an...
0 answers | 1427 bytes |
Capture return from sybase in shell script
Hi,I am writing a script that calls a stored proc using ISQL. In certaincases I want to return -1 if the desired output is not there. I triedusing a 'return' statement in my stored proc, but when I tried tocapture the return status in shell using '$?' it still gives a 0.Can a...
6 answers | 461 bytes |
get everything from table A that is not in table B
Hi,I have a table Rates(date,maturity,rate) in which are downloaded ratesfor different maturity points, say 1YR, 2YR, 3YR and so on. I wish towrite a query that would provide me if there were more or less maturitypoints downloaded between two days.So lets say on day1 I downloaded1 YR -1002 YR -2...
1 answers | 715 bytes |
GUI tool for sybase
Could anybody let me know any GUI sybase tool for data manipulation andviewing all database schema (tables, sp etc) like Toad in ?...
2 answers | 153 bytes |
Sybase error -5702 and -1
Hi I saw various postings related to error 5702.Usally the problem is solved by upgrading the sybase version as this isa bug in previous versions. But my case is opposite.I have a C app. that is creating a cursor on a table and calling astored procedure for eachentry. The stored proc creates few...
3 answers | 1105 bytes |
- Please Helo wih Group By SQL statement ...
- I'm sorry for this spam :(
- Data replication - ASE -> Sybase IQ
- Data replication from ASE to Sybase IQ
- Data replication: ASE -> Sybase IQ
- Replicating data from ASE to Sybase IQ
- Replicating data from ASE to Sybase IQ
- Can't get ASE OLEDB provider to work
- Capture return from sybase in shell script
- Does LEFT OUTER JOIN actually work in SQL Server 2000/2005
- Exiting ISQL with / w/o exit & quit
- Modeling General Graphs in SQL
- theory about foreign key as primary key ?
- Sybase and materialized views
- bcp into syslogins
- Help required with Timestamp field
- Home- About Us- Contact- Privacy Statement- Link Exchange- Bookmark- Map.XML- Rss.Xml
- Copyright 2001-2008 by EMSDN.COM Information Technology Co.,Ltd All rights reserved
- 0.141