SELECT Docket_EngFinish = CONVERT(DATETIME,'2013-07-15 14:08:24.640',121) UNION ALL

SELECT CONVERT(DATETIME,'2013-07-15 13:29:30.780',121) UNION ALL

SELECT CONVERT(DATETIME,'2013-07-15 12:55:57.437',121) UNION ALL

SELECT CONVERT(DATETIME,'2013-07-15 10:21:17.470',121) UNION ALL

SELECT CONVERT(DATETIME,'2013-07-15 10:06:09.610',121) UNION ALL

SELECT CONVERT(DATETIME,'2013-07-15 09:33:54.580',121) UNION ALL

SELECT CONVERT(DATETIME,'2013-07-12 17:43:33.547',121) UNION...

2013-07-15 14:08:24.640

2013-07-15 13:29:30.780

2013-07-15 12:55:57.437

2013-07-15 10:21:17.470

2013-07-15 10:06:09.610

2013-07-15 09:33:54.580

2013-07-12 17:43:33.547

2013-07-12 11:30:24.500

and many more

Jay

Point taken Chris, but even if I did I wouldn't get results as I don't them in in the SSMS query?

I just wondered, if I am passing the week number to sql from c# I am going to have a problem when its week 1, because to get last week...

Same DB, same Connection Chris. How strange.

If I run this is Visual Studio to fill my Dataset I get results

SELECT Docket_Id, Docket_Number, Docket_Machine, Docket_Status, Docket_EngineerName, Docket_Category, Docket_SubCategory, Duration, Module,...

Well I don't understand why I get no results when querying a week number as mentioned before, I get results if I go as low as week 15 but we...

Yes I do now find that strange considering I have data in there for last week?

Hi Chris, if I do

Select * from dbo.DocketTB Where DatePart(Week,Docket_EngFinish ) = 28

last week!

I get no results, do I have to pass something else? I know there is data...

I am awaiting a response regarding the time factor, just for reports I would have thought that week numbers rather than a Monday to Monday 0700 - 0700 would have...

Sargable being not having the () ?

I am trying not just to use you solution copy and paste, would you not advise using hrs? seeing as we know how many...

Hi Chris SSMS studio!

I am using a dataset within my c# app to fill a report then export to excel and email at the given time, so I pass the command to the...