Skip to Content
0
Former Member
Apr 19, 2014 at 02:41 PM

add parameters in store proc + query manager

43 Views

hello, i have a store procedure with 2 date parameter(begin and end), from addon tables. I want to execute from query manager, but, i have errors. I tried with :

/* SELECT FROM dbo.beas_arbzeit T0 */

DECLARE @FechaInicio AS datetime -- also date

DECLARE @FechaFinal AS datetime -- also date

/* WHERE */

SET @FechaInicio = /* T0.anfZeit */ '[%0]'

SET @FechaFinal = /* T0.anfZeit */ '[%1]'

exec dbo.MyProcedureTest @FechaInicio, @FechaFinal

-- FAILED. Error message: 'Document' (RDOC)

Can you help me ? thanks.