CTE's also have bugs and restrictions:

When I run this code, the rows in the newly created table are not in sorted order.

W_CALLS AS

(

SELECT TOP 100 PERCENT

C.CALL_TP_ID

,C.CALL_TYPE

,C.HOUR_INT

,SUM(C.CallCnt) AS CallCnt

,SUM(C.CoreTotal+C.NonCoreTotal) AS ActSales

FROM dbo.V_CONV_HRLY_CALLS_SALES AS C

WHERE C.CALL_DT = @dateparm AND C.Call_TP_ID IN (0,2)

GROUP BY C.CALL_TYPE,C.CALL_TP_ID, C.HOUR_INT

ORDER BY C.CALL_TYPE,C.CALL_TP_ID, C.HOUR_INT

)

SELECT

C.CALL_TYPE

,C.HOUR_INT

,dbo.fnRptHourIntv(C.HOUR_INT) AS HOUR_INTV

,TARG_CALLS

,TARG_CONV

,C.CallCnt

,C.ActSales

INTO dbo.CONV_HRLY_RPT_CONVERSION_TBL

FROM W_CALLS AS C

LEFT JOIN W_TARG AS T ON T.INTV_HOUR = C.HOUR_INT AND T.CALL_TYPE = C.CALL_TP_ID

WHERE TARG_CONV IS NOT NULL

ORDER BY C.CALL_TYPE, C.HOUR_INT

I'm going to try a temporary view....

It appears the ORDER BY is ignored.....and all the TOP 100 PERCENT did is elminate the error message.