CREATE PROCEDURE proc_test @p1 datetime, @p2 int = 0 AS SELECT @p1, @p2 ... ldDt = DATE() lnInt = 5 * You can call it using parameters ? SqlExec(lnConn, [EXEC proc_test ?ldDt, ?lnInt]) * Or build a string ? SqlExec(lnConn, [EXEC proc_test '] + DTOC(ldDt,1) + [', ] + TRANSFORM(lnInt))