I'm creating a temp table in a SQL2K SP and am getting the error mentioned in the title.
-- ALL MILLIMAN NAMED RANGES that will be passed to the Milliman Model v2.3.0
IF OBJECT_ID('tempdb..#tmp') IS NOT NULL
drop table #tmp
CREATE TABLE #tmp (
UL_Illus_AV_1 as real,
UL_Illus_AV_2 as real,
UL_Illus_AV_3 as real)
If anyone has any ideas on how to get around this, I'd be appreciative.
Thanks in advance.