Thanks. Your reply got me thinking about it differently.

The answer turned out to be:

Not an AND but adding INNER JOIN to the Second LINE. LOL.

SELECT ...

2 Clarifications please.

I am assuming I put the and here.

SELECT T1.FullUrl, T3.size AS Size, T1.SecondaryContactID, T4.tp_Login, T2.tp_Login AS PSCO, T1.OwnerID

FROM ...

Thanks for all the suggestions. Turns out for this application i just had a typo error.

EXEC ('USE ' + @DataName +

'INSERT INTO #TMP1 SELECT ' + @DataName + '.dbo.Sites.FullUrl,'...

I forgot to mention that once I have the code running I will be using SSRS to allow users to pull updated reports. So Cursor's will not work either...

I am not sure how to use dynamic SQL.

But I found a reference to using CURSOR that does not take an argument as input. So please tell me if...

I found an example that works as a vbscript to run but I want to put this into a T-SQL statement.  There don't appear to be examples that do this. 

Dim...