clear markdown compare help donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 462203 distinct fiddles created so far.

CREATE TABLE DISTRIB_LINE ( BUSINESS_UNIT varchar(20), VOUCHER_ID varchar(20), LINE_NO integer, DISTRIB_LINE integer, TEAM varchar(20) ); INSERT INTO DISTRIB_LINE (BUSINESS_UNIT,VOUCHER_ID,LINE_NO,DISTRIB_LINE,TEAM) VALUES (50001, 99,1,1,100); INSERT INTO DISTRIB_LINE (BUSINESS_UNIT,VOUCHER_ID,LINE_NO,DISTRIB_LINE,TEAM) VALUES (50001, 99,1,2,200); INSERT INTO DISTRIB_LINE (BUSINESS_UNIT,VOUCHER_ID,LINE_NO,DISTRIB_LINE,TEAM) VALUES (50001, 99,2,1,300); INSERT INTO DISTRIB_LINE (BUSINESS_UNIT,VOUCHER_ID,LINE_NO,DISTRIB_LINE,TEAM) VALUES (10024, 24,1,1,400); INSERT INTO DISTRIB_LINE (BUSINESS_UNIT,VOUCHER_ID,LINE_NO,DISTRIB_LINE,TEAM) VALUES (10024, 24,1,2,500); INSERT INTO DISTRIB_LINE (BUSINESS_UNIT,VOUCHER_ID,LINE_NO,DISTRIB_LINE,TEAM) VALUES (10024, 24,2,1,600); INSERT INTO DISTRIB_LINE (BUSINESS_UNIT,VOUCHER_ID,LINE_NO,DISTRIB_LINE,TEAM) VALUES (10024, 24,2,2,700); INSERT INTO DISTRIB_LINE (BUSINESS_UNIT,VOUCHER_ID,LINE_NO,DISTRIB_LINE,TEAM) VALUES (10024, 99,1,1,800);
8 rows affected
 hidden batch(es)


DECLARE @team varchar(20) BEGIN SELECT @team = TEAM FROM DISTRIB_LINE PRINT 'value is' + @team END
value is800
 hidden batch(es)