USP_GET_SHOPPINGCARTDATA_CMSTRANSACTIONS

    create procedure dbo.USP_GET_SHOPPINGCARTDATA_CMSTRANSACTIONS
    (
    @ID nvarchar(50)
    )
    as
    begin
      -- Only take care State: BrowserClosing, CheckoutLoaded, CheckoutAuthorized, Charged, TransactionSaved

        SELECT ID, TRANSACTIONID, DATA, STATUS, TYPE as TYPE FROM CMSTRANSACTIONS  with (nolock)
        WHERE TYPE = 'Payment2_0' AND 
        STATUS IN (2048, 2, 8, 32, 64) AND
        CAST(data as nvarchar(max)) like '%' + @ID + '%'
    end;