Database

DECLARE @DaysPassed INT  -- Number of days required for record deletion
SELECT @DaysPassed = DATEDIFF(DD,GETDATE() - 5, GETDATE()) -- Diff in days eg (GETDATE() - 5, GETDATE() = today - (today - 5)
IF @DaysPassed = 5  -- If days paseed = 5 then...
    BEGIN
        SELECT GETDATE() -- Your delete statement can go here.
    END
    ELSE
    PRINT 'I love Code project'   -- If not equal to 5 then....
GO

DELETE 
    [TableName]
WHERE
    [TimeColName] < DATEADD(dd,-5,GETDATE()) AND
    [EmailColName] = 'No'

SkyRunner wrote:

but could you please give the 5 lines of code you are talking about,

INSERT INTO Table1(Column1)
    SELECT  REPLACE(OriginalColumn, '_', '')
      FROM  Table2 t2
            LEFT OUTER JOIN Table1 t1 ON t1.Column1 = REPLACE(OriginalColumn, '_', '')
     WHERE  t1.Column1 IS NULL

SELECT
     REPLACE([ProductName],'_','') AS NewName,
     COUNT(*)
FROM
     [Product] 
GROUP BY
     REPLACE([ProductName],'_','')
HAVING
     COUNT(*) > 1

INSERT INTO [NewProductTable]
(
	[NewProductName],
	[NewCol1],
	[NewCol2]
)
SELECT
	REPLACE([ProductName],'_',' '),
	[Col1],
	[Col2]
FROM
	[Product]
WHERE
        (REPLACE([ProductName],'_',' ') = ProductName) OR
	(REPLACE([ProductName],'_',' ') NOT IN (SELECT [ProductName] FROM [Product]))

yousefshokati wrote:

user that can be mapped to it.