What's wrong with a simple CAST or CONVERT?

SELECT CONVERT( datetime, 'Jul 24 2013 8:05AM')

I'm not sure I'm getting this correct, but based on your description, this is my guess.

There are some errors on the code, I changed to what seemed correct.

--Look for these...

You could use NULLIF(DeptCount, 0)

EDIT: Add reference http://msdn.microsoft.com/en-us/library/ms177562%28v=sql.90%29.aspx

Check out the following links

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

What about a simple DATEADD(wk, -1, GETDATE()) and change the value to bee substracted?

Or use DATEADD(wk, -6, GETDATE()) AND DATENAME(dw, date_needed) = 'Tuesday'?

It's an idea. You could also use DATEPART.

No, it won't. Unless they add 3 new months to the calendar.:-D

You don't have any variables in your code.

You can check the CREATE FUNCTION syntax in here http://msdn.microsoft.com/es-es/library/ms186755%28v=sql.90%29.aspx

CREATE FUNCTION dbo.Example_function_name

(

@Parameter1 int

)

RETURNS TABLE

...

Thank you for the reference Lowell, I knew I had read it, but I wasn't sure where to start looking for it again.

First of all, you can't add a milisecond to a datetime, you need to use datetime2.

Here's an example, if you remove the CAST, you'll see what I mean.

SELECT TOP (500)...

Let's get some coffee before we answer in the morning 🙂

I'm glad I could help.

Thank you for the feedback.;-)

The problem with MIN(DateFoBirth) is that is getting the oldest person, not the youngest. :hehe:

This works for me.

SELECT ID,

CASE WHEN Category IN( 'Art', 'PE') THEN 'Non Educational' ELSE Category END Category,

DATEADD( dd, -1, DATEADD(wk, DATEDIFF(wk,0,Date), 0)) Week,

SUM(Hours) Total_Hours

FROM Attendance

GROUP BY ID,

CASE WHEN Category...

I misread a part of your original post and became more clear now.

You could use DATEADD(wk, DATEDIFF(wk,0,Date), 0) to get the first day of the week and be able to...

Eric M Russell (7/25/2013)

We also can't assume that DateOfBirth isn't nullable.

SELECT TOP 1 *

FROM MyTable

WHERE DateOfBirth is not null

ORDER...