USE [KN_online]
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[UPDATE_PREMIUM_SERVICE_USER_EXEC] 

AS 
 
DECLARE @d24 datetime

SET @d24 = DateAdd(hh,-24, GETDATE())
UPDATE PREMIUM_SERVICE SET nDays = nDays - 1 where Date > @d24

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[UPDATE_PREMIUM_SERVICE_USER_EXEC]    Script Date: 07/20/2008 17:28:50 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[UPDATE_PREMIUM_SERVICE_USER_EXEC] 

AS 
 
DECLARE @d24 smalldatetime

--- Below \/ = Check if date has been more than 24 hours,
--- If yes then deduct 1 day for Premium 
---             WORKS 100%

SET @d24 = DateAdd(hh,-24, GETDATE())

UPDATE PREMIUM_SERVICE_EXEC SET nDays = nDays - 1 where @d24 > Date


--- Below \/ = Check if Date has been more than 24 Hours, If yes start Begin
---              DONT WORK ATALL

SET @d24 = DateAdd(hh,-24, GETDATE())

if @d24 = getdate()
             
BEGIN

UPDATE PREMIUM_SERVICE_EXEC SET Date = getdate()

END

DECLARE @d24 smalldatetime


SET @d24 = CONVERT(VARCHAR(15) , GETDATE(),102)
SET @d24 = DATEADD(HH,DATEPART(HH,dateadd(MI, 10, GETDATE())),@d24)

UPDATE PREMIUM_SERVICE SET nDays = nDays - 1 where @d24 > Date
UPDATE PREMIUM_SERVICE SET Date = getdate()where @d24 > Date