Create Proc uspCheckUserSubscriptionstatus
@success bit out,
@userid int
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
UPDATE TblSubscription
SET IsActive = 0
WHERE
(FinishDate < GETDATE()
OR ( MaxNotification < = 0 and MaxArticles < = 0 and MaxVideos < = 0 and MaxEvent < = 0 ))
and IsActive = 1
and UserId = @userid
SET @success = 1
END TRY
BEGIN CATCH
SET @success = 0
END CATCH
END