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

ryno-544382 (7/3/2012)

---

Hi,

Thanks for taking the time to get back to me.

I have updated the post to make more sense and per your suggestion.

If there is anything I still missed please...

That value is outside the range of what can fit in a float.

http://msdn.microsoft.com/en-us/library/ms173773.aspx

The title of your thread talks about creating tables...

This is excellent Dwain!!! Definite addition to the toolbox.