Help with SQL Query

Question

Help with SQL Query

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

homebrew01 SSC Guru Points: 55566 More actions · Answer 1

It's preferred to copy-paste schemas, code etc into your post instead of as an attachment. Many of us don't open attachments due to virus risks. Use the "Insert/Edit code sample" option.

Hogie503 Mr or Mrs. 500 Points: 543 More actions · Answer 2

Hi,

Sorry rookie mistake, I edited the post to show the table info, hopefully that helps..Thanks

homebrew01 SSC Guru Points: 55566 More actions · Answer 3

homebrew01

SSC Guru

Points: 55566

November 29, 2021 at 6:32 pm

#3957989

Ignore "code" and GROUP BY on Company ID# ?

Michael L John One Orange Chip Points: 27079 More actions · Answer 4

Hogie503 wrote:

Hi,
Sorry rookie mistake, I edited the post to show the table info, hopefully that helps..Thanks

You've been around long enough to know this. In my signature is a link that provides instructions.

Does this work?

WITH CTE
AS
(
SELECT 
YEAR, 
COmpany, 
CompanyID,
Sum(TotalAmount), TotalAmount
MAX(Bid_Limit) BidLimit
FROM Table
GROUP BY 
YEAR, 
COmpany, 
CompanyID
)

SELECT 
YEAR, 
COmpany, 
CompanyID,
TotalAmount,
BidLimit.
BidLimit - TotalAmount Results
FROM CTE

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Hogie503 Mr or Mrs. 500 Points: 543 More actions · Answer 5

Hogie503

Mr or Mrs. 500

Points: 543

November 29, 2021 at 8:15 pm

#3958411

Thank you.. Really appreciate the help...