I would also opt for only one Active topics page, not multiple.

It is still so, at while at work I can't use the next page link, while being at home...

Actually I was busy (I hate meetings with controllers)

I guess it is most common to use the identity property on some numeric column as primary key. No problem with it. But as you can have only one clustered...

Hey, today is Friday !!!

Are you a 4 days a week worker ?

I don't know any Delphi, but I don't liked Pascal

You're right on C++, although I've never tried those Borland Products like the builder....

Hey Gabor,

looking for the all inclusive worry-free package?

I doubt you won't find a tool that is best in all of your categories

• fast...

I had this also already on my list. I also like hyperlinks opening in a new window.

Gary,

the solution I posted does not include the 'Rush - 4 weeks' AS TimeFrame in the GROUP BY clause and has a slightly different placement of the brackets (although I'm...

I agree with Steve!

To say, 'I don't know this yet, but I certainly will in a foreseeable future' should be by far better than saying, that you already know virtually...

Actually, here in Germany, you can become subject to legal consequences when your employer finds out that you lied in the interview on your payment or alike.

That's not worth...

I don't know much DTS either, but apart from asking your questions here, BOL and http://www.sqldts.com should help

I for myself think, that this is not the job of the server, but rather the client.

However, several useful ideas you will get here

http://www.google.com/search?q=pivot&btnG=Google+Search&domains=www.sqlservercentral.com&sitesearch=www.sqlservercentral.com

Let's continue on this thread

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=95483

Did you run both procedures under same conditions. I mean did you use

DBCC DROPCLEANBUFFERS

DBCC FREEPROCCACHE.

It might be that the effect you're observing is due to caching

Answering my own question.

There is a UDF and an XP. Wow, that's what I call luxury.