Since you already know the last day of the month, I guess you could write a proc passing in that date and in a loop test it for being a...

Taking a second closer look (as PW mentioned), Remi's solution should also work just fine.

Thanks again to all.

Thanks for all the quick replies.  I think PW's solution is the one that fits the bill since in my case when @product_id is null I want to exclude any...

I don't know of any built in function but there are a number of user defined functions mentioned on this site and in the faq that parse a delimited list...

I generally opt for the varchar approach as I find it makes the code more reliable.  When using char you always have to be conscious...

I haven't tested this but it may do the trick for you.  Create a derived table (virtual table) from your union statement that includes the sort column and select from...

When using SQL the only guarentee that records are returned in a particular order is to use Order By.  Otherwise your are dependent on the "habits" of the underlying database...

There are a number of user defined functions that can be found on this site that will parse a delimited string and return a table that can be used in...

Even a simple Where t1.company = t2.company would certainly cause the optimizer to figure out it should drive off of the 188 records in t2.

You definetly need an index at...

It looks like your Insert statement would benefit from a Where clause.  Since you only want records that are in T2 you should state that in the Where clause.  e.g.

Where...

That was very helpful.  Thanks.

ron

This should help.  It's one of the articles posted today.

http://www.sqlservercentral.com/columnists/mcurnutt/datadictionaryfromwithinsqlserver2000.asp