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. ...

Does this help get you in the right direction?

declare @ TestStr varchar(32); -- to get this to post, I added a space between @ and TestStr, remove that space

set @TestStr...

Look for: linked servers [SQL Server], ODBC in BOL (Books Online).

You use the OLE DB Provider for ODBC when creating a Linked Server that uses ODBC.

Adam Machanic (1/22/2010)

---

Jeff Moden (1/21/2010)

---

Although I very much agree with most of that, the "Catch 22" there is that most T-SQL users don't know what a "complex computation" actually is...