CREATE PROCEDURE test AS 
BEGIN

DECLARE  @ind INT
SET @ind = 100
DECLARE  @ind2 INT
SET @ind2 = 0

DECLARE  @v_query VARCHAR(255)
DECLARE  @str VARCHAR(255)
DECLARE  @str2 VARCHAR(255)
DECLARE  @TableName VARCHAR(255)

BEGIN
WHILE (@ind <=10)
SET @str = CAST(@ind as varchar(255))
SET @str2 = CAST(@ind2 as varchar(255))
SET @TableName = 'dbo.TEMP'
SET @v_query = 'INSERT INTO ' + @TableName + 'VALUES ( ' + @str + ' , ''user' +  @str2 + ''')'  ;

EXEC (@v_query)

SET	@ind = @ind + 1;
SET	@ind2 = @ind2 + 1;

END

END
GO

EXECUTE test

WHILE (@ind <=10)
BEGIN
SET @str = CAST(@ind as varchar(255))
SET @str2 = CAST(@ind2 as varchar(255))
SET @TableName = 'dbo.TEMP'
SET @v_query = 'INSERT INTO ' + @TableName + 'VALUES ( ' + @str + ' , ''user' +  @str2 + ''')'  ;

EXEC (@v_query)

SET	@ind = @ind + 1;
SET	@ind2 = @ind2 + 1;
END

-- Create a numbers table.
CREATE TABLE #N(n INT NOT NULL PRIMARY KEY CLUSTERED );
;WITH N(n) AS
(SELECT 1 UNION ALL SELECT n+1 FROM N WHERE n < 200000)
INSERT INTO #N SELECT n FROM N OPTION (MAXRECURSION 0);

-- use the numbers table to populate the TempValues table.
INSERT INTO dbo.TempValues
SELECT
	n+99,
	'user' + CAST(n-1 AS VARCHAR(32))
FROM #N; 

-- Delete numbers table.
DROP TABLE #N;

-- Create a numbers table.
CREATE TABLE #N(n INT NOT NULL PRIMARY KEY CLUSTERED );
;WITH N(n) AS
(SELECT 1 UNION ALL SELECT n+1 FROM N WHERE n < 149999)
INSERT INTO #N SELECT n FROM N OPTION (MAXRECURSION 0);

-- use the numbers table to populate the TempUsersCreation table.
INSERT INTO dbo.TempUsersCreation
SELECT
		n
		,'NULL'
		,'NULL'
		,'NULL'
		,'NULL'
		,'NULL'
		,'Person'
		,'NULL'
		,'NULL'
		,'ffuser' + CAST(n-1 AS VARCHAR(32))
		,n+99
FROM #N; 

-- Delete numbers table.
DROP TABLE #N;

Column Name             Data Type       Allow Nulls
[Cross Reference ID]	int	        Unchecked
[Created By]	        nvarchar(50)	Checked
[Creation Date]	        datetime	Checked
[Modified By]	        nvarchar(50)	Checked
[Modification Date]	datetime	Checked
[Row Status]	        nvarchar(15)	Checked
Object	                nvarchar(15)	Checked
[External System]	nvarchar(15)	Checked
[External ID]	        bigint	        Checked
[External Key]	        nvarchar(50)	Checked
[Analytic ID]	        int	        Checked

INSERT INTO dbo.TempUsersCreation
SELECT
		n
		,NULL
		,NULL
		,NULL
		,NULL
		,NULL
		,'Person'
		,NULL
		,NULL
		,'ffuser' + CAST(n-1 AS VARCHAR(32))
		,n+99
FROM #N;

CASE 
	WHEN n <= 149999 THEN 'AAA'
	WHEN n <= 209999 THEN 'BBB'
	WHEN n <= 211799 THEN 'CCC'
	WHEN n <= 212399 THEN 'DDD'
	ELSE ''
END
	+ CAST(n-1 AS VARCHAR(32)) -- if you need to append n

quote:

---

Originally posted by Gorovdude23

Works like Magic. Thanks!

One more Question / Request:

In the Numbers Table I have numbers between 0 and 212,399

There are 4 string prefix that I need to use:
AAA for numbers between 0 - 149,999
BBB for numbers between 150,000 - 209,999
CCC for numbers between 210,000 - 211,799
DDD for numbers between 211,800 - 212,399

How can I add it to the Query?

Thanks!

---

..
CASE WHEN number BETWEEN 0 AND 149999
     THEN 'AAA'
     WHEN number BETWEEN 150000 AND 209999
     THEN 'BBB'
...
END AS YourNewColumnName

NumberRanges
--------------
RangeDesc         StartValue         EndValue
----------------------------------------------
AAA                  0                149999
BBB               150000              209999
...


and use a join in your query like

JOIN NumberRanges nr
ON yourtable.Numbers BETWEEN nr.StartValue AND nr.EndValue
...