Public feed #602638

Something

public sql v1 · immutable
Raw Edit
·published 2007-07-04 06:11 UTC
rendered paste body
BEGINCREATE TABLE  #letters ( WelderId varchar(3) )INSERT INTO #letters VALUES ('A1')INSERT INTO #letters VALUES ('A2')INSERT INTO #letters VALUES ('A3')INSERT INTO #letters VALUES ('A4')INSERT INTO #letters VALUES ('A5')INSERT INTO #letters VALUES ('A6')INSERT INTO #letters VALUES ('A7')INSERT INTO #letters VALUES ('A8')INSERT INTO #letters VALUES ('A9')INSERT INTO #letters VALUES ('A10')INSERT INTO #letters VALUES ('A11')INSERT INTO #letters VALUES ('A12')INSERT INTO #letters VALUES ('A13')INSERT INTO #letters VALUES ('A14')INSERT INTO #letters VALUES ('A15')INSERT INTO #letters VALUES ('A16')INSERT INTO #letters VALUES ('A17')INSERT INTO #letters VALUES ('A18')INSERT INTO #letters VALUES ('A19')INSERT INTO #letters VALUES ('A20')INSERT INTO #letters VALUES ('A21')INSERT INTO #letters VALUES ('A22')INSERT INTO #letters VALUES ('A23')INSERT INTO #letters VALUES ('A24')INSERT INTO #letters VALUES ('A25')INSERT INTO #letters VALUES ('A26')INSERT INTO #letters VALUES ('A27')INSERT INTO #letters VALUES ('A28')INSERT INTO #letters VALUES ('A29')INSERT INTO #letters VALUES ('A30')INSERT INTO #letters VALUES ('A31')INSERT INTO #letters VALUES ('A32')INSERT INTO #letters VALUES ('A33')INSERT INTO #letters VALUES ('A34')INSERT INTO #letters VALUES ('A35')INSERT INTO #letters VALUES ('A36')INSERT INTO #letters VALUES ('A37')INSERT INTO #letters VALUES ('A38')INSERT INTO #letters VALUES ('A39')INSERT INTO #letters VALUES ('A40')INSERT INTO #letters VALUES ('A41')INSERT INTO #letters VALUES ('A42')INSERT INTO #letters VALUES ('A43')INSERT INTO #letters VALUES ('A44')INSERT INTO #letters VALUES ('A45')INSERT INTO #letters VALUES ('A46')INSERT INTO #letters VALUES ('A47')INSERT INTO #letters VALUES ('A48')INSERT INTO #letters VALUES ('A49')INSERT INTO #letters VALUES ('A50')INSERT INTO #letters VALUES ('A51')INSERT INTO #letters VALUES ('A52')INSERT INTO #letters VALUES ('A53')INSERT INTO #letters VALUES ('A54')INSERT INTO #letters VALUES ('A55')INSERT INTO #letters VALUES ('A56')INSERT INTO #letters VALUES ('A57')INSERT INTO #letters VALUES ('A58')INSERT INTO #letters VALUES ('A59')INSERT INTO #letters VALUES ('A60')INSERT INTO #letters VALUES ('A61')INSERT INTO #letters VALUES ('A62')INSERT INTO #letters VALUES ('A63')INSERT INTO #letters VALUES ('A64')INSERT INTO #letters VALUES ('A65')INSERT INTO #letters VALUES ('A66')INSERT INTO #letters VALUES ('A67')INSERT INTO #letters VALUES ('A68')INSERT INTO #letters VALUES ('A69')INSERT INTO #letters VALUES ('A70')INSERT INTO #letters VALUES ('A71')INSERT INTO #letters VALUES ('A72')INSERT INTO #letters VALUES ('A73')INSERT INTO #letters VALUES ('A74')INSERT INTO #letters VALUES ('A75')INSERT INTO #letters VALUES ('A76')INSERT INTO #letters VALUES ('A77')INSERT INTO #letters VALUES ('A78')INSERT INTO #letters VALUES ('A79')INSERT INTO #letters VALUES ('A80')INSERT INTO #letters VALUES ('A81')INSERT INTO #letters VALUES ('A82')INSERT INTO #letters VALUES ('A83')INSERT INTO #letters VALUES ('A84')INSERT INTO #letters VALUES ('A85')INSERT INTO #letters VALUES ('A86')INSERT INTO #letters VALUES ('A87')INSERT INTO #letters VALUES ('A88')INSERT INTO #letters VALUES ('A89')INSERT INTO #letters VALUES ('A90')INSERT INTO #letters VALUES ('A91')INSERT INTO #letters VALUES ('A92')INSERT INTO #letters VALUES ('A93')INSERT INTO #letters VALUES ('A94')INSERT INTO #letters VALUES ('A95')INSERT INTO #letters VALUES ('A96')INSERT INTO #letters VALUES ('A97')INSERT INTO #letters VALUES ('A98')INSERT INTO #letters VALUES ('A99')INSERT INTO #letters VALUES ('B1')INSERT INTO #letters VALUES ('B2')INSERT INTO #letters VALUES ('B3')INSERT INTO #letters VALUES ('B4')INSERT INTO #letters VALUES ('B5')INSERT INTO #letters VALUES ('B6')INSERT INTO #letters VALUES ('B7')INSERT INTO #letters VALUES ('B8')INSERT INTO #letters VALUES ('B9')INSERT INTO #letters VALUES ('B10')INSERT INTO #letters VALUES ('B11')INSERT INTO #letters VALUES ('B12')INSERT INTO #letters VALUES ('B13')INSERT INTO #letters VALUES ('B14')INSERT INTO #letters VALUES ('B15')INSERT INTO #letters VALUES ('B16')INSERT INTO #letters VALUES ('B17')INSERT INTO #letters VALUES ('B18')INSERT INTO #letters VALUES ('B19')INSERT INTO #letters VALUES ('B20')INSERT INTO #letters VALUES ('B21')INSERT INTO #letters VALUES ('B22')INSERT INTO #letters VALUES ('B23')INSERT INTO #letters VALUES ('B24')INSERT INTO #letters VALUES ('B25')INSERT INTO #letters VALUES ('B26')INSERT INTO #letters VALUES ('B27')INSERT INTO #letters VALUES ('B28')INSERT INTO #letters VALUES ('B29')INSERT INTO #letters VALUES ('B30')INSERT INTO #letters VALUES ('B31')INSERT INTO #letters VALUES ('B32')INSERT INTO #letters VALUES ('B33')INSERT INTO #letters VALUES ('B34')INSERT INTO #letters VALUES ('B35')INSERT INTO #letters VALUES ('B36')INSERT INTO #letters VALUES ('B37')INSERT INTO #letters VALUES ('B38')INSERT INTO #letters VALUES ('B39')INSERT INTO #letters VALUES ('B40')INSERT INTO #letters VALUES ('B41')INSERT INTO #letters VALUES ('B42')INSERT INTO #letters VALUES ('B43')INSERT INTO #letters VALUES ('B44')INSERT INTO #letters VALUES ('B45')INSERT INTO #letters VALUES ('B46')INSERT INTO #letters VALUES ('B47')INSERT INTO #letters VALUES ('B48')INSERT INTO #letters VALUES ('B49')INSERT INTO #letters VALUES ('B50')INSERT INTO #letters VALUES ('B51')INSERT INTO #letters VALUES ('B52')INSERT INTO #letters VALUES ('B53')INSERT INTO #letters VALUES ('B54')INSERT INTO #letters VALUES ('B55')INSERT INTO #letters VALUES ('B56')INSERT INTO #letters VALUES ('B57')INSERT INTO #letters VALUES ('B58')INSERT INTO #letters VALUES ('B59')INSERT INTO #letters VALUES ('B60')INSERT INTO #letters VALUES ('B61')INSERT INTO #letters VALUES ('B62')INSERT INTO #letters VALUES ('B63')INSERT INTO #letters VALUES ('B64')INSERT INTO #letters VALUES ('B65')INSERT INTO #letters VALUES ('B66')INSERT INTO #letters VALUES ('B67')INSERT INTO #letters VALUES ('B68')INSERT INTO #letters VALUES ('B69')INSERT INTO #letters VALUES ('B70')INSERT INTO #letters VALUES ('B71')INSERT INTO #letters VALUES ('B72')INSERT INTO #letters VALUES ('B73')INSERT INTO #letters VALUES ('B74')INSERT INTO #letters VALUES ('B75')INSERT INTO #letters VALUES ('B76')INSERT INTO #letters VALUES ('B77')INSERT INTO #letters VALUES ('B78')INSERT INTO #letters VALUES ('B79')INSERT INTO #letters VALUES ('B80')INSERT INTO #letters VALUES ('B81')INSERT INTO #letters VALUES ('B82')INSERT INTO #letters VALUES ('B83')INSERT INTO #letters VALUES ('B84')INSERT INTO #letters VALUES ('B85')INSERT INTO #letters VALUES ('B86')INSERT INTO #letters VALUES ('B87')INSERT INTO #letters VALUES ('B88')INSERT INTO #letters VALUES ('B89')INSERT INTO #letters VALUES ('B90')INSERT INTO #letters VALUES ('B91')INSERT INTO #letters VALUES ('B92')INSERT INTO #letters VALUES ('B93')INSERT INTO #letters VALUES ('B94')INSERT INTO #letters VALUES ('B95')INSERT INTO #letters VALUES ('B96')INSERT INTO #letters VALUES ('B97')INSERT INTO #letters VALUES ('B98')INSERT INTO #letters VALUES ('B99')INSERT INTO #letters VALUES ('C1')INSERT INTO #letters VALUES ('C2')INSERT INTO #letters VALUES ('C3')INSERT INTO #letters VALUES ('C4')INSERT INTO #letters VALUES ('C5')INSERT INTO #letters VALUES ('C6')INSERT INTO #letters VALUES ('C7')INSERT INTO #letters VALUES ('C8')INSERT INTO #letters VALUES ('C9')INSERT INTO #letters VALUES ('C10')INSERT INTO #letters VALUES ('C11')INSERT INTO #letters VALUES ('C12')INSERT INTO #letters VALUES ('C13')INSERT INTO #letters VALUES ('C14')INSERT INTO #letters VALUES ('C15')INSERT INTO #letters VALUES ('C16')INSERT INTO #letters VALUES ('C17')INSERT INTO #letters VALUES ('C18')INSERT INTO #letters VALUES ('C19')INSERT INTO #letters VALUES ('C20')INSERT INTO #letters VALUES ('C21')INSERT INTO #letters VALUES ('C22')INSERT INTO #letters VALUES ('C23')INSERT INTO #letters VALUES ('C24')INSERT INTO #letters VALUES ('C25')INSERT INTO #letters VALUES ('C26')INSERT INTO #letters VALUES ('C27')INSERT INTO #letters VALUES ('C28')INSERT INTO #letters VALUES ('C29')INSERT INTO #letters VALUES ('C30')INSERT INTO #letters VALUES ('C31')INSERT INTO #letters VALUES ('C32')INSERT INTO #letters VALUES ('C33')INSERT INTO #letters VALUES ('C34')INSERT INTO #letters VALUES ('C35')INSERT INTO #letters VALUES ('C36')INSERT INTO #letters VALUES ('C37')INSERT INTO #letters VALUES ('C38')INSERT INTO #letters VALUES ('C39')INSERT INTO #letters VALUES ('C40')INSERT INTO #letters VALUES ('C41')INSERT INTO #letters VALUES ('C42')INSERT INTO #letters VALUES ('C43')INSERT INTO #letters VALUES ('C44')INSERT INTO #letters VALUES ('C45')INSERT INTO #letters VALUES ('C46')INSERT INTO #letters VALUES ('C47')INSERT INTO #letters VALUES ('C48')INSERT INTO #letters VALUES ('C49')INSERT INTO #letters VALUES ('C50')INSERT INTO #letters VALUES ('C51')INSERT INTO #letters VALUES ('C52')INSERT INTO #letters VALUES ('C53')INSERT INTO #letters VALUES ('C54')INSERT INTO #letters VALUES ('C55')INSERT INTO #letters VALUES ('C56')INSERT INTO #letters VALUES ('C57')INSERT INTO #letters VALUES ('C58')INSERT INTO #letters VALUES ('C59')INSERT INTO #letters VALUES ('C60')INSERT INTO #letters VALUES ('C61')INSERT INTO #letters VALUES ('C62')INSERT INTO #letters VALUES ('C63')INSERT INTO #letters VALUES ('C64')INSERT INTO #letters VALUES ('C65')INSERT INTO #letters VALUES ('C66')INSERT INTO #letters VALUES ('C67')INSERT INTO #letters VALUES ('C68')INSERT INTO #letters VALUES ('C69')INSERT INTO #letters VALUES ('C70')INSERT INTO #letters VALUES ('C71')INSERT INTO #letters VALUES ('C72')INSERT INTO #letters VALUES ('C73')INSERT INTO #letters VALUES ('C74')INSERT INTO #letters VALUES ('C75')INSERT INTO #letters VALUES ('C76')INSERT INTO #letters VALUES ('C77')INSERT INTO #letters VALUES ('C78')INSERT INTO #letters VALUES ('C79')INSERT INTO #letters VALUES ('C80')INSERT INTO #letters VALUES ('C81')INSERT INTO #letters VALUES ('C82')INSERT INTO #letters VALUES ('C83')INSERT INTO #letters VALUES ('C84')INSERT INTO #letters VALUES ('C85')INSERT INTO #letters VALUES ('C86')INSERT INTO #letters VALUES ('C87')INSERT INTO #letters VALUES ('C88')INSERT INTO #letters VALUES ('C89')INSERT INTO #letters VALUES ('C90')INSERT INTO #letters VALUES ('C91')INSERT INTO #letters VALUES ('C92')INSERT INTO #letters VALUES ('C93')INSERT INTO #letters VALUES ('C94')INSERT INTO #letters VALUES ('C95')INSERT INTO #letters VALUES ('C96')INSERT INTO #letters VALUES ('C97')INSERT INTO #letters VALUES ('C98')INSERT INTO #letters VALUES ('C99')INSERT INTO #letters VALUES ('D1')INSERT INTO #letters VALUES ('D2')INSERT INTO #letters VALUES ('D3')INSERT INTO #letters VALUES ('D4')INSERT INTO #letters VALUES ('D5')INSERT INTO #letters VALUES ('D6')INSERT INTO #letters VALUES ('D7')INSERT INTO #letters VALUES ('D8')INSERT INTO #letters VALUES ('D9')INSERT INTO #letters VALUES ('D10')INSERT INTO #letters VALUES ('D11')INSERT INTO #letters VALUES ('D12')INSERT INTO #letters VALUES ('D13')INSERT INTO #letters VALUES ('D14')INSERT INTO #letters VALUES ('D15')INSERT INTO #letters VALUES ('D16')INSERT INTO #letters VALUES ('D17')INSERT INTO #letters VALUES ('D18')INSERT INTO #letters VALUES ('D19')INSERT INTO #letters VALUES ('D20')INSERT INTO #letters VALUES ('D21')INSERT INTO #letters VALUES ('D22')INSERT INTO #letters VALUES ('D23')INSERT INTO #letters VALUES ('D24')INSERT INTO #letters VALUES ('D25')INSERT INTO #letters VALUES ('D26')INSERT INTO #letters VALUES ('D27')INSERT INTO #letters VALUES ('D28')INSERT INTO #letters VALUES ('D29')INSERT INTO #letters VALUES ('D30')INSERT INTO #letters VALUES ('D31')INSERT INTO #letters VALUES ('D32')INSERT INTO #letters VALUES ('D33')INSERT INTO #letters VALUES ('D34')INSERT INTO #letters VALUES ('D35')INSERT INTO #letters VALUES ('D36')INSERT INTO #letters VALUES ('D37')INSERT INTO #letters VALUES ('D38')INSERT INTO #letters VALUES ('D39')INSERT INTO #letters VALUES ('D40')INSERT INTO #letters VALUES ('D41')INSERT INTO #letters VALUES ('D42')INSERT INTO #letters VALUES ('D43')INSERT INTO #letters VALUES ('D44')INSERT INTO #letters VALUES ('D45')INSERT INTO #letters VALUES ('D46')INSERT INTO #letters VALUES ('D47')INSERT INTO #letters VALUES ('D48')INSERT INTO #letters VALUES ('D49')INSERT INTO #letters VALUES ('D50')INSERT INTO #letters VALUES ('D51')INSERT INTO #letters VALUES ('D52')INSERT INTO #letters VALUES ('D53')INSERT INTO #letters VALUES ('D54')INSERT INTO #letters VALUES ('D55')INSERT INTO #letters VALUES ('D56')INSERT INTO #letters VALUES ('D57')INSERT INTO #letters VALUES ('D58')INSERT INTO #letters VALUES ('D59')INSERT INTO #letters VALUES ('D60')INSERT INTO #letters VALUES ('D61')INSERT INTO #letters VALUES ('D62')INSERT INTO #letters VALUES ('D63')INSERT INTO #letters VALUES ('D64')INSERT INTO #letters VALUES ('D65')INSERT INTO #letters VALUES ('D66')INSERT INTO #letters VALUES ('D67')INSERT INTO #letters VALUES ('D68')INSERT INTO #letters VALUES ('D69')INSERT INTO #letters VALUES ('D70')INSERT INTO #letters VALUES ('D71')INSERT INTO #letters VALUES ('D72')INSERT INTO #letters VALUES ('D73')INSERT INTO #letters VALUES ('D74')INSERT INTO #letters VALUES ('D75')INSERT INTO #letters VALUES ('D76')INSERT INTO #letters VALUES ('D77')INSERT INTO #letters VALUES ('D78')INSERT INTO #letters VALUES ('D79')INSERT INTO #letters VALUES ('D80')INSERT INTO #letters VALUES ('D81')INSERT INTO #letters VALUES ('D82')INSERT INTO #letters VALUES ('D83')INSERT INTO #letters VALUES ('D84')INSERT INTO #letters VALUES ('D85')INSERT INTO #letters VALUES ('D86')INSERT INTO #letters VALUES ('D87')INSERT INTO #letters VALUES ('D88')INSERT INTO #letters VALUES ('D89')INSERT INTO #letters VALUES ('D90')INSERT INTO #letters VALUES ('D91')INSERT INTO #letters VALUES ('D92')INSERT INTO #letters VALUES ('D93')INSERT INTO #letters VALUES ('D94')INSERT INTO #letters VALUES ('D95')INSERT INTO #letters VALUES ('D96')INSERT INTO #letters VALUES ('D97')INSERT INTO #letters VALUES ('D98')INSERT INTO #letters VALUES ('D99')SELECT	ASCII(WelderId) + 	ASCII(SUBSTRING(WelderId,2,1)) + 	ASCII(SUBSTRING(WelderId,3,1)) AS 'WeldIdAscii'FROM #lettersEND