Hy, what the heck! I went back...

But you're so good at it! :Whistling: :w00t:

My bad. Probably did, but the OP seemed to keep talking about the uniqueidentifiers in later posts.

JayWinter (3/6/2012)

---

My intent is to retrieve the last 5 records in the table by first sorting the table in descending order:

ORDER BY

ROW_NUMBER() OVER(ORDER BY RETAIL_SALES.YR

,RETAIL_SALES.MO, RETAIL_SALES.WK ASC) DESC

Now the bottom...

Check out this DMV in Books Online: sys.dm_exec_sessions

And yes, if you know that there won't be duplicates you can change the UNIONs to UNION ALLs.

You could also rewrite your procedure. Below are two possibilities, not sure if they are totally correct as I have nothing with which to test against.

-- First rewrite of...

Microsoft Team Foundation Server

subversion

ClearCase

Sourcegear Vault

I'm sure you could find others with a simple Google or Bing search.

I just want to be sure what you are asking for here. Do you want to go back to the FTP server you downloaded the file from and move...

No, no cursor necessary, but as Sean pointed out we need the DDL for the table, sample data for the table, expected results when all is done. It would...

deepikamm (3/6/2012)

---

Please do not comment without knowing the fact that whether i have googled or not.

i thought that the experts in sqlservercentral would give me a better clear answer thats...

Not sure what you are asking. Could you explain this a little better, perhaps show us what you...

The only other thing to realize is that you aren't going to be able to generate guids (uniqueidentifiers) in a sequence using SQL Server 2000.

If you need a sequence, you...

With this, below, I have to agree with Jared. It tells us that you are unwilling or unable to question your own processes. That even if shown a...

You can also check out this article, it may help with some ideas:

Deleting Large Number of Records

[/url]