I would like to know if I can create new variables using existing variables in a stored procedure.

To be clear, in the SP I use, I pass table name. But I need the results from 2 other tables as well.

The tables are named 1996, 1997, 1998.......2007.
If I pass 2005 to SP, I need results from 2005, 2004 & 2003. How do I assign or get 2 new table names (variables) for 2004 & 2003 ??


Part of code:
ALTER Procedure [dbo].[XX](
@TblName1 varchar(20),
@Month varchar(3)
)

when I pass 2005 to SP, I need
@TblName1 = 2005
@TblName2 = 2004
@TblName3 = 2003

How can assign 2004 & 2003 to variables TblName2 & Tblname3 ??

I really appreciate any help.

IMO, you dont have to use two more variables, You can have a LOOP within the proc running thrice, starting from the VALUE passed to @TblName1 till ( Value - 2 ), thus you can do the same you do for 2005, with other two tables that are required.

Hope that helps/explains.
Cheers.

_________________________
- Vijay G
Strive for Perfection