Hi,

Yes I am trying to insert rows into the Location table FROM ExternalSource.

Let me try explain it this way:

As the query selects the rows from ExternalSource, it needs to do...

Ok so here is the updated sql for the second insert into the Location table, I think this might help:

select 1 as CompanyID, max(Loc.LocationID) as ParentID, ES.locname2 as LocationName, 1...

Hi

If you look at the source table (ExternalSource) you will see there are two Floor2 under locname2.

Now, a simple distinct will only return one Floor2 I.e.

Floor1

Floor2

However, based on the previous...

Hi,

Thanks for taking the time to get back to me.

I have updated the post to make more sense and per your suggestion.

If there is anything I still missed please let...

Hi Lenny.

I've tried that still no change.

Values in the OrderId column is of int data type.

Perhaps I should just mention that the query executes just fine when I don't use the ISNULL function. Only as soon as I add it I get the error.

Thanks for the reply.

That that cut of my code was a bit incomplete.

Below is a more complete cut:

DECLARE @sqlScript1 VARCHAR(8000)

DECLARE @fileName VARCHAR(8000)

SET @fileName = 'C:\Book1.xls'

SET @sqlScript1 = 'SELECT *...

Thanks for all the replies.

Thats exactly what I was looking for.

R

Gail, thank you, what you said made sense and I reworked the query accordingly.

Thanks for your help.

Hi,

You could look into OPENXML which takes a xml document as parameter

See below for an example to get you started.

DECLARE @idoc int

EXEC sp_xml_preparedocument @idoc OUTPUT, @xmlString

INSERT INTO uClient

FROM OPENXML (@idoc,...

😀 Oh YAY!!!

Thanks guys, this has been buggin me soooo much.

If I think back now I can recall that someone also showed me this technique before, a bit to...

Ahh great 🙁

I just replace the query string back into the OPENQUERY and still it give me:

Incorrect syntax near '+'.

Ok, I did that and yes the query run perfect with the output of SELECT @SQL.

Yes the query run just fine when I hard-coded the value of @month in my original OPENQUERY query.

What am I doing wrong here? :hehe:

Hi,

Thanks for getting back to me.

I did exactly as you recommended, and the sql does infact return exactly what it should.

However, the final step in which I pass the param...