SELECT Main.* FROM dbo.Table Main INNER JOIN (SELECT DateCol, Max(Qty) AS mQty FROM dbo.Table GROUP BY DateCol) dtMRD ON Main.DateCol = dtMRD.DateCol AND Main.Qty = dtMRD.mQty

I totally see your point about reusability.  But here's why I think it's completely off topic :

When I decide to pass a long list of ids, I do so...

I think he meant 500 MB.

But I'd like to see a tempdb of 500 GB someday .

I know but IIRC, there's either a timeout or a limited amount of growth that can be done in a simgle transaction... I think this is what is happening but...

My guess is that tempdb can't go from 10 to 500 in a single transaction (not 100% sure of this).

The best practice I know about this is to see how...

NP, but I will suggest that you backup the client's registry before importing :-).

Let us know how this works for ya.

Not sure how much this helps... but you can get a list of registered servers on the local pc here :

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X

I'm not srue how I'd go...

I like the idea.  Might take some time out of my year to parse my current list of monitored threads into a favorites thread list... but it's definitly something that...

--setup

IF EXISTS (Select * from dbo.SysObjects where name = 'Numbers' and XType = 'U' and user_name(uid) = 'dbo')

 DROP TABLE Numbers

GO

CREATE TABLE dbo.Numbers (PkNumber int identity(1,1) primary key clustered, dude bit...

Maybe if you try set datefirst when opening the connection.  Maybe that could affect the calendar control (that's a big maybe but you never know...).

Hence the not sure.  I don'T have RS installed here so I can't do any further investigation.

One wy to do it owuld be to write your own activeX control.  Not...

Got any sample code... I'd surely could use that, someday!

That is likely, however maybe the problem was much bigger than we anticipated.

I'm trying to see both sides of the fence here... looks like I'll have to keep using the procs .

Here's one I problem I've solved with cross joins :

From a template containing a start date and end date.  Create all the work tracking reports for each technician that...