Hi,
I want solve a problem following with passing parameter in sql
1) If @MONTH Between(4 & 12 ) Then Month Select between( 4 to 12)
2) If @MONTH Between(1 & 3 ) Then Month Select between( 4 to 1 or 2 or 3)
Select B.REGION_ID, B.DISTRICT_ID, SUM(B.TACKLED_TOTAL+B.COVERED_TOTAL) as 'TARGET'
Into #Temp2 From MPR_STATEMENT_A B
Where B.MONTH =(Case When @MONTH Between 4 and 12 Then (A.MONTH >= 4 and A.MONTH <= @MONTH)
When @MONTH Between 1 and 3 Then (A.MONTH > 4 and A.MONTH <= @MONTH) End)
And B.YEAR = @YEAR
Group by B.REGION_ID, B.DISTRICT_ID
End