Subquery related issue

Question

1.00/5 (1 vote)

See more:

SELECT CD.FirstName+''+CD.MiddleName+' '+CD.LastName as Name,CD.MobileNumber,CD.email,CD.RegisterDate,BD.DC_Bill FROM Customer_Details CD LEFT JOIN (SELECT CustomerID,SUM(DC_Bill) AS [DC_BILL] FROM Bill_Details GROUP BY CustomerID) BD ON CD.CustomerID = BD.CustomerID

I already have the above query.
now how do i select DC_Bill within a date range and then summarize the value?

Now i can have all the DC_Bill details using these above query but i want to get only some selected value within a date range.

Please help me to solve these.
Thanks in advance

Posted 15-Feb-12 1:14am

sahabiswarup

Add a Solution

Comments

Herman<T>.Instance 15-Feb-12 7:19am

have you tried:
SELECT CD.FirstName +' '+ CD.MiddleName+' '+ CD.LastName as Name,
CD.MobileNumber,
CD.email,
CD.RegisterDate,
SUM(BD.DC_Bill) as DC_BILL
FROM Customer_Details CD
LEFT JOIN Bill_Details BD ON CD.CustomerID = BD.CustomerID
GROUP BY CD.FirstName +' '+ CD.MiddleName+' '+ CD.LastName, CD.MobileNumber, CD.email, CD.RegisterDate

sahabiswarup 15-Feb-12 23:04pm

it works perfectly..
thanks..

sahabiswarup 15-Feb-12 23:07pm

The final query is like
SELECT CD.FirstName +' '+ CD.MiddleName+' '+ CD.LastName as Name, CD.MobileNumber, CD.email, CD.RegisterDate, SUM(BD.DC_Bill) as DC_BILL FROM Customer_Details CD LEFT JOIN Bill_Details BD ON CD.CustomerID = BD.CustomerID WHERE BD.Bill_Date Between '02-11-2012' AND '02-12-2012' GROUP BY CD.FirstName +' '+ CD.MiddleName+' '+ CD.LastName, CD.MobileNumber, CD.email, CD.RegisterDate

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RDBurmon · Answer 1 · 2012-02-15T01:36:00

Try this

SQL

SELECT
    CD.FirstName+''+CD.MiddleName+' '+CD.LastName as Name
    ,CD.MobileNumber
    ,CD.email
    ,CD.RegisterDate
    ,SUM(BD.DC_Bill)
FROM Customer_Details CD LEFT JOIN Bill_Details BD ON CD.CustomerID = BD.CustomerID
WHERE BD.Billdate Between @StartDate AND @EndDate
GROUP BY CustomerID

Hope this helps if yes then accept and vote the answer
--Rahul D.

Subquery related issue

1 solution

Solution 1

Add your solution here

Preview 0

Subquery related issue

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us