I thought that the Express Edition had edition specific tools, but I don't use it, so I could be mistaken.

I'd still highly recommend that you request the tools from those who are...

Try single quotes instead of those double quotes.

I don't have an alternate method as I'm still trying to wrap my head around why you'd want to do this. I can see where you might want to store...

Unless you have an MSDN subscription, I don't think there is a URL you can get that from. You can install it from a remotely mounted CD/DVD though, so I'd...

Ezhilan, is there a reason for the two converts in your statement? They seem superfluous to me, as you are converting back into a datetime in the end, so the...

The quick and dirty way is to wrap a cursor around the thing (you'll hear about the evils of cursors, but it's 50 rows, so I wouldn't sweat it too...

For 2000, assuming your sorting issues are truly basic (i.e. dynamic primary sort column, fixed secondary/tertiary/quaternary/etc. sort), then as Ray says, make it a parameter. We used to offer drop...

I'm still slightly confused. If you want to run it for each country individually, why are you grouping on country code, and also why are you grouping on Top 8,...

How are the 50 countries in question currently stored? A variable, in a table, on a piece of paper, etc?

Also, do you want the top 8 for each country, the...

Since you're using DMVs, I'm assuming this is on SS2005. If so, does the following return what you want?

SELECT

ms_ticks / 1000