From BOL: (Declare cursor)

Describing the select statement of a cursor:

select_statement

Is a standard SELECT statement that defines the result set of the cursor. The keywords COMPUTE, COMPUTE BY, FOR BROWSE, and...

Sad to say Ron never made that statement. Check out his comments on the article -

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6136

I am not commenting on the article altogether, but only a quote...

David -

Yes, there is a large difference between commercials in Europe and the States. They are our last gasp of Puritan ethics. The French side of my family was amused...

SELECT email, CASE WHEN firstd > lastd THEN firstd

ELSE lastd

END

FROM @val

Frank,

I vaguely remembered that information_schema had the database catalog names - I just could not remember which one.

Thanks

David -

American cable is the same dreck - shows that were cancelled years ago rise from the dustbin to "entertain" you again. Who wants to watch 150 channels showing...

Is the server set up for Mixed Authentication, or only SQL Server?

What I do sometimes is create a User Defined Data type of SQLEmpty (or whatever naming convention is used). Define it as ' ', then use that for the defaults....

Congratulations Frank.

I hope you have enough diapers.

I used checksum(whatever product) for the same purpose.

Yes, it looks as if you are trying to move a column that is defined a text. Not sure, since you did not post your DDL.

I would try Yelena's...

Ah, someday...Yukon...

You also should run Profiler and then a trace with this query. After that use Index Wizard to see if it finds any new indexes, etc.

Sorry, QA does not do that. Changing from grid to text is not defined in SQL as far as I know.

It is probably more efficient to use IF EXISTS() instead of Count(). Depends on the size of your table. Exists checks for the values and stops when it finds the...