A data pump from other object to mssql server.

I'm trying to create a regular monthly download to a staging db which will then populate a warehouse for reporting.

If I can't sort something like this it looks...

Thanks for your help Jesper :-)>

Hi

No worries - I just went wild and produced a set for all the data I have at present.  This could be useful as I envisage having an Access front...

Hi Jesper

Sorry I didn't get back to you more positively on Friday.  It was certainly very helpful.  My script now looks like this:

USE PathData

SELECT d.TestDate, d.Source, d.labid, d.colPK

INTO tblDataNoXXXXX

FROM tblData...

Hi

This looks like it might do it I was just having a look to see if I can add the year to the case statement.

Sorry

Just looked again - can see now.

Hi

I see what you're saying, but what will happen in instances where a source has does not have an entry in the period/s?

Hi

Sorry a few errors in the report, I've just gone back into Excel and make x, site1, labB 8 in Jan and 6 in Feb.  You're right abou the entity...

Hi

After some fiddling about in Excel I've produced the following:

tblData: