Thanks for the suggestions guys - it seems that when you use Excel as the provider, any aggregration cell can be double clicked on, and when double-clicked, it shows all...

Steve,

How do I do that? So each measure (such as Installed, Activated, Renewed, etc) would be a 'distinct count' - but how do you tie it to a license?...

stevefromOZ,

Thanks for your response. I have since decided to merge the two types of events into one (saletypes and events) as Daniel Stated - and they can heirarchical. So it...

The grain for the sale event is not the count of licenses - it is also a license (or the sale itself). does that make sense? In the RDBMS, the...

Awesome - but my table is a accumulating snapshot fact table, and so I have multiple rows with the same order. Can I still do this then?

isn't this kind of restricting? If I had to add a new status, wouldn't I need to add a new field, and then update it all? Or is that headache...

Tried - no dice 🙁

I can try it, but I've tried it previously. It doesn't help because they aren't actually used in the where statements....

I can break it up if need be, but majority of my calls are in the 'else' part - basically, the @componentType is null in most of the cases...

@Gail - I tried the instructions from the post, but no additional grid was returned..

SET STATISTICS PROFILE ON

GO

exec GetEntitlementResponse @bios = N'None', @computerName = N'OWNER-B23156214', @diskVolume = N'4472755e',

True - I will set it up.. Thanks !

Do you know where @winNumbers gets stored when it is declared as 'TABLE' - I was actually under the impression that only worked in sql server 2005, but it does...

[]

The combination of the 6 values in the table is unique. In the values from the application, the values may be repeated, but there are 6 distinct parameters coming, and...

The order doesn't matter - we just need the matching values...