We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.