Got it! But I don't understand it! I hope I never have to write another FOR XML EXPLICT again.

I have attached what works (Followup.txt). I found I...

Thanks. Working on it now ...

Please ignore this; I didn't notice that there is an XML forum here. I have moved my question there.

Jonathan

Actually I am working with 2000.

I have attached "problem.txt" that has my xml as it is, xml that I need to get to and my query.

Thanks very much for any...

"I initially saw the spec the same way James (that's what I get for not READING the spec). The issue was that NULLs do exist in the ID columns in...

Thanks! That does what I need to do without worrying about ANSI_NULLS.

Thanks for the help everyone.

I mean the data can look like this

RoadShowIDRoadShowEventIDSellerIDEmployerID

35NULLNULL567

35345NULL567

35NULL456567

35345456567

I need to find a row based on the input parameters for these four columns.

Thanks again.

Sanity check here ...

The relevant code in my proc looks like this

--First check if this row already exists

IF EXISTS

(

SELECT 1 FROM dbo.tblRoadShowAllocation

WHERE

RoadShowID = @RoadShowID AND

RoadShowEventID...

I agree about NULL not comparing and am not thrilled with I am doing here. The data in this table is really odd, however. In some cases...

Thanks! I was confused about that. Works now.

One thing though; if a user ALTERs the procedure with Managment Studio the server starts the script with SET ANSI_NULLS ON....

If only I had the authority! I really don't like this history approach and it's used all over the place in this db. Oh well .... thanks...

Perfect!

Thanks. I have done this in the past but just drew a huge blank.

JM

I have found my problem!

Unknown to me a group of MEDIUM_DESC were removed from the CODE_PROGRAM table this morning.  They happened to mostly be MEDIUM_DESC with internal spaces and...

Both the temp db and the db of CODE_PROGRAM table have collation = SQL_Latin1_General_CP1_CI_AS.

I have also tried creating the temp table with a SELECT INTO so that I know...

Thanks Peter,

That does not work either!  Here is the DDL

CREATE

TABLE #TempRecordsToCreate

(

ApplicantID

int,

FirstName

nvarchar