t.brown 89142 (9/25/2012)

---

Yes dynamic SQL would seem appropriate.

Basically you create your entire SQL Statement in a string then call EXEC on it.

e.g.

DECLARE @SQL Varchar(MAX);

DECLARE @TODAY Varchar(10);

SELECT @TODAY = CONVERT( VARCHAR(10),GETDATE(), 120);

SET @SQL = 'Create table emp_hrs as

(select count(emp_hours) from Emp_table where emp_name=''BOB'' and func_date=''' + @TODAY + ''')'

EXEC (@SQL)

You can then chain all 15 of these together into a single stored procedure.