sksharma
0 Reputation Points
100% Quality Score
- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
|
i am calling store procedure from MVC, which returns single record only. SP contains: PROCEDURE [dbo].[GetMonthlyReport] @emplID INT = NULL, @month VARCHAR(50) = NULL AS BEGIN IF (@emplID IS NOT NULL AND @month IS NOT NULL) --If Block begins BEGIN SELECT * FROM MonthlyRecord WHERE Month = @month AND EmplID …
|