Re: AdventureWorks - Difference between WHERE clause and output

#1

Duh-O!!!

What you are looking at is the OrderDate -which happens to be July 1st,
2001.

If you add ShipDate to the SELECT columnlist, you will see that the ShipDate
is properly retrieved: '20010708'.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

"Ruel" <Ruel (AT) discussions (DOT) microsoft.com> wrote

Quote:

The following code displays July 1 data instead of July 8. Why?

USE AdventureWorks
SELECT OrderDate,SalesOrderNumber,CustomerID,Subtotal,Tax Amt,TotalDue
FROM Sales.SalesOrderHeader
WHERE ShipDate='20010708'

Appreciate your response.

Ruel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: AdventureWorks - Difference between WHERE clause and output

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: AdventureWorks - Difference between WHERE clause and output - 12-13-2006 , 01:18 PM