Harish Batchu

Harish Batchu

  • 1.7k
  • 247
  • 19.2k

I have one question from database?

Oct 14 2018 11:07 AM
I have one query it will get list of month transcations but i need to pass the month from front end. then i will getting an error.
select IncomeType,UserIncomeDetail_Amount from ft_UserIncomeDetail inner join Dim_IncomeType on ft_UserIncomeDetail.IncomeType_Id=Dim_IncomeType.IncomeType_id where MONTH(UserIncomeDetail_Date) = MONTH(GETDATE()) and ft_UserIncomeDetail.User_Uniq='150883940'; 

Brought to you by: JavaScript SDK for Bold BI dashboard and analytics embedding. Free trial.

Answers (1)