Your problem is that you converted the number to a string, which sorts alphabetically, not numerically.

I would use a different name for the alias of the sort column so you...

isa (6/13/2008)

---

Hello everyone i m using SQL Server2005 ,i have to check some data in my Cities table so i used the following command

Declare @myTestVar varchar(100)

set @myTestVar = '10,11,12,13'

select *...

Try using "Format=Delimited(|)" instead.

See this website: http://www.connectionstrings.com/?carrier=textfile

- Paul

Try this syntax to read from junk.txt:

select * from OpenRowset('MSDASQL',

'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\Temp;Extended properties=''ColNameHeader=True;Format=CSVDelimited;''','select * from junk.txt')

I shamelessly copied this (with modification) from Vasc's March 2006 post.

He also...

I believe your assumption that [Unit Price] should be additive is incorrect, so the result of 83,417 should be the right one. Since both [Sales Price] and [Quantity] are additive,...

I second the use of TABLE variables. In my own application, the use of table variables improved performance dramatically (2x or greater in many cases). Also, regarding indices, if you...

Thanks for the suggestion. I have not yet been able to get this to work, however.

I use .NET and not VB6, so I ran the conversion utility. There were some...