Helen,

can you explain this with an example?

No need to worry!

Have a play with it and you'll see

set nocount on

create table hans

(

 name varchar(10)

 , date datetime default getdate()

)

insert into hans (name,...

Oh, and may I add that you shouldn't use use words as name and date as identifiers for column?

Okay, what about:

set nocount on

create table hans

(

 name varchar(10)

 , date datetime default getdate()

)

insert into hans (name, date) values('Arley','20040302')

insert into hans (name, date) values('Arley','20040310')

insert into hans (name, date) values('Arley','20040312')

insert into hans (name,...

Probably the easiest way is to use EM for this. but rather than saving the table, click on Generate Change Script. This can you schedule for off-peak hours. When you...

Actually there is no such thing as "the first 10 rows". If I understand you right, you have two alternatives:

USE PUBS

GO

SET ROWCOUNT 10

SELECT au_lname FROM authors ORDER BY...

<bg>, you can now combine the joy of reading with the joy of computing.

Okay, in that case you might want to go from

http://www.microsoft.com/sql/default.mspx

to

http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp or

http://www.microsoft.com/sql/evaluation/compare/default.asp

HTH

Maybe this is a starting point:

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx

http://www.microsoft.com/usa/webcasts/ondemand/1883.asp

http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/ssmsam.mspx

Please avoid multiple threads on the same topic in different categories. This makes it hard to track who answered already what in which thread.

Keep this thread alive:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=148045

While the "best" answer is to do this at your presentation layer, you might want to search the script section or the site in general for crosstab report (or pivot...

See, if this helps:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;311231

http://support.microsoft.com/default.aspx?scid=kb;EN-US;315886

http://support.microsoft.com/default.aspx?scid=kb;EN-US;312839

http://support.microsoft.com/default.aspx?scid=kb;EN-US;263556

In case it doesn't help do a search here in the script section.

Identifying duplicates is one of the most frequently asked questions. So it's very likely you'll find a solution...

Finally, a request for assistance in this very area. I have to process a CSV list of integers that represent primary keys in a lookup table, then use that list...

May I add that I would prefer sp_executeSQL rather than EXEC() if it need to be dynamic?

Why? http://www.sommarskog.se/dynamic_sql.html