Blank AssignedTo to in docket items created off FastTracks linked to liabilities

From TrialWorks Wiki
Jump to: navigation, search
--JC - 7/15/2010 - 10058294 - Add AssignedTo to Docket items created off FastTracks linked to liabilities
INSERT INTO DocketAssignedTo (DocketID,AssignedTo)
SELECT  Docket.DocketID, Docket.AssignedTo
FROM         Docket LEFT OUTER JOIN DocketAssignedTo ON Docket.DocketId = DocketAssignedTo.DocketID
WHERE     DocketAssignedTo.ID IS NULL AND Docket.AssignedTo IS NOT NULL AND Docket.AssignedTo <> '' AND Docket.FileTab LIKE 'FT:%'