Hi
I have a temp table with 17 columns (Col001 - Col017)
i'm trying to retrieve Col003 but do a union select -1 as
it says must have equal number of expressions in their target, I've tried everything but cannot get it to work
thanks
keith
I have a temp table with 17 columns (Col001 - Col017)
i'm trying to retrieve Col003 but do a union select -1 as
Code:
SELECT DISTINCT PARSENAME(REPLACE(Col003, '/', '.'), 1) AS Expr1
FROM Temp
UNION
SELECT -1, '--All Licence Types--'
it says must have equal number of expressions in their target, I've tried everything but cannot get it to work
thanks
keith