User Profile

Collapse

Profile Sidebar

Collapse
beancounter
beancounter
Last Activity: Aug 28 '13, 01:41 PM
Joined: Aug 21 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • beancounter
    replied to Derived Table and Aggregate Function Not Working Together
    in SQL Server
    Rabbit,

    Got your message on code tags.

    Your solution worked.

    The query I posted was originally part of a larger query linking this derived table to another table. When it didn't work, I stripped parts of it out to uncover the source of the error.

    Thanks again. I can't tell you how frustrated I was with this!
    See more | Go to post

      Leave a comment:

    • beancounter
      started a topic Derived Table and Aggregate Function Not Working Together
      in SQL Server

      Derived Table and Aggregate Function Not Working Together

      I am trying to get this query using a derived table and an aggregate function to work in Excel Query:
      Code:
      select purordcom.*  from 
(select purOrdDet.PurAcct,
sum(PurOrdDet.ExtCost),PurOrdDet.PONbr from AEMApp.dbo.PurOrdDet PurOrdDet group by PurOrdDet.PurAcct,PurOrdDet.PONbr) as PurOrdCom
      But I get a generic error. So I broke it up into two queries - one stripped of the derived table and the other stripped of the aggregate...
      See more | Go to post
      Last edited by Rabbit; Aug 21 '13, 10:11 PM. Reason: Please use code tags when posting code.
      No activity results to display
      Show More
      Working...