Viewing post 1 (of 1 total)
I think there are two possible solutions.
1.
WITH Data (DataType, Name, Salary, K_DATE)
AS (
SELECT 'Lider', LiderID, LiderSalary, K_DATE FROM #tmpPoorlyDesignedTable
...
September 12, 2008 at 3:13 am
#870831