Sql

try like this type of code.

;with customerlist(csid,companyname)
as
(
 select distinct  CustomerID ,CompanyName from tbl_Customer
 --inner join tbl_LoginHistory lh on c.CustomerID=lh.Fk_customerID
),
monthtotallogin(csid,monthlycount)
as
(
select fk_customerid as csid,count(*) monthlycount from tbl_LoginHistory
 where MONTH(login_time)= @month and year(login_time)=@years group by Fk_customerID
),
totalcount(csid,totallogincount)
as
(
select fk_customerid as csid,count(*) as  totallogincount from tbl_LoginHistory group by Fk_customerID
),
Totalorderofmonth(csid,monthlyordercount)
as
(
select CustomerID as csid,COUNT(*) as monthlyordercount  from tbl_OrderHeader
 where MONTH(OrderDate)= @month and year(OrderDate)=@years and TransactionStatus='Successful'   group by CustomerID 
),
Totalordero(csid,ordercount)
as
(
select CustomerID as csid,COUNT(*) as monthlyordercount  from tbl_OrderHeader group by CustomerID  having CustomerID>0
)


select CS.companyname as [Company Name],isnull(ML.monthlycount,0) as [This Month Total Login],isnull(TL.totallogincount,0) as [Total Login Till Date],isnull(TM.monthlyordercount,0) as [Total Order this Month], isnull(TOR.ordercount,0)as [Total Order Till Date] from customerlist cs
left join monthtotallogin ML on cs.csid=ML.csid
left join totalcount TL on cs.csid=TL.csid
left join Totalorderofmonth TM on cs.csid=TM.csid
left join Totalordero TOR on cs.csid=TOR.csid



end

Hi Devoloper,

I bit of understand your question you have three tables
Sales_Master
Sales_Discount_Point_Details
Customer

group by not working working different column like that a address,customer name and so on.

you need a CTE. share your tables structure