Still some clarification needed man....

means are u looking for a query that will accept the category and output the column dynamically

or something else ??????/////

Hi Winslet..

Here is the Stored procedure that hopefully serves what you are looking for....

CREATE PROC dbo.ArchiveData

(

@CutOffDate datetime = NULL

)

AS

BEGIN

SET NOCOUNT ON

IF @CutOffDate IS NULL

BEGIN

SET @CutOffDate = DATEADD(mm, -6, CURRENT_TIMESTAMP)

END

ELSE

BEGIN

IF...

Well this is quite a simple thing sarvesh, whenever ANSI Null is encountered it is considered to be an active tuple while dealing with NOT EXISTS, because of which you...