Hi Lowell,

Many thanks for rapid response.

Will attempt the connection from SSMS on Monday.

(Here's hoping my predecessors in the job have left the login password in the documentation!)

Apologies Lynn.

I've read the article and here is my...

Dohsan (3/20/2014)

---

This work?

DECLARE @a INT = 10,

@b-2 INT = -12;

SELECT@a,

@b-2,

CASE

WHEN @b-2 < 0 THEN @a +

Lynn Pettis (3/20/2014)

---

malcolm.garbett (3/20/2014)

---

Thanks Lynn,

Value 1 = 10

Value 2 = -12

Can they be summed...

Thanks Lynn,

Value 1 = 10

Value 2 = -12

Can they be summed to produce result...

Hi Ed,

I was trying that:

SUM(CASE WHEN neg.Valueneg > invoiceitems.homenettvalue THEN ABS (invoiceitems.homenettvalue + neg.Valueneg) *-1

ELSE ABS (invoiceitems.homenettvalue + neg.Valueneg)END)...

Example of output that's "wrong." (Sorry about the formatting - I can never seem to get it to display correctly.)

CustomerIDCustomerNameCountryPartNumberCurrencyPYTD_Ext_PriceCYTD_Ext_PricePYTD_QtyCYTD_QtyASP_PYTDASP_CYTD

N1141ARC Machine Tools LtdGBS2G00009D070GBP0.00-235.44010235.44

N1141ARC Machine Tools LtdGBS2G00009D070GBP0.00261.60010261.6

Issue 1. -235.44...

Thanks grant.

Anyone else?

Is 3rd party the only way to get this information?

Hi all.

BIG thanks for all the help.

The temp table - that worked. 🙂 Used temp tables a lot when I was working with informix SQL, but have fallen...

stevenb 63624 (11/1/2013)

---

The first thing that comes to mind is to make use of a temp table or a table variable. Insert your delivery information into a temp table, and...

Sean Lange (11/1/2013)

---

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3....

Guys,

Thanks for the continuing input. Really interesting.

Stefan,

Still at the testing stage, but using your script I now have a working solution.

The "odd" column names are determined by our group...

Wow, Stefan, that was quick!

Huge thanks for taking the time.

I'll be looking at it over the next few days and will definitely report back.

Thanks again. 🙂

I see it now. 🙂

Many, many thanks.

EdVassie (11/5/2012)

---

If your site already has in-depth skills using Impromptu, then keep on using it. The install costs of Imprompu will be dwarfed by the costs of migrating to...