akshaysanglikar
July 10th, 2003, 08:42 AM
hi friends,
I am having problem, I am having table with got 15 columns and names are like d1,d2,d3,d4,........
I want to write a while loop in store producre which can change the column name dynamiclly e.g
if i declare a veriable and assign some value then column name should be (d+"veriable value")
declare @day int
select @day=1
while @day <=15
update ( table name)
set d+@day = "some value"
please help me
I am having problem, I am having table with got 15 columns and names are like d1,d2,d3,d4,........
I want to write a while loop in store producre which can change the column name dynamiclly e.g
if i declare a veriable and assign some value then column name should be (d+"veriable value")
declare @day int
select @day=1
while @day <=15
update ( table name)
set d+@day = "some value"
please help me