ALTER PROCEDURE [Trusts].[proc_MatterNoMatterUno] AS DECLARE @trust_id int DECLARE @trust_matter_no NVARCHAR(65) DECLARE @trust_matter_uno int DECLARE CursorTemplate CURSOR FAST_FORWARD FOR Select TrustID, MatterNo From Trusts.Trusts Where Matter_Uno is null OPEN CursorTemplate FETCH NEXT FROM CursorTemplate INTO @trust_id, @trust_matter_no WHILE (@@FETCH_STATUS = 0) BEGIN SET @trust_matter_no = lower(@trust_matter_no) Select top 1 @trust_matter_uno = Matter_Uno From hbm_matter Where MATT_CODE = @trust_matter_no Update Trusts.Trusts Set Matter_Uno = @trust_matter_uno Where TrustID = @trust_id FETCH NEXT FROM CursorTemplate INTO @trust_id, @trust_matter_no END CLOSE CursorTemplate DEALLOCATE CursorTemplate RETURN
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.