Ed Wagner (10/29/2013)

---

If you haven't been tasked with fixing the problem and are also the new guy, be careful. While you sound like you can and should bring this...

Unless I'm misunderstanding...

DDL = Data Definition Language

It is essentially the metadata that describes the make-up of the table... columns, data types etc...

What kind of relationship are you trying to create and again...

Glad we could help.

aeri_q (10/17/2013)

---

I am doing it row by row because i think its the only way to do this .

The query i have mentioned, if run directly in TSQL ..it returns...

aeri_q (10/17/2013)

---

Following procedure stores the value of each column in a parameter and then inserts in the table.

CREATE PROCEDURE DBO.FKEYS_FOR_KEYTBL

@FKNAME VARCHAR(100) = NULL,

@SCHNAME VARCHAR(5) = NULL,

@FKFLDNAME VARCHAR(20)...

aeri_q (10/17/2013)

---

No i dont want to pass table ..

Below is the query :

SELECT obj.name AS FK_NAME,

sch.name AS [schema_name],

tab1.name AS

,

...

aeri_q (10/17/2013)

---

I have a query which gets multiple rows in result .

i want to convert it in a stored procedure so the values of each column get stored in a...

See link below as to how best to post performance problems:

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Don't know anything about sp_GenerateInserts but are you just trying to script the data in a table as Insert Statements?

As an FYI, the use of OFFSET in the ORDER BY Clause would be valid for SQL Server 2012.

http://technet.microsoft.com/en-us/library/ms188385.aspx

If you haven't done this kind of thing before you might want to take a backup of the destination database before you do your import... just in case.

Ah, I see. I saw naming with @Param1 and assumed Parameters.

I would imagine renaming variables might be dependent on if they have been referenced by name in a front end somewhere.

Either way, that's certainly interesting code.

How is @Param1 then tracked...

I think comments should state what you are doing and not how you are doing it or as I've seen it written sometimes, comments should specify your intent.

It is fair...