But...

I agree with Lutz.

Okay... someone alleviate my ignorance and tell me what "dfft" means.

You were too quick for me, Seth.

Paul, whenever you do something in SQL, it is almost always preferable to NOT use a loop. That is procedural thinking that...

declare @item_sk int

set @item_sk = 4220

select @item_sk as item_sk, CASE when exists (select 1 from #group_items where item_sk = @item_sk and description = 'filed')

then 'Yes'

else 'No'

end as filed

You could modify...

The Dixie Flatline (7/7/2010)

From Books Online (the section on RAISERROR):

When RAISERROR is run with a severity of 11 or higher in a TRY block, it transfers control to the associated...

I don't think anybody misunderstands anything after all this time. Yes, the flow of the procedure is interrupted when evoked from within a try/catch. ...

rajmaiet,

Please submit your question as a new question, rather than tacking it onto someone else's question.

Congrats, Jeff. I will bring a big bag of peanuts to your session so your SSC fans can throw them at you if you mention Hamster Poo.

I'm off...

Agreed,...

Double Forward Fourier Transforms ??

Jeff, you have hp on the brain.

You need to clean the cages out more often ,,, or naybe less often. 😛

Good that you included gals. Very bad to give offense.

At least one practices with edged weapons... and fiber-optic laser disassemblers. She showed remarkable...

I can't help. I ran your code and got the same puzzling results. Then I looked through books online and it reads as if the results...

If you look closely at the execution plan for your first example, you should see that it only pulls the column(s) necessary for filtering or output from the joined table....