It was a fun one to bend my mind around to clear my head of my current problems. Take it easy.

Loop != Cursor

If you wanted to do this in a single select query, you would have to anticipate the maximum "times transferred" and use that many left joins - 1,...

SELECT [A],

INTO [#Temp1]

FROM

(

SELECT 1 AS [A], 2 AS

UNION

SELECT 2 AS [A], 3 AS

UNION

SELECT 5 AS [A], 7 AS

UNION

SELECT 7 AS [A], 8 AS

UNION

SELECT 8 AS...

Joel, my guess is this query result was not your idea. You may want to consider, using a UNION, this format.

John Site 1 NY

John Site 1 CT

John Site 2...

As I stated above: "Next there needs to be an assumption made that the names are grouped together and in order of significance... of course the order may not be...

There are 2 options for you...

#1 Add an ID field to each table

or #2 Create temp tables when you run the query and insert the data. You can search...

2 ways to acheive this. The first would be to create a x-ref table of sql-user to NT user. When you run the INSERT/UPDATE/DELETE trigger, you would just...

Shawn, I think he is holding out on the extent of the table. There is probably multiple names, in which case makes the ID field not useful (at least directly).

Next...

First off, kudoz to Siva! I have a more clear picture now that I can better read through the log. I definitely have a bit of reworking to...

Adrian,

To put it simply... WOW!

I will look this through when I get time later (hopefully). I hate finding short-comings in MSSQL, because they drive me nutzo as well.

Oh, I am sorry! I read that wrong! I thought you meant to move the "PRINT" inside the cursor loops. If you move the EXEC inside, you...

yeah, which removes the automation portion of it. It's still better than nothing 🙂

the limitation of characters for a varchar to 8000 doesn't help here. and you cannot use text as a local variable. Also appears you need to use sp_sqlexec....

Thank you Carl. IS_SRVROLEMEMBER kept slipping my mind and I couldn't find it on MSDN.

Cheers!

-Kevin

WINNER! WINNER! CHICKEN DINNER!