Thank you so much for all the help!

I'm sorry - I'm pulling a subset of records into a Temporary Table.

So, the XML parsing is from the temporary table

So, now instead of using an XML Variable, can you use this with a table?  The data is in a table with an activation code associated with multiple licenses stored...

Thank you SO MUCH!  That worked perfectly!

The only message I get is:

Msg 3013, Level 16, State 1, Line 1
RESTORE HEADERONLY is terminating abnormally.

Thank you for the suggestion.  We'd like to avoid any 3rd party software to pull AD data.  I've always been able to just pull it directly and would like to...

I did and I think the issue is that the tables are dbo and the views are a [BI] schema.  I've seen posts where the only option was to create...

Update to my post - I found the group that was giving me grief.  I had checked the db_datareader in the membership group to by windows group .  Even though...

Hi John

This is what I tried:

DECLARE @TEXT varchar(50)
SELECT @TEXT = 'HELLO'

SET LANGUAGE 'Spanish'
SELECT @TEXT

It just gives me back 'HELLO'.

I didn't think it would be the 'best practices' way of doing things. Especially if the dataset is big, pulling in the same dataset twice seemed like a lot...

Sorry about that...let's try this:

CREATE TABLE #tMILESTONE (

CustomerID INT NULL,

LoadDate datetime NULL

);

WITH CTE AS

(

SELECT 11011 AS CUSTOMERID, GETDATE() AS LoadDate

UNION ALL

SELECT 11011, LoadDate + 1

FROM CTE

)

INSERT #tMILESTONE...

I can't add the column b/c I need to query all records between the 1st and 2nd date of the lookup table and add the column 30 to it to...

Yes. I did it myself and it didn't work so I found a walk through example and that didn't work. So, I'm at a loss