ng-lightning

-----------------------------------------------------------------------------------
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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s