Variables in SQL

-- Create a table Variable
DECLARE @myTable TABLE (
	FirstName varchar(30)
	,LastName varchar(30)
	);
	
	
-- add some records to @myTable
Insert into @myTable (FirstName,Lastname) values  ('John','Smith') 
Insert into @myTable (FirstName,Lastname) values  ('Jane','Doe') 
Insert into @myTable (FirstName,Lastname) values  ('Homer','Simpson') 

-- Query Table Variable
Select * from @myTable

Select allOpen in new window

Hi Jeff Darling,  Thank you for your help.

I have some tables like XX_2013, XX_2014, XX_2015 etc.  I want to select the table based on the @YEAR parameter passed.  It is not a new table I need to create, but need to select an existing one.

Thank you again!

You really can't do that in SQL Server.  SS doesn't allow variable object names.

To be honest, I believe your issue stems from bad design, especially if those tables are identical with data from different years.  They should really be one table with a year column.  Then querying it would be trivial.

OriNetworks,
Thank you for your help.  Please read my comments above and let me know if you think it would create any issue in future.

Thank you again!

Already described.