Viewing 7 posts - 1 through 7 (of 7 total)
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...
March 20, 2014 at 6:29 am
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.
March 16, 2014 at 6:03 am
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...
March 15, 2014 at 11:25 am
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...
May 5, 2010 at 4:10 am
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...
March 12, 2008 at 5:22 am
Ignore this post - fixed
March 4, 2008 at 5:20 am
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...
February 13, 2008 at 1:23 pm