Eric,

Yukon kind of solves this; sprocs can accept cursors as input. I agree with you, though, SQL products should support relvars as intrinsic types rather than as pure containers....

UPDATE YourTable

SET YourCol = REPLACE(YourCol, CHAR(13) + CHAR(10), '')

Eh... Who cares about this?

Can anyone show me a database with over 2 million objects, let alone nearing 2 billion?  And if your table starts nearing 512 columns, you've designed something...

You've created the following question....

Can you re-word this question three days in a row?

o Yes, I believe it's possible

o No

o Yes, SQLServerCentral.com did it

The answer was correct....

use tempdb

go

create table a (id int, somechara char(1))

go

create table b (id int, somecharb char(1))

go

insert a values (1, 'a')

insert a values (2, 'b')

insert a values (3, 'c')

insert b...

I'll help if you need more... Since I never bothered to submit my entry I will be a very neutral judge... Drop me a PM or e-mail.

Oh, and by the...

Hasn't the person who wrote this question ever heard of DELETE or UPDATE?

Fix the problem... Don't roll back the entire database!

Robert,

FYI, EXISTS (SELECT TOP 1) and EXISTS (SELECT *) will perform exactly the same. Both predicates will be satisfied upon retrieval of exactly one row.

I got the feeling it was a typo, but maybe it was a trick question

Perhaps whoever submitted it can comment..?

Didn't any of you notice...

while exists( select * from Orders where fulfilled 1)

...

update orders set fulfilled = 10 where status = 1

This will run in an endless loop if...

Submit your own then

Today's newsletter says that the deadline is Aug. 6; the article says 30 days from "the date it was published," whic appears to be 7/22... So shouldn't the deadline...

thormj,

The problem is that unfortunately that query will be unable to seek indexes as the optimizer will evaluate ALL of the possible conditions (therefore, a scan will be necessary).

Please check out MVP Erland Sommarskog's article on this subject:

http://www.sommarskog.se/dyn-search.html

It's doable, but that might be another challenge (or perhaps, a question of whether a bowling system would really be modelled with this table)... But IMHO for the sake of...