I came up this:

create table testing (retained int, dropped int)

insert into testing (retained, dropped)

select 767884, 157441 union all

select 1046261, 157441 union all

select 1055257, 157441 union all

select 157441, 73635 union all

select...

SQL_beginner1 (9/24/2012)

---

Hi,

I'm a newbie and this is my first post.

I'm trying to update a table based on a select query, but I'm getting the following error message when I try...

Your opinion. Personally, you put the fault on all the politicians, regardless of political party or position. They afre more interested in their own...

SQL Kiwi (9/23/2012)

---

Lynn Pettis (9/23/2012)

---

True. The problem is that I haven't been able to directly use any of the code Mr. Celko has posted recently because it doesn't parse....

True....

CELKO (9/22/2012)

---

We also do not use bit flags; that was assembly...

SQLRNNR (9/21/2012)

---

SQL Kiwi (9/21/2012)

---

Brandie Tarvin (9/21/2012)

---

I can't blame him for being defensive. Eugene basically invited Celko into that thread for the sole purpose of roasting him. There really was no...

TravisDBA (9/21/2012)

---

Lynn Pettis (9/21/2012)

---

TravisDBA (9/21/2012)

---

I have to say Barack Hussein Obama. He wants to end offshoring of American jobs and redistribute the wealth in this country and I am most...

krowley (9/21/2012)

---

I am going to go less serious and more geeky. Geordi La Forge from Star Trek. The ultimate problem solver. If it could be done Gordi could do it....

Using just your sample data (not the code you posted), is this what you are looking for?

WITH TestData (

corp_address_id,CompanyName,invoice_no,sales

) AS (

SELECT

corp_address_id,CompanyName,invoice_no,sales

FROM

(VALUES

(10010,'Wellservice',123,5),

(10010,'Wellservice',124,8),

(10010,'Wellservice',125,2))dt(corp_address_id,CompanyName,invoice_no,sales)

), BaseData...

rocky_498 (9/21/2012)

---

OMG I AM SO SORRYYYYY, I totally forgot there is page 2nd. I just implement your code its work fine, Again i am so

sorry for this Confusion and Great...

Based on the sample data you provided in your initial post, what is the expected results?

A hardware or IO failure. Disk sectors can go bad on you.

TravisDBA (9/21/2012)

---

I have to say Barack Hussein Obama. He wants to end offshoring of American jobs and redistribute the wealth in this country and I am most definitely for both...

Sean Lange (9/21/2012)

---

/vent begin

You have been trying to work on this for over a month with various half-hearted attempts strewn all over this site. You need to realize that we...