FYI - I have been using the following query to find the percentage of each Event but after this I cannot find a way to use these Event percentages to...

What would be the sorting order to get the "top x" to apply the new events?

We can use the "datecreated" for the sorting order

What is the business rule in case...

This is what I require:

if 10% = 0, 20% = 1, 20% = 2, 20% = 3 and 30% = 4 then for the IDs that do not have an...

[highlight]A Small correction in the Create statement the Event field should be an INTEGER not a BIT because bit can store only 1's and 0's[/highlight]

Thank you for pointing that out....

I just got the solution to the above problem I had posted. If any of you have a better solution then please post it. The solution is:

SELECT

ID,

Datecreated,

EVENT,

CASEWHEN EVENT =...

You guys are awesome. Thank you for helping me out with this. Also, next time I want any help I will post a table with data in it so as...

I meant comments in SSMS where you write the query. But I just found out how to do it...

Go to tools in the menu bar in SSMS...choose options....Expand Environments....Click on...