-----------------------------------------------------------------------------------
Select Max(InvtTranKey) from prod_app.dbo.timInvtTranLog --779246
select NextKey from prod_app.dbo.tciSurrogateKey where TableName='timInvtTranLog' --779247
-----------------------------------------------------------------------------------
--UPDATE prod_app.dbo.tciSurrogateKey SET NextKey=779787 where TableName='timInvtTranLog'
----------------
Select Max(BatchKey) from prod_app.dbo.tciBatchLog --332973
select NextKey from prod_app.dbo.tciSurrogateKey where TableName='tciBatchLog' --332974
-----------------------------------------------------------------------------------
--UPDATE prod_app.dbo.tciSurrogateKey SET NextKey=332672 where TableName='tciBatchLog'
----------------
Select Max(InvtSerialKey) from prod_app.dbo.timInvtSerial --332973
select NextKey from prod_app.dbo.tciSurrogateKey where TableName='timInvtSerial' --332974
------------------------------------------------------------------------------------------------
--UPDATE prod_app.dbo.tciSurrogateKey SET NextKey=152276 where TableName='timInvtSerial'
----------------
Select Max(InvtTranDistKey) from prod_app.dbo.timInvtTranDist --332973
select NextKey from prod_app.dbo.tciSurrogateKey where TableName='timInvtTranDist' --332974
-----------------------------------------------------------------------------------
--UPDATE prod_app.dbo.tciSurrogateKey SET NextKey=1274003 where TableName='timInvtTranDist'
----------------
http://ng-lightning.github.io/ng-lightning/#/components
Like this:
Like Loading...
Related