Here is the result set I get when I run Mark's query:

OrderDate PartGroup SubCode ...

Wasn't the solution I was looking at, but it sure looks good. I was going to create a CTE and join to...

Perfect, Mark!

What field would that be? I can't remember everything that was there, but what I do remember was the Computer Operator School (that's what I did in the AF),...

I think I see what needs to be done, but without the DDL (CREATE TABLE statment) and sample data (as a series of INSERT INTO statements) I really can't do...

rambilla4 (1/22/2010)

---

Hi,

I', writing a query as below and I want to display the time in format DD/MM/YYYY HH:MI:SS:MMMAM

Right now, I'm getting only the date without time as below:

select * from...

CirquedeSQLeil (1/22/2010)

---

My dad was Army. ...

Todd Bernstein-449184 (1/22/2010)

---

I have one table

Date PartGroup subcode ...

CirquedeSQLeil (1/22/2010)

---

I know it doesn't work with the...

I'm off to see the Wizard ... ... in to the desert ...

Until you run out of disk space. SQL Server does not restrict the number of rows that may exist in a table.

Both.

Team (AFA Hockey tonight!) :smooooth:

Answer me these questions:

Is the server currently running SQL Server 2000 or SQL Server 2005?

If running SQL Server 2005, is the database attached to SQL Server 2005 running in 8.0...

Adam Machanic (1/22/2010)

---

Lynn Pettis (1/22/2010)

---

I'm sorry, but just because Steve is on vacation is no reason for professionalism to go out the window. Please refrain from personal attacks. ...