Hard to say with absolute certainty without seeing the ddl. Is this column a datetime datatype? If so you should not do any conversions at all.

The 2nd is just flat...

Actually if you format this sql it is pretty clear that you did not group by all the non-aggregate columns (I used http://poorsql.com).

SELECT s.part_name AS Part_Name

,s.part_no AS Part_No

,s.uom AS UOM

,i.Stock_OnEntryDate

,sum(i.invoice_quantity)...

Wow if this isn't enough of a reason to store datetime information as datetime instead of some oddball integer strangeness I don't know what is.

If this data was stored with...

Or the date ones...

InsertedDateTime int

BAH!!!

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...