Going back to the title of your post, 'What's in a column name'...

Since the column name is numMonths, DO NOT reuse the column to store the data as days. ...

I'm not sure, but don't you have to have certain rights In SQL Server to be able to shutdown/pause the server? If so, this may be a way to...

Hmmmm...maybe they should be sorting on Post#.

Grant, scroll up in those posts...the last posts are sometimes not in the last position because of the date. It is making a mess of some of these forums.

And I thought it was just me...I send an email to the webmaster as a heads-up.

I have no problem admitting I blew that one...:hehe:

The biggest reason I read this forum is to learn new things...I learn a lot everyday thanks to everyone who contributes. ...

Thanks for setting that straight...sounds like they need to change the datatype on the LastLoginDate to datetime.

Or if you just need the date only for a report, use this in the SELECT query in your report...

select convert(varchar(10), DataDate, 101)...

...and leave the data as is.

Or just use Matt's solution in the SELECT...

SELECT dateadd(day,datediff(day,0,getdate()),0) AS DataDate, ....

Yes, your select should return the row you entered (if it is there).

Check the 'from'...you have the database name there...this should be the table name, 'student_main'.

If you have time, you probably want to have a look at some things on basic database design, because you will probably end up having to design tables, add columns,...

...check the 'where' clause

alorenzini (3/5/2008)

---

FROM uvw_OrderListingSummary A

LEFT OUTER JOIN Consultant h ON

a.consultantid=h.[ConsultantID]

LEFT OUTER JOIN dbo.OrderFormLineItem AS B ON

A.OrderGroupNumber = B.OrderGroupNumber

ANDA.OrderNumber = B.OrderNumber

LEFT OUTER JOIN SharedDimension.dbo.DimOrderType AS D With (NoLock) On

A.OrderTypeXId = D.XID

WHEREA.ConsultantID...

Try this...

... convert(datetime, [columnname])

See SQL Server BooksOnline (BOL) for more info on the 'convert' function.

Have you tried putting the 'Consultant' table in the main 'from' and then left joining the tables after it, that way you ALWAYS get the Consultant record (assuming it exists)...