That syntax does not work.

It just assigns alias "NOLOCK" to the table.

50 columns...

Have you done an estimation of the data to be passed?

What about estimation of transaction information to be recorded into log file?

Try to do SELECT TOP 10000, then 100k....

SQL is data access language.

It does not have user dialogue options.

You may query for lines with ID IS NULL, but interaction with user must be done from front-end application written...

Kenneth,

SP is a part of T-SQL functionality, CLR is not, it's another programming language. As well as VB, C, Java, etc.

SP's are the part of T-SQL functionality, so it's naturally...

1st, you declared @buffer as SQL_variant. It must be nvarchar(4000).

2nd, you cannot add string value to either int or sql_variant.

You must convert ARV to nvarchar before adding it to ','

And...

Try again.

Show the script you were trying.

Because you are adding minutes instead of subtracting them.

Actually approach from Koji is exactly what they name "hidden sursor".

On big amount of data it will kill performance.

As well as constructing buildings and repairing automobiles.

What CLR has in common with T_SQL?

Why you talk about CLR, but not about VB script? SP cannot be used there as well.

C++,...

Very strange.

Last time I used it I've got noticeable performance improvement by making index on key column clustered.

It's probably because there are 2 or 3 descriptions per ID.

And that index is the only one.

It's not the case for a real system.

Create clustered index on another column, make...

> I also prefer to qualify each column with the full table name and diagree with the convention of always using single character aliases for tables names.

It does not...

Performance will be even better with

CREATE CLUSTERED INDEX BigTestIndex ON dbo.ClientPublication (ClientID,Description)

Did you actually read that post???

I suggested not to change indexing on existing table, but create another one.

If you ask for suggestions try to concentrate and read them.

Use my function from the post over there:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=338231

Use CHAR(13) + CHAR(10) as a delimiter.

Return result set where line No <=6