select sp

Hi,
I assume that you need Sp something like this.
Check this

CREATE procedure GoldStar_BalanceMakingCharge_Select
    AS
    declare @value1 int,@value2 int
   
    SELECT  A.ClientID,
   A.Name,
   (SUM(B.MakingCharge)-SUM(C.MakingCharge)) AS SumMakingCharge

 FROM         GoldStar_ClientMaster as A
      Left Outer JOIN  GoldStar_DayBook as B
         ON A.ClientID = B.ClientID
         AND B.IsVaravu = 1
      Left Outer JOIN  GoldStar_DayBook as C
         ON A.ClientID = C.ClientID
         AND C.IsChelavu = 1       

 Where     
 B.IsVaravu = 1
 AND
 C.IsChelavu = 1
 GROUP BY A.ClientID, A.Name 
END

hi
try the fallowing

CREATE procedure GoldStar_BalanceMakingCharge_Select
  (
     @value1 int,@value2 int
    )
      AS
      begin
    SELECT  GoldStar_ClientMaster.ClientID, GoldStar_ClientMaster.Name, GoldStar_DayBook.IsVaravu,
    (select isnull(SUM(GoldStar_DayBook.MakingCharge),0) AS SumMakingChargeV, GoldStar_DayBook.IsVaravu
    FROM         GoldStar_ClientMaster INNER JOIN
                         GoldStar_DayBook ON GoldStar_ClientMaster.ClientID = GoldStar_DayBook.ClientID
    Where      GoldStar_DayBook.IsVaravu = 1
    GROUP BY GoldStar_ClientMaster.ClientID, GoldStar_ClientMaster.Name, GoldStar_DayBook.IsVaravu
    )-(select ISNULL(SUM(GoldStar_DayBook.MakingCharge),0) AS SumMakingChargeC, GoldStar_DayBook.IsChelavu
    FROM         GoldStar_ClientMaster INNER JOIN
                         GoldStar_DayBook ON GoldStar_ClientMaster.ClientID = GoldStar_DayBook.ClientID
    Where      GoldStar_DayBook.IsChelavu = 1
    GROUP BY GoldStar_ClientMaster.ClientID, GoldStar_ClientMaster.Name, GoldStar_DayBook.IsChelavu
    )
 end