fire.angle
چهارشنبه 30 آذر 1390, 16:16 عصر
سلام . مشکل من در قسمت ارسال پارامتره . ولی در قسمت Select که پارامتر NowDate رو ارسال کردم ایراد نمیگیره بلکه ایرادش مربوط به پارامتر NowDate در قسمت having هستش و خطایی Parameter is Object propely ..... رو میده
چیکار کنم ؟
SELECT M.CodeMeli, M.Name, M.Family, R.NumberRp, R.MoneyRp, R.SanadBank, R.Bank, R.DateRp, P.Money, P.Score, P.NameProject, SUM(R.MoneyRp)
AS SumMoneyRp, R.MoneyRp / P.Money * P.Score * dbo.SUBTRACTdate(R.DateRp, dbo.Fdate('2011/01/01')) AS SumScore
FROM dbo.Member M LEFT OUTER JOIN
dbo.Reciept R ON M.CodeMeli = R.CodeMeli INNER JOIN
dbo.MemberINProject MP ON R.CodeMeli = MP.CodeMeli INNER JOIN
dbo.Project P ON MP.CodeProject = P.CodeProject
GROUP BY M.CodeMeli, M.Name, M.Family, R.NumberRp, R.MoneyRp, R.SanadBank, R.Bank, R.DateRp, P.Money, P.Score, P.NameProject
HAVING (SUM(R.MoneyRp) / P.Money * P.Score * dbo.SUBTRACTdate(R.DateRp, dbo.Fdate('2011/12/20')) < 1)
چیکار کنم ؟
SELECT M.CodeMeli, M.Name, M.Family, R.NumberRp, R.MoneyRp, R.SanadBank, R.Bank, R.DateRp, P.Money, P.Score, P.NameProject, SUM(R.MoneyRp)
AS SumMoneyRp, R.MoneyRp / P.Money * P.Score * dbo.SUBTRACTdate(R.DateRp, dbo.Fdate('2011/01/01')) AS SumScore
FROM dbo.Member M LEFT OUTER JOIN
dbo.Reciept R ON M.CodeMeli = R.CodeMeli INNER JOIN
dbo.MemberINProject MP ON R.CodeMeli = MP.CodeMeli INNER JOIN
dbo.Project P ON MP.CodeProject = P.CodeProject
GROUP BY M.CodeMeli, M.Name, M.Family, R.NumberRp, R.MoneyRp, R.SanadBank, R.Bank, R.DateRp, P.Money, P.Score, P.NameProject
HAVING (SUM(R.MoneyRp) / P.Money * P.Score * dbo.SUBTRACTdate(R.DateRp, dbo.Fdate('2011/12/20')) < 1)