OPENROWSET on sp_executesql with two dynamic parameters

0 votes

1 answer

485 views

sql-server t-sql sql-server-2016 dynamic-sql openrowset

Can someone give me a working example of using OPENROWSET on SQL Server with dynamic SQL (sp_executesql) executing a stored procedure with two parameters as variables, preferably date and integer? I want to use that output and INSERT INTO a temp table

INSERT INTO #t
SELECT * FROM OPENROWSET
(
    SQL Server
    SP with two parameters date and integer)
   
SELECT * FROM #t

Asked by mk SQL (5 rep)

Mar 6, 2024, 07:20 PM
Last activity: Mar 11, 2024, 01:27 PM

OPENROWSET on sp_executesql with two dynamic parameters

Related Questions