Hi David

I would use something like this 'cos it's quick...

SELECT X.h_id, MAX(X.l_id), X.ton

FROM #t1 X

INNER JOIN (SELECT h_id, MAX(ton) AS MAXton FROM #t1 GROUP BY h_id) dt

ON dt.h_id...

Try this, Ryan:

SELECT "Agent Group (Name & #)",

"Application (Name & #)",

"Agent (Name & #)",

"Total Calls",

"Total Talk" / "Total Calls" AS "Average Talk",

"Total Hold" / "Total Calls" AS "Average...

Confirmed. Can't remember what the message was, but it suggested that something had changed in our firewall!

Funny thing is, each of the three forums (fora?) I spend most time on...

antonio.collins (2/14/2008)

---

With that many addresses, you might want to look into the USPS address matching system. With it, you can cleanup and standardize mailing addresses, city, state, zips. ...

of course, and the best approach I've seen yet in terms of both accuracy and speed is QA batch. But not everybody is prepared to pay for it....

Simple CASE:

CASE SalesProb WHEN 0 THEN...

Searched CASE:

CASE WHEN SalesProb = 0 THEN...

Searched CASE is more expensive than simple CASE.

Either way you will need a column assignment:

,NewColumn = CASE...END

or

,CASE...END...

D'oh!:blush:

Here's a couple of ideas.

DECLARE @Now DATETIME

SET @Now = GETDATE()

SELECT @Now

SELECT CAST(datepart(yy, @Now) AS CHAR(4)) +

RIGHT('0'+LTRIM(cast(datepart(mm, @Now) as VARCHAR(2))), 2) +

RIGHT('0'+LTRIM(cast(datepart(dd, @Now) as VARCHAR(2))), 2) +

RIGHT('0'+LTRIM(cast(datepart(hh, @Now)...

Blair

Two minuses like this flags the rest of the line as a comment.

Peso's solution is a perfect and extremely elegant solution to the problem as originally described - does...

Karthik

No locks will be held.

Until you do something. What do you want to do with the tables? SELECT? UPDATE? INSERT?

Enter "Isolation level" (without the double quotes) into the search tab...

Nah, pretty sure it...

Curious - can you post what you've tried, with the results?

If not, this will help:

http://www.sqlservercentral.com/Forums/Topic424213-338-1.aspx

😀

Blair Dee (2/5/2008)

---

no, trust me, its not homework - i wish it was. it is for my job - a healthcare facility that uses another area hospital's pharmacy services...

So you're looking to match, one for one, your sales & refunds, and examine what's left?