OK this is still nowhere near enough info but thanks for the proc code.

How about ddl for the table you are trying to insert to?

What are the parameters...

You have not provided anywhere near enough information for anybody to be able to help.

Try this link. http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

And as...

OP = Original Poster. 😀

Is there a question here?

Sounds like @KodePay is a delimited string? Take a look in my signature at the article about splitting strings.

sestell1 (6/25/2012)

---

I was always under the impression that there was no reason to create indexes on table variables because they exist only in memory.

Does anyone know what SQL Server actually...

dwain.c (6/22/2012)

---

Sean Lange (6/22/2012)

---

SQL_Kills (6/22/2012)

---

Hi,

Thanks for your advice so far and what you have shown me.

The table you created QuestionFieldsNormalized was what the table originally looked like that when pulling...

A couple easy suggestions. Your name of ID is inadequate as Lowell pointed out previously. Your columns don't make any sense to me. There is one thing that will help...

It would probably be better if you used reply instead of editing. when you edit nobody gets a notification, but when you add a new reply they do. 😛

Thanks for...

We used to play one while traveling. We called it the geography game. Here is how it works. The first person will say the name of a location. This can...

TheSQLGuru (6/22/2012)

---

Sean Lange (6/22/2012)

---

TheSQLGuru (6/22/2012)

---

Eugene Elutin (6/21/2012)

---

I cannot understand why would you need dynamic sql for statements there.

Why not to have the same stored procedures in every database and call...

sunshine-587009 (6/22/2012)

---

Wow! I never finished writing the messsage and must have accidentally sent because I got busy at work. I am a dba, not a developer which is why I...

To be more descriptive in the normalization issues I figured I should explain what I mean.

You have a column Engineer. I assume this is the column that holds the name...

That is because your data is not normalized. You have multiple rows with the same part number but the description is different. If you had a parts table and this...