SQL Server sort order

greenspun.com : LUSENET : DBAzine : One Thread

I have a database in MSSQL Server 7.0. I have a table in one of the database. When I give the select statement in the table with particular column as a reference column, each time I am getting in different sort order. What should I do to get the same kind of result?

The table doesn't have any index built based on that particular column. And that particular column allows duplicate values.

Can you please help me in this regard ASAP????

Thanks, Rajkumar.

-- Rajkumar (rajkumar@chn.cognizant.com), February 21, 2002

Moderation questions? read the FAQ