DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
dbartley 8/10/2013 10:23:11 AM

Quick SQL question

Quick question what does it mean when it says tsl? I can’t find it as a view, table, stored proc nothing!

 

 

update tsl
set                          tsl.PABILRATE = erl.PAProfitAmount
                                ,tsl.PAORIGBILLRATE = erl.PAProfitAmount
                                ,tsl.PA_Base_Billing_Rate = erl.PAProfitAmount
                                ,tsl.PAORIGBSBILLRTE = erl.PAProfitAmount
                                ,tsl.PATotalProfit = tsl.PAQtyQ * erl.paprofitamount
                                ,tsl.PAORIGTOTPROF = tsl.PAQtyQ * erl.paprofitamount
                                ,tsl.PAACREV = tsl.PAQtyQ * erl.paprofitamount
                                ,tsl.PAORIACCRREV = tsl.PAQtyQ * erl.paprofitamount
from PA30101 tsl

 

Version: Unknown or N/A
Section: SQL Scripts