Hullo David Burrows,

Thank you very much for sharing information with me in coding that makes me understand it logically.

Appreciate your generosity in helping with sample coding.

You are wonderful. I...

Gianluca Sartori 😎

You behave yourself please

Don't let your accusation on this thread go sideway.

Be careful in your driving

Once the helper got my coding working,

I will posting the working codes...

ALZDBA

Ian is correct to himself not me because both of us are not from the same company and same department and differnt country.

My company SQL SERVER table TestCustomers DataType...

Gianluca Sartori

The posting I did not go sideway as I am a good driver.

I responded to the helper with the testing result based on their generous sharing of sample...

Hullo Dave Ballantyne

Thank you for not helping

That proved that you don't have the knowledge or skill set.

You should post your problem here to receive help.

Hullo Ten Centuries,

This is one decade Lennie.

Your suggestion and statement Quotaton

Select ' ---Select Customer --- ', 'CompanyName'

There are other potential problems e.g. I suspect CustomerId will be an integer....

Hullo Matt Miller,

Yaaa........Hoooooo..........

Thank you very much for sharing this with me:

Month(OrderDate). and I added this as well Year(OrderDate)

I tried it out to meet the Business Analyst Requirements and Specificaition...

Hi Matt Miller,

Regarding your quotation list below:

In particular - "OrderDate.Month". Unless you have a TABLE called Orderdate, and a column called Month, it won't know what you mean. The T-SQL...

Hi Lynn,

Thank you for trying to help.

Lynn,

Lastly, this is a professional forum, please act accordingly. Treat others as you would like to be treated.

Refer your above statement to others as well not to mistreat others as...

WayneS (9/13/2010)

---

(I think I'm going to regret getting drawn into this...)

Lennie,

It's not until these last two posts of yours that you mention that this field is set to NOT NULL....

WayneS (9/13/2010)

---

(I think I'm going to regret getting drawn into this...)

Lennie,

It's not until these last two posts of yours that you mention that this field is set to NOT NULL....

David Webb-200187 (9/13/2010)

---

And what happens if the Status is NULL? Does your code deliver the correct answer? That's all Jeff was trying to point out. He's trying...

Stefan krzywicki

As per your statement listed below and your critism you are wrong.

You are very very wrong making false accusation of me.

I did not create the table. It was the...

Jeff,

I am surprise that you said the coding list below is not working.

Based on it the data export to Excel Spreadsheet display exactly what the Business Analyst Requested of 1...