From someone who has been doing SQL Server work for 7yrs., I would recommend taking the current level of certification.  I would say 85% of the companies will not be...

I always use the cast function for this.

select cast(left(order_date,11) as datetime)

This eliminates the time.

I have found the same issues.  I have only being using it for testing purposes in order to stay ahead of the curve.  I have used Crystal extensively in the...

For those of you who used the script, try this way and you should see the same efficiency without losing the clear coding:

SELECT c.Name, a.Address, p.Phone

FROM Contact c

LEFT JOIN ContactAddress...

To add to this, you will most likely get to a point either restoring to the original db or to another db from the original db where you may have...

Jeff,

Keep in mind while Angela's response is correct for a smaller table, it may not be correct as your table grows.  Keep in mind that the non-cluster will do a...

To get the date, try using the following:

Cast(Left(@Date,11) as Datetime)

Replace @Date with your date variable.