Harish Batchu

Harish Batchu

  • 1.6k
  • 247
  • 9.9k

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'; 

Answers (1)