Yes it should have been 5.
I should have also said how I want the results! I can just union together

Date    Tag    Value
1/1/2018    A    3
1/1/2018    B    4
1/1/2018    C    5
1/1/2018    calcA    6
1/1/2018    calcB    8
1/1/2018    calcC    10
1/1/2018    X    2

The items highlighted pink are not correct

I think I am close but not close enough 🙁

Instead of 3 rows I am expecting I get 6 with some null values as DataSourceReference for 3 rows. I think...

Problem is that the namespaces are different so I need to declare them as the XML is different between Report Builder 3.0 and Visual Studio BIDS 2008 r2

WITH XMLNAMESPACES (

DEFAULT...

I see usage in this UDF for one way data obfuscation possibly by using the RAND object to randomize the ouput character ensuring the the output of RAND stays within...

GSquared (6/9/2008)

---

For accurate counts of weekdays, I HIGHLY recommend a calendar table. That way, you can include holidays, etc.

create table Calendar (

Date datetime primary key,

constraint CK_Date_NoTime

check...