Viewing 4 posts - 1 through 4 (of 4 total)
Your example doesn't work.
In the left and right joins, Father 3 is displayed.
With the isnull(....), there is no child record in the son table to apply the isnull too, therefore,...
April 23, 2013 at 5:03 am
dbo is the database owner.
Change the database owner using sp_changedbowner.
February 24, 2011 at 9:21 am
Managed to fix this myself, if anyone else has the same problem here's the problem with my code.
In order for the server permissions to work using certificates, you need to...
February 18, 2011 at 4:56 am
Thank you for the reply bitbucket.
This does indeed hide the error message when the file is viewed in Excel, but the values in the cells are still stored as text....
December 19, 2009 at 10:54 am