Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @ServobjectGrpcode T_Code_Group03
- ,@SOG1 CHAR
- ,@SOG2 CHAR
- ,@SOG3 CHAR
- ,@DeliveryWarranty INT
- ,@InstalWarranty INT
- SELECT @ServobjectGrpcode='X-R'
- SELECT @SOG1=SUBSTRING(@ServobjectGrpcode,1,1)
- ,@SOG2=SUBSTRING(@ServobjectGrpcode,2,1)
- ,@SOG3=SUBSTRING(@ServobjectGrpcode,3,1)
- SELECT @AfterDelivWarr=ascii(@SOG1)-64 +
- CASE
- WHEN @SOG2='-' THEN 0
- ELSE ascii(@SOG2)-64
- END
- ,@AfterInstallWarr=ascii(@SOG3)-64
- SELECT @AfterDelivWarr
- ,@AfterInstallWarr
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement