How about posting the solution so that everyone can benefit from the knowledge?

I just noticed that the companies are ordered in the "desired results" by the CoID.   To make that happen, here's the code, including the supplied table creation and data insert...

• This reply was modified 2 years, 3 months ago by  sgmunson. Reason: Results got fouled up in formatting

I'm pretty sure you don't need multiple CTE's to accomplish this task.   Given the data supplied in the original post, the following should work (note that varchar(300) is rather wasteful...

• This reply was modified 2 years, 3 months ago by  sgmunson. Reason: o instead of 0 needed fixed
• This reply was modified 2 years, 3 months ago by  sgmunson. Reason: Forgot to include results

I found this topic via a Google search, and it kinda-sorta relates to my issue.   I need a Script Component in SSIS to serve as a...

I found this topic via a Google search, and it kinda-sorta relates to my issue.   I need a Script Component in SSIS to serve as a...

It now appears I may have found the solution:

Row.MyVARCHARMAXColumn.AddBlobData(System.Text.Encoding.UTF8.GetBytes("something")) or

Row.MyVARCHARMAXColumn.AddBlobData(System.Text.Encoding.ASCII.GetBytes("something"))

At least now my script doesn't generate an error for compilation.   We'll see what happens at runtime...

I found this topic via a Google search, and it kinda-sorta relates to my issue.   I need a Script Component in SSIS to serve as a data source...

I found this topic via a Google search, and it kinda-sorta relates to my issue.   I need a Script Component in SSIS to serve as a data source for an...

I'm thinking about this rather differently.   My perception of a system that is based almost entirely on a hierarchy of tags seems like it's mostly a matter of time before...

This is typically something handled by creating a trigger on the relevant tables, and is "on" all the time.   When you need to capture the actions of only a specific...

Just my two cents, but typically, when your SUM aggregates aren't coming out correctly, it's almost always because one of your JOINs is contributing more than one row when it...

Soooo, .... your solution is to...

Yep, what Sergiy said is relevant because just knowing that a given computer is located in France doesn't guarantee that the locale settings are set for French, nor does it...

• This reply was modified 4 years, 1 month ago by  sgmunson. Reason: One more thought

I use one table (call first table) field's value to update another another table (call second table) field's value, but the field of the second table is not fixed,

only...

• This reply was modified 4 years, 1 month ago by  sgmunson. Reason: EDIT: added sentence about no dynamic SQL seen in the original post

You also may want to be sure you completely understand ALL the rules for leave taking, including such possibilities as minimum time between leave-takings.   As a calendar year's length is...