Original Sproc
	
	CREATE PROC testProc
	as
		SELECT stuff FROM myTable
		WHERE which_stuff = "my stuff"
        go
        
        New Proc (myTable has a historic equivalent)
        
        CREATE PROC testProc_hist
        (
        	@hist_date	datetime
        )
	as
		SELECT stuff FROM myTable_hist
		WHERE  which_stuff = "my stuff"
		AND    hist_date = @hist_date
        go

##</code><code>##

        Original Sproc
        
        CREATE PROC testProc
	as
		SELECT stuff FROM myTable
		WHERE  which_stuff = "my stuff"
        go

        Modified Sproc

        CREATE PROC testProc
	as
		SELECT stuff FROM myTable
		WHERE  which_stuff = "my stuff"
		AND    is_deleted = 'N'
        go