I am using cross apply against 2 huge tables and I am trying to show the number of customers customers in 3 of the countries US, Canada, UK. When I use my cross apply how do I show the count of customers in the resultset. I have to do a cross apply becoz
I do not have fields that have unique data that I can join on.
Product UK Customer US Customer CA Customer
A 1000 2000 3000
B 0 500 2000
C 1200 2250 0
D 3400 5650 2390
View Complete Post