John Carter, great family movie:w00t:

I agree with wrboyer123 - will it even be possilbe to write upgrade exams for 2008 certificate holders?

thanks Pouliot, I did read the stairways SSIS topics and it helped me a lot, just struggling with the above - and so far my google hunt is not helping...

@ninja's_RGR'us - this will help me - great work - thanks

thanks Jeff - thats my problem - I am still on level 80

'The current compatibility level is 80.'

Thanks for all the help - will check what the implications are to...

will...

Using SQL 2008 - copied this info from SQL "about" form:

Microsoft SQL Server Management Studio 10.0.4000.0

Microsoft Analysis Services Client Tools 10.0.4000.0

Microsoft Data Access Components (MDAC) 6.1.7600.16385

Microsoft MSXML...

thanks WayneS - will read the links - but will a pivot \ crosstab work for my scenario because I am not looking to sum, count etc values - I...

it will differ from employee but max will be 10 - Thank you

I have removed the "big spaces" and PF5 the sql qry but still get the Incorrect syntax near 'PIVOT' error - do you think it could be my SQL thats...

Hi,

Newbie here - I am trying to run the simple pivot demo as on one of the above post (copy and paste) and I am getting the error:

Msg 170, Level...

Great article Jeff (The "Numbers" or "Tally" Table: What it is and how it replaces a loop.) - have used your example and my query works and the results are...

Thanks Parthi - much appreciated

Spaces???

Dave undersood...

Thanks for the quick response Dave - will have a look at the links when I get home - company is blocking the site :crying: