Passing a variable into a stored procedure as part of a column name

[ljevans]

I would like to create a stored procedure for this query.
Can I do this?

My query is in a loop where month_num increments from 1 to 18 and #project_number# is passed from another query:

<set month_num = 1>

SELECT Sum(month#month_num#) AS total_month
FROM .manload.dbo.monthly_manload
WHERE dept IN (50,51,52,55)
and project_number = '#project_number#'

<set month_num = month_num + 1>

 

[tlbroadbent]

declare @month int, @sql varchar(128)

set @month=1

While @month<19
Begin

Select &quot;@sql=SELECT Sum(month&quot; + ltrim(str(@month)) + &quot AS total_month FROM .manload.dbo.monthly_manload WHERE dept IN (50,51,52,55) and project_number = '&quot; + @project_number + &quot;'&quot;

Exec(@sql)

Set @month=@month+1

End Terry

;-) The single biggest challenge to learning SQL programming is unlearning procedural programming. -Joe Celko

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm