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_13_PARTNO_VALIDATE'
- AND ROUTINE_TYPE = N'PROCEDURE'
- )
- DROP PROCEDURE spex.SP_AMANAH_RE_FILL_13_PARTNO_VALIDATE
- GO
- CREATE PROCEDURE spex.SP_AMANAH_RE_FILL_13_PARTNO_VALIDATE
- (
- @PART_NO_CURRENT VARCHAR(MAX),
- @PART_NO_SCAN 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)
- )
- EXEC spex.usp_CutPartNo @PART_NO_SCAN OUTPUT
- IF (@PART_NO_CURRENT = @PART_NO_SCAN)
- BEGIN
- SET @MSG_TEXT = @PART_NO_SCAN;
- SET @RES_TEXT = 'Success'
- END
- ELSE
- BEGIN
- SET @MSG_TEXT = 'INVALID PART NUMBER!';
- SET @RES_TEXT = 'Failed'
- END
- INSERT INTO #TB_T_DATA
- VALUES (@RES_TEXT, @MSG_TEXT)
- SELECT RESULT, Message
- FROM #TB_T_DATA
- END
- GO
- EXECUTE spex.SP_AMANAH_RE_FILL_13_PARTNO_VALIDATE '111150Y030', '111150Y030 X', 'AMANAH.Yusup';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement