Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 ORDERING Question

Author  Topic 

Da_Retina
Posting Yak Master

109 Posts

Posted - 2001-11-19 : 05:41:28
HI..
I have a couple of prcedures .. The first one fills a table with accounts and thier related information. SORTED BY ACCOUNT NUMBER!
The second one does calculations on the accounts and IT DEPENDS on thier sorting supposedly guranteed in the first proecdure!
The first time it works .. The second time it fails!!..I discovered that the sorting is not preserved!..After I complete my work with the second procedure I delete from the table!..and that doesnt work!
When I TRUNCATE the table in between the program works!
what could possibly be the PROBLEM?
Thanks in Advance

   

- Advertisement -