Do you need to do this in a SQL query or is it destined for a report ? SSRS/Crystal/Excel?

You...

Steve Jones - SSC Editor (1/21/2014)

---

Done.

Happy to add this, and apologies for not thinking of it.

If you come up with other ideas, please send them to the webmaster (@ domain...

Jeff Moden (1/17/2014)

---

BWAAA-HAAA!!!! Dare I say IT? DARE I? Oh, what the heck...

[font="Arial Black"]"Ahhhhhhh MAGOO! You've done it again." [/font]:-P (Sorry ol' friend... I've been holding it...

Here is a revised version that gives the correct results I think.

with GroupData as

(

-- Gather the groups and item codes together and count how many items in each group

...

Sorry, it is no clearer I'm afraid, unless ...

Are you saying that any works order that has :

more than one occurrence of any single ItemCode, <-- in this case 101

and

that...

DavidKBennett (1/17/2014)

---

MM,

Thanks for your help.

The problem is that a given work order can't just have the codes at all, but must match quantity as well.

So WO #11 has the 101...

David, I still don't understand 11 not matching 4.

Group 4 has two ItemCodes, WOnum 11 has those two codes ???

What is the logic behind it not matching group 4?

That is some excellent work on the testing there Dohsan - well done!:-)

Luis Cazares (1/16/2014)

---

I just love when people continue to post to get better solutions.

Mr. Magoo, it's really nice how you handle the start of a word. However, it might...

I almost have an answer for you, but order number 11 confuses me...why does it not match GroupId 4 (D)?

with GroupData as

(

-- Gather the groups and item codes together...

Have you check the setting of InteractiveMode in your project properties under the debugging section?

Here's one similar to Luis, but handles detecting the start of a word differently and works on nvarchar(4000) input.

create function [dbo].[propercase](@text nvarchar(4000))

returns table with schemabinding

as

return (

with seed1 (a)

as...

Great! Thanks for the feedback.

You have to get a bit inventive and add a parent group to your tablix, with an expression for the "group" value that evaluates to blank for no paging and...