Hey, is there any way to create dynamic sql variable names? I am looking to do something like array / structure notation in ColdFusion: DECLARE @var1 INT; DECLARE @var2 INT; DECLARE @var3 INT; Then i want to be able to reference it like: @["var" + 2] = 50; SOmething like that? Does anyone know if there is something like that in SQL on MS SQL Server? Thanks, Ben
...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com <http://www.bennadel.com/> Need ColdFusion Help? www.bennadel.com/ask-ben/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263531 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
