Litium independent script

Should there be a pending payment captured, the upgrade must be halted until there are no payments pending in the system. 

For an overview of the upgrade procedure, please see how to upgrade to Litium 8. 

IF EXISTS(SELECT NULL FROM dbo.sysobjects WHERE id = object_id(N'dbo.ECommerce_Order') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
    EXEC('IF EXISTS( SELECT *  FROM ECommerce_Order ord INNER JOIN ECommerce_PaymentInfo pay on ord.OrderID =  pay.OrderID
        WHERE pay.PaymentStatus in (1,3,4,9) and DATEDIFF(Day,OrderDate,GETDATE()) = 0)
        BEGIN
             SELECT ''Some order payment created in today need to be completed before upgrade'' as Description, ''Error'' as Type
        END
        ELSE
        BEGIN
             SELECT ''All good!'' as Description, ''Info'' as Type
        END');
END