you can use SELECT DISTINCT ....[columns]...FROM YOURTABLE to eliminate duplicates.

if the whole row of data is not unique, then you'll have to use GROUP BY , putting columns you don't...

edit your new posts so they do not use huge font, and remove the two duplicates...very annoying.

the error message says it all...Google could have saved you hours of waiting.

you are...

fredsql (4/2/2009)

---

I am actually looking to do something slightly different, I want to number data returned in a query the first 25 row would be numbered 1 the second 25...

drewsx2 (4/1/2009)

---

Sorry Glich in first posting!

Hello,

I have a Table in my DB that is used by multiple other tables. It looks like this:

ID Type User_ID

1...

here's an example, assuming you are using row_number() function to decide how many rows:

you might need to fiddle with it,

declare @WhichPage int

Set @WhichPage = 3

SELECT * FROM (

select row_number()...

Gail has identified the root cause of your problem...I've yet to see a table with that many...

say you want to add 100 new fields to your Table250.

I would simply add a new table, with a foreign key to the original table, and a UNIQUE constraint on...

because SERVERPROPERTY() is a function, even if you had " FROM RemoteServer.master.dbo.sysobjects" as the from clause, the function will return the info from the machine you are connected to...not the...

the old chicken and the egg; which do you need first?

you need to connect before you can run a query to try and find the IP,

....but you need the...

among the same versions (ie 8.* to any other v8 or 9.* to any other v9) all backups are compatible with the same version..

so if i backup with SQL2005...

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

http://www.sqlservercentral.com/Forums/Topic687890-357-1.aspx

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

http://www.sqlservercentral.com/Forums/Topic687890-357-1.aspx

i'm still reading your code, but it looks like it is doing nothing more than getting a bunch of links for navigation recursively right?

i'd like to see the code of...

both != and <> are "not equal" and are valid operators for SQL server...i used != because the web site sometimes interprets that as html and makes it disappear.

did you accidentally run the script on the master database instead of a specific database? or a different database than the one you needed to?