August 20, 2008 03:36am pdt

1. chapmandew 1,838,691
2. angelIII 1,445,073
3. aneeshatti... 550,115
4. mark_wills 544,656
5. ScottPletc... 367,386
6. ee_rlee 348,824
7. dtodd 278,051
8. acperkins 258,489
9. EugeneZ 247,314
10. Thomasian 153,038
11. cs97jjm3 149,400
12. appari 139,648
13. matthews... 138,203
14. BrandonG... 137,837
15. dbaSQL 124,394
16. ptjcb 119,637
17. brejk 118,990
18. rickchild 116,275
19. momi_sa... 111,935
20. bhess1 110,305
21. dportas 109,530
22. dqmq 108,874
23. MohammedU 105,175
24. asvforce 103,642
25. nmcdermaid 100,768

1. angelIII 10,401,486
2. aneeshatti... 4,607,994
3. acperkins 4,246,949
4. ScottPletc... 4,181,438
5. arbert 2,245,195
6. Lowfatsp... 2,165,176
7. chapmandew 1,838,691
8. EugeneZ 1,523,476
9. rafrancisco 1,460,132
10. imran_fast 1,458,963
11. Hilaire 1,221,775
12. Nightman 1,143,404
13. Mr_Peer... 1,087,815
14. nmcdermaid 1,085,352
15. ptjcb 1,053,496
16. bhess1 1,047,297
17. dtodd 864,394
18. Sirees 774,152
19. adathelad 766,312
20. appari 726,885
21. BriCrowe 722,959
22. amit_g 683,229
23. matthews... 660,535
24. ShogunW... 619,598
25. Kevin3NF 590,766

04.30.2008 at 12:36PM PDT, ID: 23366570

	[x] Attachment Details

How to group derived values in a select statement ?

Asked by stevejebson in MS SQL Server

Tags: microsoft, sql server, 2005

Hi Experts,

I have a table Transaction that is linked in a one to many on TransactionLabourItem. Each TransactionLabourItem has a Qty and Rate so i can calculate the derived Cost as Qty * Rate, easy peasy

I'd like to write a select statement that returns 1 row per transaction that has a total Cost per Transaction but i can't group by Cost as it's derived and Sum would sum the whole table, i'm scratching my head here, how do i do it ??

thanks in advance...Start Free Trial

Keywords: How to group derived values in a selec…

	Title
1	Derived Calculation
2	derived data
3	Derived Attributes
4	Help with SQL statement with derived f…
5	Arithmetic using derived values in a SE…
6	Update with Derived tables

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

How to group derived values in a select statement ?

Asked by stevejebson in MS SQL Server

Tags: microsoft, sql server, 2005

About this solution