Post reply

Calculations error: aggregate may not appear in the set list of an UPDATE statement

  • March 5, 2010 at 2:24 pm

    #1129466

    I've tried all kinds of keys to replace that and it has not been working soo.. phew! 🙂 So I would comment out the EntityID columns, pk's, and joins correct? And not replace it with anything?

    WorkingDayOfMonth only exists in #DT though. 🙁

    ¤ §unshine ¤

  • March 5, 2010 at 2:27 pm

    #1129468

    Yep, delete and not replace it with anything. I assumed this would be on an entity per entity basis, but if you don't care about the entities and only the totals for the time periods, they don't need to be involved at all.

    As far as it only being in DT, that doesn't matter. LastDayOfMonth is only in DT as well and it is used in the second derived table.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • March 5, 2010 at 2:42 pm

    #1129477

    Okie doke Master Seth...

    Working on it today and Monday if I dont finish...

    Thank you and in case I don't get it by the end of day... have a great weekend.

    ¤ §unshine ¤

  • March 5, 2010 at 3:20 pm

    #1129485

    My pleasure, and same to you.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Viewing 4 posts - 16 through 18 (of 18 total)

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