I find it far easier to understand if I have something to work with...

here is a very simple set up....based on these values...what do you expect from your query?

USE [tempdb]

GO

CREATE...

vigneshkumart50 (5/2/2014)

---

Hi,

I am using this below query to sum my column values.

Query:

select

'$ ' + REPLACE( CONVERT(VARCHAR(32),cast(round(isnull(sum([Share_Invest]),0),0)as MONEY),1), '.00', '') [Investment],

'$ ' + REPLACE( CONVERT(VARCHAR(32),cast(round(isnull(sum([Profit_Share]),0),0)as...

Informer30 (4/28/2014)

---

Hi Sean,

thanks for reply, please let me know what further information is required...

I have a select statement that I need to run 15 times with a different where clause...

itortu (4/28/2014)

---

if an order changes multiple times before it is shipped, the original quantity is always going to be the last quantity to what it was changed last.

example

--------------

order quantity

40000

--------------

1st...

itortu (4/28/2014)

---

Hi.

The code that you gave me (the link) worked. After that I needed to add one more cte I think.

And adjustment to catch orders like

S20026, the order...

ben.brugman (4/28/2014)

---

Hello all,

Thanks for your contributions and sorry for not responding.

This weekend I had a fall and have a head injuri. In a few days time everything should be...

itortu (4/27/2014)

---

Hi,

I know I went back and forth with this question several times, but it would be really great if you would help me a last time because I...

well...I didn't know this was called a Lorenz Curve...and neither have I done this in SQL before.

but saw this "simple" explanation http://courses.washington.edu/geog326/Lorenz.pdf in how to do it in Excel.

so...thought I...

is this what you are trying to achieve?

SELECT dbid

INTO #dbcheck

FROM sys.sysdatabases

WHERE dbid > 4

itortu (4/24/2014)

---

Honestly, your last code was awesome, I just replaced the "Sample Orders" part with the sub-query that I use to get the data and it gave me excellent results...

itortu (4/24/2014)

---

J Livingston SQL, you are a life saver sir.

I have a question about something I noticed, and this is probably a communication flaw of mine.

Using the data...

here you go...this works for your sample data....probably a more eloquent solution could be written,...

probably be easier if you can supply some table create scripts / sample data and the results you would expect based on the sample data provided.

itortu (4/23/2014)

---

Hi, I was wondering if the post I made sort of were clear. I have been working on the query myself trying to get to that quantity but still...

itortu (4/22/2014)

---

Hello and thank you for your help.

Your query works very well for what I need it to do.

I am not approaching to our NAV vendor because I...