Posted by --CELKO-- on 10/13/06 18:16

>> I'm trying to something that just works in Oracle, but does not in SQL Server. <<

Oracle is the one that does not work and SQL Server is the one that
follows Standards. Wait until you find out how Oracle also screws up
NULLs. If you want decimal placs, then you can CAST() the values to
your needed precision. If you use a number with a decimal point in
it, SQL Server will pick a default precision.

• Next in forum: Re: Compare record count in table1 to qty in table2?
• Prev in forum: Re: Subquery in DTS No Longer Works After Years
• Thread view: Re: Return percentages in the query.

[Reply to this message]