| Author |
Topic |
|
shubhada
Posting Yak Master
117 Posts |
 Posted - 2005-12-07 : 06:19:45
|
| I want to migrate following sql query in Sybase.Somebody have any idea about Sybase please help me.select * from PayerPricingSingle where Code in ( select distinct Code from PayerPricingSingle where isnumeric(Code) > 0 and convert ( float,Code) >= 23 and convert(float,Code) <= 123 )and PayerPricingKey = 40please help me...shubhada |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2005-12-07 : 07:51:15
|
| I guess you can post this query at www.dbforums.comit will be more help fullSucess Comes to those who Believe in Beauty of their Dream.. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-07 : 08:05:04
|
| Use equivalent of convert function in SysbaseExcept that it seems to work in all DBMSMadhivananFailing to plan is Planning to fail |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-07 : 13:28:14
|
| Why do you need the sub-select, the table is joined back to itself, so the criteria can be applied to the row itself, can't they? Also not sure why you are casting to FLOAT when the arithmetic logic seems to all be integer. (Ah! Maybe because And beware that IsNumeric() will allow values that can NOT be converted to INT be which CAN be converted to Float - there are better ways to handle this if you values will ONLY be Integers)Kristen |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-07 : 14:10:19
|
quote:
Originally posted by madhivanan
Use equivalent of convert function in SysbaseExcept that it seems to work in all DBMSMadhivananFailing to plan is Planning to fail
MS and Sybase used to be the same product, before the break awayhttp://www.ispirer.com/productshttp://www.sybase.com/detail?id=1019664 |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-08 : 00:48:07
|
>>MS and Sybase used to be the same product, before the break awayThanks for the information  MadhivananFailing to plan is Planning to fail |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-08 : 05:10:18
|
quote:
Originally posted by madhivanan
>>MS and Sybase used to be the same product, before the break awayThanks for the information MadhivananFailing to plan is Planning to fail
Yes Sir,They partnered with sybase to build MS SQL server, both of them run very similar T SQL syntax. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-08 : 08:36:46
|
Actually Microsoft SQL Server originated from Sybase.According to Wikipediaquote:
The code base for Microsoft SQL Server originated in Sybase SQL Server, and was Microsoft's entry to the enterprise-level database market, competing against Oracle, IBM, and Sybase. Microsoft, Sybase and Ashton-Tate teamed up to create and market the first version named SQL Server 4.2 for OS/2 (about 1989) which was essentially the same as Sybase SQL Server 4.0 on Unix, VMS, etc. Microsoft SQL Server for NT v4.2 was shipped around 1992 (available bundled with Microsoft OS/2 version 1.3) and was a simple port from OS/2 to NT. Microsoft SQL Server v6.0 was the first version of SQL Server that was architected for NT and did not include any direction from Sybase.
-----------------[KH]Dec-05 |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-12-08 : 08:48:03
|
| afrika and khtan, you guys need to realize when madhivanan is being ironic. I'm sure all the regular posters here know that SQL Server originated from Sybase.CODO ERGO SUM |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-08 : 10:52:54
|
| Oh! Oh !! :-(I should have realized thatMaddy, ...with the highest number of teasers online, i should have realized that. Guess we should move this thread to simple quiz [:-)] |
|
|
|
|
migration from SQL to Sybase