Ok. Good luck with that project.

Not sure I get what you need but this will procude the requested resultset.

Select ITEM_ID, count(*) as Total from dbo.ITEM_COMP

Also might I suggest that you move from A, B, C... codes to 1,2,3 >> which would be the equivalent bitmask value of the flags? That way you don't...

I don't know why the time is increased. I also know that you can't avoid using temp table in this case because you are populating a table from a...

Go with the lookup table. It's gonna be the simplest way here.

You can always do this

alter table a

add cc1 as a * b

cc2 as a * b + c

....

Assuming that the formulas aren't too complex and that you won't have to...

I see, check out this article for all the info you need :

Optimizing Stored Procedures To Avoid Recompiles

if dateadd("d", CheckValue - 1, DateStart) <= DateEnd then ok else fail end if

Check out the objectproperty function and the properties "ExecIsFirst*"

I think going with the ifs might be the best solution as I don't see any advantages of keeping all possible product codes in the db. Maybe you could...

Can we see the code of the proc (full code).

Select columns, list from dbo.YourTable where id not in (1351, 1353, 1387.......)

Also do you think you could convert this to be used in a stored proc as there are many...

OK I see what you need now... and that query will be ugly as hell but I'll give it a shot.

TBC.

How about you create a #temp table as the staging table? That way they wouldn't see the staging table and you'd get your way for hte row count. Also...

Check the final update statement of the first post of this thread.

Extended challenge for everyone - Answer