This is whate of Sergiy's suggestions would look like:

select

ma.memid,

ma.attributeid,

ma.thevalue,

ma.effdate,

ma.termdate,

...

FYI, It is always a good idea to test any code you provide in a sandbox database to ensure it works correctly. We are volunteers on this site, and...

Still waiting. We are here to help, but we need your assistance to do that.

WayneS (6/10/2009)

---

Hey gang,

A reader of my article today asked a very good question that I'm not sure what the answer would be. I'm hoping that someone along the likes of...

Lynn Pettis (6/10/2009)

---

jcrawf02 (6/10/2009)

---

Lynn Pettis (6/10/2009)

---

Okay, venting...

We have our White House Window Washer, our PhD Candidate, our True-Relational Zealot. Do we call this one, The One Who Can't, or...

True, Barry, the code I provided was very basic for generating dynamic sql.

Thank you for pointing out the need to do more regarding sql injection.

Please do not cross post. It simply fragments any responses you may recieve.

Please post replies here.

Here is how I would code it.

Tried posting directly, but couldn't so it is posted as an attachment.

You are missing the point. You can't pass in the table name as a parameter to the dynamic sql in the sp_executesql. You can pass in variables where...

May be the only way to clean up the files, sorry.

I use either SSMS or UltraEdit when writing my SQL code, so I don't run into this problem.

Your first code block actually has the proper start. You just need to move the SET of the variable of the table above the SET for the strSQL command.

I...

First, don't use wordpad as a text editor.

Second, exactly how did you save the files? Are you sure you saved tham as full fledge text files?

You have to complete the variable substitution where you are building the SQL command, not in the call the sp_executesql.

jcrawf02 (6/10/2009)

---

Too...

Brian Ferguson (6/10/2009)

---

Code as indicated does not work for me either.

By adding a c:\mssql folder (did not have one on my system) AND changing the the data file folder to...