Multiple Table Return with Stored Procedure

Question

I have the following stored procedure, it works fine except that when returns all the results it will start over and create another window, it is looping over and over creating table after table with the same results. What could be causing this?

USE [HRLearnDev]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[COL_Run_DOM_Parameters]
@StartDate varchar (50),
@EndDate varchar (50)
AS
SET NOCOUNT ON
SELECT *
FROM dbo.COL_V_GEMS_DOM_FCT
WHERE REC_EFF_STT_DT BETWEEN @StartDate and @EndDate
ORDER BY REC_EFF_STT_DT DESC

EXECUTE COL_Run_DOM_Parameters @StartDate = "2010-03-05", @EndDate = "2011-06-11"

If my answer below is the correct solution, please accept this as the accepted answer. Thanks! — John Kroetch
– John Kroetch, Commented May 7, 2013 at 20:16

John Kroetch · Accepted Answer · 2013-05-07 19:14:27Z

2

I don't think you want to do this within your stored procedure (ie: REMOVE it):

EXECUTE COL_Run_DOM_Parameters @StartDate = "2010-03-05", @EndDate = "2011-06-11"

This indicates the procedure is calling itself recursively, over and over and over ...

(Unless this was mistakenly included, and was just shown as an example of how you WOULD call the stored proc)

answered May 7, 2013 at 19:14

John Kroetch

1,1538 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Multiple Table Return with Stored Procedure

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related