How to call stored procedure along with parameter in M Code

[saivina2920]

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..

[amitchandak · Accepted solution]

@saivina2920 , Please refer this for SQL server SP

https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-pow...