Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE SPEX_DB;
- IF EXISTS (
- SELECT *
- FROM INFORMATION_SCHEMA.ROUTINES
- WHERE SPECIFIC_SCHEMA = N'spex'
- AND SPECIFIC_NAME = N'SP_AMANAH_RE_FILL_5_CLOSE_BT'
- AND ROUTINE_TYPE = N'PROCEDURE'
- )
- DROP PROCEDURE spex.SP_AMANAH_RE_FILL_5_CLOSE_BT
- GO
- CREATE PROCEDURE spex.SP_AMANAH_RE_FILL_5_CLOSE_BT
- (
- @RESERVE_LOC VARCHAR(MAX),
- @BT_NO VARCHAR(30),
- @USERNAME VARCHAR(20)
- )
- AS
- BEGIN
- DECLARE @MSG_TEXT VARCHAR(MAX) = ''
- DECLARE @RES_TEXT VARCHAR(MAX) = ''
- SET NOCOUNT ON;
- CREATE TABLE #TB_T_DATA (
- RESULT VARCHAR(MAX),
- Message VARCHAR(MAX)
- )
- DELETE FROM TB_T_BUCKET_TRANSFER
- WHERE BT_NO = @BT_NO
- -- UPDATE dbo.TB_R_REFILL SET STATUS = 0 WHERE TRANSFER_NO = @TRANSFER_NO AND BT_NO = @BT_NO
- SET @MSG_TEXT = '';
- SET @RES_TEXT = 'Success'
- INSERT INTO #TB_T_DATA
- VALUES (@RES_TEXT, @MSG_TEXT)
- SELECT RESULT, Message
- FROM #TB_T_DATA
- END
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement