I need to be able to change the column alias returned in a Select depending on a column value, so something like...
CASE WHEN [rTYPE] = 'Risk' THEN rReference as 'Risk Reference' ELSE rReference as 'Issue Reference' END
So it would return the value of rReference in a column called either "Risk Reference" or "Issue Reference"
is anything like this possible - or what would be the better way of doing this?
Hope this makes sense?