select emp1.id

from emp1,emp2

Yes, this format produces an implicit CROSS JOIN of the two tables, resulting in a cartesian product. Even though you are only requesting that one...

(whew) It took me 45 minutes to catch up.... I'm out of breath from reading so fast.

1. How hard can it be to spell GliaMonster correctly?

2. ...

Steve!! Sue him for copyright violation!!

Barry and Grant: I'd love to hear (privately) the comments that might get you in trouble. My imagination is failing me.

To make this work, you are either going to have to pass your list of rows as a table-valued parameter OR use the CHARINDEX or PATINDEX function to see if...

A set of rows is NOT a string. It's a table-valued parameter. You seem to be confusing a passed parameter with building a string dynamically....

declare @Company_Name_Code varchar (4)

declare @test-2 table (company_name_code char(1))

insert into @test-2

select '1' union all

select '2' union all

select '3'

set @Company_Name_Code = '2' -- will work

-- set @Company_Name_Code = '1,2' -- will return...

Comment withdrawn. My guess would be that you are trying to use the same parameter as both a scalar and a table variable at the same time. ...

It's not so bad, Lutz.

ROW_NUMBER() + Tally table + CASE expression = powerful dynamic SQL. 😀

-- variable number of followup dates demands dynamic SQL

declare @sql...

Maybe it's because your face is marred by dust and sweat and blood....

Finally got caught up, both here and in the "Missing" thread. I tried to tell y'all last week to just ignore the interruptions and go on with...

Again from BOL:

If the table is a heap, which means it does not have a clustered index, the row locator is a pointer to the row. The pointer is built...

Once again, it depends! 😛

From BOL on Nonclustered Index Structures:

If the table has a clustered index, or the index is on an indexed view, the row locator is the clustered...

Loved Kelly's Heroes. I still remember Oddball walking up to the German tank and unfastening his holster to be ready for a quick draw.

With respect to dealing...

Peer review. For the MCJ, would this need to be a video, or could a project, including code, that could be tested in a lab environment by independent individuals be...