xsevensinzx (7/29/2014)
Aye, I also noticed it was a bit old, but still relevant.I use recursive CTE's in market attribution quite a bit with user events (logs).
Attribution is the process of identifying a set of user actions (“events”) that contribute in some manner to a desired outcome, and then assigning a value to each of these events. Marketing attribution provides a level of understanding of what combination of events influence individuals to engage in a desired behavior, typically referred to as a conversion
That sounds like an interesting user requirement.
Perhaps you could elaborate with some DDL, sample data and an example query?
To quote Jeff Moden's signature:
"Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T."
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St