That makes more sens... too bad I don't have sql 2k5 to test it.

This might work better :

update MT set

 MT.one = MS.uno

,MT.two  = MS.due

,MT.three  = MS.tre

from dbo.mytable MT INNER JOIN #MySource MS ON MT.dte = MS.dte

where source.type = 'BUY'

I'm normally a performance freak... but since this is a daily report, I guess it won't kill the server to have a suboptimal query

And that's why we usually ask for sample data.  Now let me go buy some new eyes and I'll be right back.  Thanx for letting us know

Change COUNT(*) TO SUM(WorkCounts) depending on your needs, this will give you something to start with :

CREATE TABLE #Demo (UserID INT NOT NULL, ViewDate DATETIME NOT NULL)

INSERT INTO #Demo (UserID,...

I don't wanna be a pain in the *** but that update statement ain't cutting it for me (sql 2000). I don't think this feature was changed in 2k5...

What is the datatype of the time column?

And do you want the count of rows, or the sum of workStartCount?

Or another much less costly solution :

CREATE TABLE #WorkTable (ClientID, RegionID)

CREATE UNIQUE CLUSTERED INDEX IX_WorkTable ON #WorkTable (ClientID, RegionID)

Insert into #WorkTable (ClientID, RegionID)

Select CliendID, RegionID FROM dbo.ClientsRegions GROUP BY...

I don't see how the update can solve the problem.  The update needs to know which row to update (unique id of sort some).  And since there are duplicates in...

Yes it can be done with dbcc inputbuffer () from within the trigger.  However I don't have a code sample.

Thanx, that's all I needed to know!

Seriously guys, can we get the answers to these?

1 -

What do you call 500 lawyers at the bootom of the sea ?

2 -

what do you call a...

Just throwing this out there... don't have any kind of revelant experiance with such a massive amount of data.

Is there any way you could buy an entirely new server, transfer...

I would suggestyou don't focus on that point at the moment.  The best solution is to use a double single quote.  And an even greater solution would be to use...

You're right on track.  Here's the missing step you need :

Select * FROM mwcas INNER JOIN

(Select chartnumber, max(lastvisitdate) AS mLastVisiteDate from mwcas group by chartnumber) dtMax ON mwcas.ChartNumber = dtMax.ChartNumber AND...