Viewing 15 posts - 45,301 through 45,315 (of 59,063 total)
GSquared (2/2/2009)
February 2, 2009 at 5:22 pm
benlatham (2/2/2009)
February 2, 2009 at 5:16 pm
Grant Fritchey (2/2/2009)
Jeff Moden (2/1/2009)
Grant Fritchey (1/23/2009)
There are three ways you can do this easily. Use TOP, MAX or ROW_NUMBER.
I'm thinking this one isn't about how to create the next...
February 2, 2009 at 5:13 pm
sandy (2/2/2009)
Server: Msg 195, Level 15, State 10, Line 27
'ROW_NUMBER' is not a recognized function name. but it...
February 2, 2009 at 4:17 am
It's kind of a moot point now because the op said they're using SQL Server 2000, but here's the 2005 rendition I came up with. The output is the...
February 2, 2009 at 4:13 am
Vladan (2/2/2009)
Jeff Moden (1/31/2009)
Vladan, check your code... I don't believe it's coming up with the correct result set.
I checked it and either I'm blind (quite possible, I'm still only half...
February 2, 2009 at 4:08 am
I don't know much about SSIS... there may be a simpler way to do this, like applying some sort of filter to the output before routing it to the file....
February 2, 2009 at 4:04 am
Double post... please don't respond here. Go to the following post, instead.
http://www.sqlservercentral.com/Forums/Topic647800-17-1.aspx
February 1, 2009 at 9:48 pm
Heh... I remember DBase II and III... every table was a flat file. It was absolutely awesome...
Want to backup just some tables? No problem. Want to copy...
February 1, 2009 at 9:31 pm
There have to be dozens of articles and polls of this nature on this site. I recommend you do a search for them.
February 1, 2009 at 9:20 pm
Matt (2/1/2009)
February 1, 2009 at 8:59 pm
Grant Fritchey (1/23/2009)
There are three ways you can do this easily. Use TOP, MAX or ROW_NUMBER.
I'm thinking this one isn't about how to create the next id. 😉
February 1, 2009 at 8:46 pm
Eric Klovning (1/22/2009)
This article should give you the info you need.
Heh... you beat me to it with my own stuff. 🙂
February 1, 2009 at 8:45 pm
ghughes (1/29/2009)
I found a great answer on 2005...
Would you post the URL for that answer, please? Thanks.
February 1, 2009 at 8:42 pm
Viewing 15 posts - 45,301 through 45,315 (of 59,063 total)