Everything you need to know about backup and disaster recovery with AWS, for FREE!
UPDATE OMC SET SCID = c.PChart, SCProductID = 9, SCHREID = c.HREID, ETypeID = 2, ChangeID = System_User, ChangeDate = getdate() FROM dbo.OMChart OMC JOIN #cross c ON OMC.MCID = c.HDC WHERE SCID is null DELETE FROM OMChart WHERE MCID IN (SELECT mc.MCID FROM dbo.OMChart mc JOIN #cross c ON mc.MCID = c.PChart WHERE mc.SCID IS NULL)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL 2016: choose separate instances for software install; performance||19||24|
|Upgrade SQL Server 2014 Standard Edition from SQL Server 2012 Standard Edition||14||37|
|SQL Throw Error||7||34|
|Convert VBA UDF to SQl SERVER UDF||4||50|