Database

CREATE PROCEDURE RecurringDates_ThirdSunday
   (
      @Start DATETIME,
      @End DATETIME
   )
   AS
    DECLARE @curDt DATETIME
    SET @curDt = @Start
    
    DECLARE @t TABLE (GoodDate DATETIME NOT NULL)
    
    WHILE DATEPART(dw,@curDt) != 1
    BEGIN
        SET @curDt = DATEADD(dd,1,@CurDt)
    END

    SET @curDt = DATEADD(dd,14,@CurDt) 

    WHILE @curDt <= @End
    BEGIN
 	INSERT INTO @t (GoodDate) VALUES (@curDt)
        SET @curDt = DATEADD(dd,21,@CurDt)
    END
    
    SELECT *
    FROM @t

DECLARE @IntVariable INT<br />
DECLARE @SQLString NVARCHAR(500)<br />
DECLARE @ParmDefinition NVARCHAR(500)<br />
<br />
/* Build the SQL string once.*/<br />
SET @SQLString =<br />
     N'SELECT * FROM pubs.dbo.employee WHERE job_lvl = @level'<br />
SET @ParmDefinition = N'@level tinyint'<br />
/* Execute the string with the first parameter value. */<br />
SET @IntVariable = 35<br />
EXECUTE sp_executesql @SQLString, @ParmDefinition,<br />
                      @level = @IntVariable<br />
/* Execute the same string with the second parameter value. */<br />
SET @IntVariable = 32<br />
EXECUTE sp_executesql @SQLString, @ParmDefinition,<br />
                      @level = @IntVariable<br />

CREATE PROCEDURE sp_GetList
@condition varchar(50)
AS

exec('SELECT * FROM Table_X WHERE ' + @condition)