Forum Discussion
Post ProdigyHow to call stored procedure along with parameter in M Code
I am struggling to call stored procedure along with parameter in M Code .
below is my table :
| StudentID | StudentName | Marks | DOJ |
| 1 | Jame's | 100 | 12/28/2023 10:02 |
| 2 | Steave Smith | 200 | 12/28/2023 11:32 |
| 3 | Waugh | 300 | 12/28/2023 9:02 |
| 4 | Waugh | 400 | 12/28/2023 13:32 |
| 5 | Smith | 600 | 12/28/2023 14:02 |
My stored procedure like below.
EXEC MyStoredProc "TimeParam"1
Example, "TimeParam1" ==> values like (06:00 AM,07:00 AM,....12:00PM) slicer fliter
When i pass the value like "10:00 AM" (TimeParam1), it should return all below 10:00 AM records on the condition with "DOJ" column
how to do this using stored procedure along with parameter in M Code.
I want this solution in stored procedure only.
pls. help.
i want to pass time as parameter from DOJ column through stored procedure.
For example,
if i pass time "10:00" it should show till 10:00 AM records
if i pass time "11:00" it should show till 11:00 AM records
How to do this..
saivina2920 , Please refer this for SQL server SP
1 Reply
- amitchandak
Super User
saivina2920 , Please refer this for SQL server SP