I dont know what a wrapper procedure is....

:ermm:

Thanks for that,

Ill have a read of that! Irritatingly I cant work on this one till after 5 O clock so I dont upset any users when Im testing the...

Sorry that was just example code not the actual code Im running, I just forgot to put the commas in.

No problem.

Ive got to wait till after 5 to start testing it properly but when it works Ill create it as a stored procedure and pass it across to the...

Its never as easy as you think it is when you really start working on it 🙂 Ive realised I have 2 situations

/* This will find completely new information for...

I see so I dont really need to use WHILE loops.

I will just go into the tables properly and get it working and Ill let you know when Im...

I see so before you do the update you join both tables using the PER_ID which is what is going to be used to do the update on!

OK so

SELECT PERSON_ID, START_DATE , END_DATE, Type

FROM dbo.ECAF

I think I have a type to send that field too. I can add some criteria later about only grabbing data thats...

No inserts are required. The data should only be updated where a PER_ID exists in the table

Thanks for that!!!

Brilliant :w00t:

Matt Miller (11/26/2007)

---

if you replace this line in the ORIGINAL code I posted

SELECT @SQLBody = ISNULL(@SQLBody+'],[','[') +rtrim(convert(varchar,[run date],112))

FROM testsvcs --also replace here with your table name

with....

SELECT @SQLBody =...

never mind the dynamic right now - what do you get when you run these two statements?

--statement #1select p.* from (SELECT Title,convert(char,Quality_date,112) Quality_date,serviceType,Amountfrom (select Title,Quality_date,TOT_ALL_RECS from DATA_QUALITY_OVERVIEW_TOTALS_AND_PERCENTAGES) p--statement #2select p2.*from...

Just as an extra I put the pivot query as is into 2005 and created a table etc so I amended nothing from the original query. I then ran it...

Hmmm,

big question but when you say Is it "as unvpt"?

where in the script would that go?

Debbie

Thanks for that, Ill have a look........

This PIVOT and UNPIVOT stuff is not much fun :doze: