Dynamically input columns feilds in a select stmt

[Daksha12]

declare @qtr1 varchar(100)
set @qtr1='q107,q207'
-- this is an array input from the parameters selected on the front end of an application (q107,q207 are the quarters choosen) The number of quarters may vary based on selection.

select seller,sum(q107) q107,sum(q207) q207 from table_Seller
group by seller
having sum(q107+q207) <> 0

plz tel me how to dynamically generate the format "sum(q107) q107,sum(q207) q207 " in a select stmt in MSSQL 2005 server.

[Motoma]

declare @qtr1 varchar(100)
set @qtr1='q107,q207'
-- this is an array input from the parameters selected on the front end of an application (q107,q207 are the quarters choosen) The number of quarters may vary based on selection.

select seller,sum(q107) q107,sum(q207) q207 from table_Seller
group by seller
having sum(q107+q207) <> 0

plz tel me how to dynamically generate the format "sum(q107) q107,sum(q207) q207 " in a select stmt in MSSQL 2005 server.

How are you getting those values in the first place?

[Daksha12]

How are you getting those values in the first place?

the values are from the fornt end of an application there are check boxes for q107,q207,q307 etc.
the database has vales for these quarters .But the quarters have to be displayed in pivot format.

[srinit]

declare @qtr1 varchar(100)
set @qtr1='q107,q207'
-- this is an array input from the parameters selected on the front end of an application (q107,q207 are the quarters choosen) The number of quarters may vary based on selection.

select seller,sum(q107) q107,sum(q207) q207 from table_Seller
group by seller
having sum(q107+q207) <> 0

plz tel me how to dynamically generate the format "sum(q107) q107,sum(q207) q207 " in a select stmt in MSSQL 2005 server.

hi use this code
[code]



while(charindex(',',@qtr1)>0)
begin
set @abc=charindex(',' ,@qtr1)
set @xyz=@xyz+''+'sum('+left(@qtr1,@abc-1)+') ' +left(@qtr1,@abc-1)
set @qtr1=right(@qtr1,len(@qtr1)-@abc)
set @lmn=@lmn+'+'+left(@qtr1,@abc-1)
end
set @xyz=@xyz+''+'sum('+@qtr1+') '@qtr1
exec('select '+@xyz+' from table_Seller
group by seller
having sum(@lmn))