I had been scratching my head over this for 2 days. For me it was char 56. Copying the string to Notepad and stripping out the spaces worked for me...

I'm looking for the version I want right now. There is no person.contact table in AdventureWorks2012. Well, not the version I've got.

No, still totally confused. I have AdventureWorks 2008, 2008R2 and 2012 and the person.person and person.contact tables are all the same in these versions but they are not the same...

Thanks for the advice - very useful. I will probably do the MCTS first as I can't take to much time out and go for the MCITP at a later...

I already have something very similar. I probably didn't make myself clear enough but what happens it that as soon as the preview button is pressed the report runs immediately...

Ignore this post - fixed

Thanks guys so much for your help. The nested sub-query with aliases did the trick in the end.

I feel pretty overwhelmed as I am trying to learn SQL Server, T-SQL...