Thanks for your reply Chris. It feels close but seems to give results where ANY of the search terms match instead of ALL. I'll keep working on it....

Thanks for the help!

The tvf has about 10 nullable parameters, and returns 45 fields many of which are NULL based on which parameters you send in. There is one...

Trust me, you do NOT want to see the tvf! It has been marked as 'technical debt' and is slated for re-engineering both from the db and ui ends....

Christopher, the tvf is actually doing a lot of complicated logic and returning 8 fields as opposed to the simplifed dummy version I created. I need the functionality that...

But I thought you said I had to get rid of the tvf to use the TALLY solution? I can't get rid of the tvf. Did you mean...

The code does work!

Do you think it will be a better performer than the existing cursor code? (which essentially walks RBR-style...

Append the results of multiple calls to a table-valued function. The tvf must be called once for each row in @tblDriver with the value of StartNum.

Hi SSCertifiable,

Just to make sure we're on the same page, you ran the final one with the '--SELECT 0' uncommented? and you still got the error in C#?

The 'SELECT 0' was just a scaled down version of the original SELECT I had there (simplified for debugging purposes)

Ok, I got it. I just had to remove the SUM() from the CTE SELECT and add it to the 2nd SELECT. Thanks to all!

;with DerivedCTE as

(

SELECT RowGroupTitle,...

Because of the SUM() in the CTE SELECT list, don't I need the GROUP BY in the CTE? Which duplicates the icky CASE statement, right? Probably I don't...

Thanks for both responses. Sound like changing it doens't really simplify it so I'll stick with what I have. Good to know the options tho, thanks much!

I think you're right, some numeric default values were changed (to empty string). I'll add the code you suggest to set to zero in the event that value is...

Yes, I do have a unique constraint on OrgId + TypeId + OrgEventCounter. But I'm just trying to handle it gracefully. I don't want the save attempt fail-...

I'm sorry Bruce, I guess I did a bad job of posting the problem to begin with. I have no trigger, so your suggestion is:

-- if there is...