Please take a few minutes and read the article found at the first link in my signature. With ddl and sample data in a consumable format this is pretty simple.

patrickmcginnis59 10839 (4/17/2013)

---

Sort of a generic approach. I don't think it compares very favorably to the microsoft specific approach, ie., 'UPDATE FROM'.

Hopefully someone can take my DDL and we can...

jerry 5150 (4/17/2013)

---

I have two tables, one with (potentially) multiple records of an item with different quantities, and the other table will have only one record for each item and...

You can do this using a running total. Take a look at this article that explains how to do a running total in sql.

http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D

If you get stuck feel free to...

Any chance you can normalize your data? The problem you are having here is because you have a single column with all sort of data elements in it.

If you are...

We all certainly understand sensitive data. Many of us work with it all day long. I can't however imagine that a query is sensitive. The problem here is that you...

LOL

http://www.holley.com/index.asp?division=NOS

rayh 98086 (4/16/2013)

---

Hi Lowell,

Good to hear from you again. I am using a Windform.

This generally does answer my question, but do you have an example of this?

The...

And here we can tell that Lowell tends be more of a WinForms guy and I am an ASP.NET guy. 😀

I always forget about the auto-magic updating when using WinForms....

rayh 98086 (4/16/2013)

---

My two questions that I have are:

1.) How do I put loop here to update all records in data grid????????????????????

2.) What is the correct syntax to pass an...

I agree with Lynn there is no need for a loop here. MERGE would handle this quite nicely.

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

If you want/need some help with coding it please take a few minutes...

Lynn Pettis (4/16/2013)

---

GilaMonster (4/16/2013)

---

Lynn Pettis (4/16/2013)

---

Either nobody has had any complaints, nor needed someone to jump into an issue, or else everyone is just...

Lowell (4/16/2013)

---

unlike all of you guys who completed all their tax paperwork in January and already got your refunds back, my yesterday was

non stop juggling of funds so I could...

Take a look at this thread. There are plenty of ways you can leverage XML PATH to help build concatenated values.

http://www.sqlservercentral.com/Forums/Topic1442810-392-1.aspx#bm1442836

Lynn Pettis (4/16/2013)

---

Sean Lange (4/16/2013)

---

I was wondering about concurrency when I read your...