I want to thank you for your help!!

I already apply this to the LIVE environment and is working like a charm!!!!!

THANK YOU SO MUCH!!!!

RITS

Never mind, I see your code working!!!!!

😀

I am sorry, I misunderstood the use of Row_Number.

So you will use the row-number to count the number of records found, right?

I just don't see how the invoice number "340"...

Hi Sean,

Thank you for your response.

The ROW_NUMBER can't be used. The "340" is a value that will change every time this script is used, furthermore this will be entered by...

I think I just found out how to insert the code

--===== If the test table already exists, drop it

CREATE DATABASE TEST_DB

--=====Create table

use TEST_DB

CREATE TABLE SHIPHIST

(HANDLE varchar(20),INV_NUM varchar(20));

--=====Create values

INSERT INTO...

Please see attached file for testing purposes.

For results, I would like to prompt the user to enter the "HANDLE" and the "Start Invoice #", the script will

search for and COUNT...

Thank you for your response!!!

So I pasted the entire SELECT CASE in the FROM statement and I try to INNER JOIN to my first table "zzoordrh" but I am...

Hi lnardozi.

Thank you for the response. I have been trying to insert the whole CASE statement inside my existing elaborated query but I keep having errors. Perhaps I am not...

Thank you Lowell!!!!!!!

It works!!!!

I just not sure this this is what I was expecting. See, I am getting three columns: BILL_NUM, VALUE, and zzedatawhse.value.

The table shows all records from table...

Humm,

Thank you B, I added both and I am still getting:

Incorrect syntax near '='.

This is what it looks like now:

SELECTzzoordrh.BILL_NUM, zzedatawhse.value,

CASE zzedatawhse.VALUE

WHEN zzedatawhse.QUALIFIER = 'PL' AND zzedatawhse.SEGMENT = 'SLN'...

Thank you for the suggestions. So this is what I have:

SELECTzzoordrh.BILL_NUM, zzedatawhse.value

CASE

WHEN zzedatawhse.QUALIFIER = 'PL' AND zzedatawhse.SEGMENT = 'SLN' THEN...

Congratulation Anatoly!!!!!!

Yes, you were able to achieve what I was looking for.

The little detailed note about the "Division" was overlooked until you pointed it out. I sort of figured it...

Well I have to thank you both for the results and time spent.

The story with this tables and database is: I work for a company who uses some ERP software...

HI Grasshopper,

From the Post #1314836,

is this the rest of the tables I had posted at the beginning of the post from the attached?

The answer to the question: You can add...

You are right Grasshopper!

I am not an expert SQL server guru and I will provably never be one not matter how much time I spend on this, but I try!...