MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
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