jitendra.padhiyar (7/3/2012)

---

That...

No need for that. Here is some code that works perfectly in SQL.

;with Details(ChargeDescription, Charge, Weight)

as

(

select 'wrong address', 5.00, 2 union all

select 'wrong address', 5.00, 3 union all

select 'wrong weight',...

jitendra.padhiyar (7/3/2012)

---

Sean Lange (7/3/2012)

---

It makes sense if you think about it. You are talking about pushing modified rows contents to another database. Without a primary key how do you know...

It makes sense if you think about it. You are talking about pushing modified rows contents to another database. Without a primary key how do you know which row is...

SQLNube (7/3/2012)

---

I am in need of providing a query that gives a subtotal of a charge, the percent of total charges, the weight of an item, and the average weight...

OK let's try it this way.

Here is the code you posted and I made the change to original insert to ExternalSource.

-- ===================

-- Source table & data

-- ===================

IF NOT EXISTS (SELECT...

You are quite welcome. Glad that could help.

sqldba_newbie (7/3/2012)

---

Steve Jones - SSC Editor (7/3/2012)

---

Why does the table have to be created on the fly? You know the output of the proc already, so create the temp table...

That certainly helps but it is awfully confusing. You seem to have a mix between an EAV type of structure and an adjacency list. I have to admit that this...

I compiled all the separate query windows into a single larger script to make things easier. Please take a look and see if this is correct.

-- ===================

-- Source table &...

ryno-544382 (7/3/2012)

---

Hi

If you look at the source table (ExternalSource) you will see there are two Floor2 under locname2.

Now, a simple distinct will only return one Floor2 I.e.

Floor1

Floor2

However, based on the...

Hi and welcome to SSC! This is certainly possible but not without some details from your end. We need ddl, sample data and desired output. See the first link in...

This is called a cross tab query. Take a look at the links in my signature. Unless you know how many columns each group will have you are looking at...

This should get you started.

http://thavash.wordpress.com/2007/10/02/date-formatting-in-reporting-services-list-of-format-codes/%5B/url%5D

You would probably be better off if you can change this to an appropriate datatype, although...

Start with this from Gail. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D