Viewing 15 posts - 2,341 through 2,355 (of 2,442 total)
Brian Burke (9/4/2008)
September 5, 2008 at 7:03 am
rbarryyoung (9/3/2008)
jminette (9/2/2008)
Where database professionals can merge join based on 27 parameters in our stored procedure of compatibility.Hmmm, sounds like a performance problem. 😛
Throw more hardware at it ....
September 4, 2008 at 6:27 am
Great suggestions, but I'm looking to actually update the production db so that rather than just collecting the info, the script will do the work and just populate the correct...
August 28, 2008 at 4:58 am
Sergiy (8/27/2008)
It's easy to give fast response on so well prepared question as yours one. 🙂
Another hint regarding this query:
if it's used much make sure you've got clustered index...
August 27, 2008 at 6:47 pm
Sergiy (8/27/2008)
SELECT H.claimid, H.servunits, MAX(H.revcode) as revcode
FROM #myHead H
INNER JOIN (
SELECT claimid, MAX(servunits) servunits
FROM #myHead
GROUP BY claimid
) DT ON DT.claimid = H.claimid and DT.servunits = H.servunits
GROUP...
August 27, 2008 at 5:46 pm
bitbucket (8/27/2008)
I want to return only one line per claim. I want to know the claimid and revcode for each claim,
Try this as your select statement
SELECT claimid, Max(revcode) AS 'RevCode'
FROM...
August 27, 2008 at 5:39 pm
blandry (8/25/2008)
Timothy (8/25/2008)
Sometimes cheaters don't get their comeuppance.
It's worse than that - look at Major League Baseball. Sammy Sosa, Barry Bonds, Mark MacGwire, Jason Giambi, and so many more...
August 25, 2008 at 1:00 pm
Steve Jones - Editor (8/25/2008)
I think we'd never have societies if we weren't basically good, but there's definitely a lot of room to fall.
I don't know, Steve. If there's...
August 25, 2008 at 9:10 am
Jack Corbett (8/25/2008)It's okay to run that red light because it's midnight and there isn't any traffic.
. . . and I only had two beers, I'm not drunk.
I...
August 25, 2008 at 7:07 am
majorbloodnock (8/20/2008)
Anirban Paul (8/20/2008)
...a lot of companies (Read Management) do not keen of providing quality training to their people....beacuase of fear that employee will leave after training.
...which is, of...
August 20, 2008 at 6:41 am
kathyoshea (8/15/2008)
August 15, 2008 at 11:27 am
Here, they pay tuition reimbursement up to $2500 a year, and if you attend conferences/training they're technically supposed to subtract those costs from your specific tuition reimbursement (total dept budgets...
August 15, 2008 at 6:51 am
Steve & company led you in with "T-SQL Crackerjack Jeff Moden..." on today's feature - does that mean there's a prize in every Jeff? :w00t:
August 15, 2008 at 6:42 am
Cees Cappelle (8/13/2008)
Ian Massy
August 13, 2008 at 8:11 am
Grant Fritchey (8/13/2008)
Jeff Moden (8/12/2008)
August 13, 2008 at 6:48 am
Viewing 15 posts - 2,341 through 2,355 (of 2,442 total)