I think that I forgot to mention this.

I can write a query of the same thing that is in the sproc, and it works fine, inserts all rows.

This is driving...

Thank You Everyone for all your work and the code.

Lynn, your code ran the best. Took only a few seconds over approx 200,000 rows. Very nice

Thank you all once again,...

Hey Sean

That is perfect. Exactly what I needed to see.

Sorry about the confusion on the output. But this works just fine. Seeing the name and the MemberID were the important...

HI Lynn and all others

This is a heading banging against the wall type of thing that I have been trying to get the upper management to understand for a little...

Thanks Everyone

That worked. I have never had a reason to use the DateTime2 datatype, so I did not recognize it.

Great appreciate your help

Andrew SQLDBA

Thank You Everyone

Ok, I have been reading up on Grouping Sets, but I still am not getting it. How would one go about writing a query to work correctly with...

Anthony

Thanks is perfect.

Thank You. I greatly appreciate that. I never thought to use cube.

Andrew SQLDBA

HI Gail

This is just in there WHERE clause, just as shown in the example. Since no list tables are being used, all this data in this one column is coming...

Thank You Peter

Very handy to know.

Andrew SQLDBA

Thank You Sean

That worked perfectly.

Greatly appreciate it

Andrew SQLDBA

Same way you would Cut, Copy and Paste any where else:

Ctrl + X

Ctrl + C

Ctrl + V

Andrew SQLDBA

Yes, that is exactly what I need / want. I mean, there will not be 2 million different LabNames, but one userID could have 3, and another have 30 -...

I found that out about the table variable, so i now use a temp table. Not a big deal. I would much rather use a table variable, especially for this...

Thanks Captain

That is exactly what I ended up doing. I found it in the SQL BOL right after posting on here.

Thanks for your time and suggestion, it works perfectly

Andrew SQLDBA

The thing of the data is this. I have no idea what will be in that column, so a case statement will not work, that I see.

And there are many...