Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
Create Procedure [dbo].[sp_***]( @subdomain_name nvarchar(15), @city nvarchar (25), @state nvarchar (2), @email nvarchar (50) ) AS DECLARE @count int DECLARE @totalCount int SELECT @totalCount = count(*) from navSystemA SET @count = 0 WHILE @count <= @totalCount BEGIN SET @cmd = N'INSERT INTO navSystemAMap (storeID, navID, active) VALUES (select count(*) from navSystemA)+ 1, @count, 1)' SET @parameters ='@subdomain_name nvarchar(15)' EXEC sp_executesql @cmd, @parameters, @subdomain_name SELECT @count = @count - 1 END GO
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!