DROP TABLE DBName.dbo.TableName
	
SELECT row_number() OVER (ORDER BY AA.Sequence) AS 'ID'
     ,AA.AttributeTypesID
     ,'DBName.dbo.' + AT.Description + '(' + C.ConsID + ')' AS 'Currency'
     ,AA.Sequence
     ,GetDate() AS 'AttributesDate'
     ,R.ID AS 'ParentID'
     ,C.ConsID + '*' + AA.Sequence AS 'ImportID'
     ,AA.Description AS 'Comment'
     ,AT.Description
INTO DBName.dbo.TableName
FROM DBName.dbo.Table1 C
     CROSS JOIN DBName.dbo.Table2 AA
     LEFT OUTER JOIN DBName.dbo.Table3 AT ON AT.AttributeTypesID = AA.AttributeTypesID
     LEFT OUTER JOIN DBName.dbo.Table4 R ON R.Constituent_ID = C.ConsID
			
CREATE UNIQUE INDEX IDX_Attributes_ID
      ON DBName.dbo.TableName(ID)
			
DECLARE @Currency nvarchar(100)
DECLARE @ConsID nvarchar(50)
DECLARE @ID nvarchar(50)
DECLARE @SQLcmd nvarchar(max)

DECLARE Currency_Cursor CURSOR 
FORWARD_ONLY 
FAST_FORWARD 
READ_ONLY FOR
     SELECT Currency, ID
     FROM DBName.dbo.TableName

OPEN Currency_Cursor

FETCH NEXT FROM Currency_Cursor
INTO @Currency, @ID

WHILE @@FETCH_STATUS = 0
     BEGIN
	SET @SQLcmd = 
	'UPDATE DBName.dbo.TableName
	 SET Currency = ' + @Currency + '
	 WHERE ID = ' + @ID

	EXECUTE sp_executesql @SQLcmd
		
	FETCH NEXT FROM Currency_Cursor
	INTO @Currency, @ID
     END

CLOSE Currency_Cursor;
DEALLOCATE Currency_Cursor;

quote:

---

Originally posted by jcelkoThis is scary bad code.

---

quote:

---

But nothing else you offered me is anything close to helpful, or even constructive criticism. I see a lot of insults, a lot misinformed assumptions, and a bad attitude.

---

quote:

---

Originally posted by robvolk
You must keep in mind that the Internet is Joe's psychiatrist.

---