Thank you. I was just about to do the same thing.

VALUES '12375', 'LA', '10/01/2015' in the #OLDSOURCE table would be an exception since the startdate

is outside the date range for the CustomerID, CategoryCode and startdate/Enddate in the #NEWSOURCE table

Many thanks for the responses/

Understood and thanks again. I had to expand the groupings to 30 to account for all the buckets we found.

Worked like magic... Thank you for your help!

From the data in the table, I need to count the number of ID's that fall into a count range or bucket

which is incremented by 25, i.e. 1-25, 25-50, 51-75,...

I do not need to aggregate any data, just display the data in historical order. This issue is that each subcategory may have more detail lines than the other,...

Thank you. I'll try and tweek the SQL you prepared based on that assumption.

Thank you for your quick and thorough replies. When I ran

the 2nd post SQL, I received the following message

Invalid length parameter passed to the SUBSTRING function.

THANK YOU VERY KINDLY FOR THE ASSISTANCE.

Dollar Types 1 or 2 or both can have a positive dollaramt or one or the other can have a positivedollar amount or dollartype 1 and 2 can both be...

The dollar type does not equal 0. Dollar type can be viewed as a revenue type code. The valid values for dollar type are 1,2, or 3

CHECK OUT THIS LINK: http://www.sqldts.com/272.aspx

It will lead to a download of a free MSI package, DTS BackUp 2000.

It will copy as many DTS packages stored in SQL Server...

Yes. There are 2 of them, separated by a comma and each with a data type of int32.

Josep is correct.  Change the settings for the ODBC DSN so that the

checkbox under Performance -- > Advanced for "Use blocking with a fetch of 1 row is UNCHECKED.