I think the invalid object name error would be generated because either a) you have to properly qualify the temp table's name, or b) the temp table is not created...

This should get you started:

DECLARE @Year INT

DECLARE @Month TINYINT

SET @Year = 2003

SET @Month = 1

SELECT * FROM TransTable

WHERE DatePart(yy, TransDate) = @Year

AND DatePart(mm, TransDate) = @Month

SELECT * FROM TransTable

WHERE DatePart(yy,...

In my second post, I got col IN (SELECT) to work fine. You just have to ensure that the variable is of the same basic type as the column...

Just list the columns you do want to display in the SELECT clause.

OK, understood. I know this is probably the last thing you want to hear, but, is there any way to possibly break the process into smaller chunks that can...

Is there a reason you can't use an IF BEGIN END block of code? Why not put this into a stored procedure:

CREATE PROCEDURE DoSomething

@list VARCHAR(1000) = NULL

AS

IF...

Supposing a table, Module, with a smallint field: ModuleCode, the following code works fine when var is set = NULL or to a smallint number:

DECLARE @var smallint

SET @var = 15

SELECT...

quote:

---

It appears the VARCHAR field table takes up less space but will this equal better performance?

---