Viewing 2 posts - 1 through 2 (of 2 total)
I got it to work with the following code:
select type as 'TYPE',
[ARCHIVED] as 'ARCHIVED',
[AVAILABLE] as...
April 8, 2009 at 12:16 pm
#974570
I have tried variations with IsNull to no avail. I haven't tried with a CTE first as I am not that familiar with it but I will check it out....
April 8, 2009 at 11:52 am
#974557