Already have sp's for datasets would prefer not to add third unless no other way is found.
Thanks.

Looked interesting so tried it both ways and I think both statements are correct or should be close enough for you to fix.

=IIF(Fields!CorrespondenceLanguage.Value = "English"...

Follow link for syntax.

https://www.sqlservercentral.com/Forums/1873806/Highlight-every-other-row-based-on-group

Switch is somewhat like the SQL Case statement. Whatever condition it encounters first is used and the rest are ignored. It...

=Switch(RowNumber(AccountNumber) Mod 2 = 0, "HoneyDew", RowNumber(AccountNumber) Mod 2 <> 0, "White")

Okay, thanks for the suggestions.

Rich

All data you would need is there. I don't have any DDL's as this is a sample. The original table if I had one would be the first 5 columns...

Thank you Eirikur for your reply. I am looking at both the methods currently. You have given insight to new processes I have not had a chance to study yet...

Thank you Luis and Mark for replying. Your advice was great however I have an unusual issue so I thought I would explain so you can see it better. I...

Sorry, I will, just assumed this would be the correct place.

Thanks,

Rich

This is in the code and the sample I am using to develop the custom split, Set @pString='CS12_PrbTmp_L_DegF_1M'.

I forgot to mention I do have a PK column for ID in...

I need some help if someone is willing. I'm not a professional DBA however with Google as your friend anything is possible. My issue is that I have a table...