Hi Chris is I get the curent week number from my app then pass to sql along the way off

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

can you...

(No column name)(No column name)

2013-07-08 07:00:00.0002013-07-15 07:00:00.000

the rest of the data is empty

Jay

Hi Chris, just before we go any further. I am calling this query from my c# app, so the program checks the day @0700 and if its Monday that's when...

Hi Chris that returns data within them dates.

Thanks

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

USE [SLADB]

GO

/****** Object: Table [dbo].[DocketTB] Script Date: 07/18/2013 12:11:22 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DocketTB](

[Docket_Id] [int] IDENTITY(1,1) NOT NULL,

[Docket_Number] [int] NULL,

[Docket_Machine] [nchar](30) NULL,

[Docket_Status] [nchar](10) NULL,

[Docket_EngineerName]...

SELECT *

FROM dbo.DocketTB

CROSS APPLY (

SELECT MondayLastWeek = DATEADD(hh,7,CAST(CAST(DATEADD(DD,-((DATEDIFF(DD,0,GETDATE())%7)+7),GETDATE()) AS DATE) AS DATETIME))

) x1

WHERE Docket_EngFinish BETWEEN x1.MondayLastWeek AND DATEADD(DD,7,x1.MondayLastWeek)

returns no results

SELECT *

FROM (SELECT DTToday = GETDATE()) d

CROSS APPLY (SELECT...

hmmm still no result even tho I no there is data in there for the time period

Sorry, must learn to scroll down 🙁

J

Hi Chris from the step by step I see the correct dates, but on the solution it returns no results. Is there now need for the lastweek thisweek between value...

That works but am struggling to apply that to my query

select * from dbo.DocketTB where Docket_EngFinish DATEADD( hh, 7, DATEADD( dd, DATEDIFF( dd, 0, DATEADD(dd, -7, getdate())), 0)), ...

GilaMonster (1/18/2013)

Sorry I wasnt stating it does I was unsure. Thanks for your explanation

Jay

varchar() or nvarchar()

varchar(max) or varchar(x) is there no variable field, as varchar(50) will always use 50 spaces or however you call them.

This does seem a really noob question and I...

Dockets = Sum(Duration)

looks better

Hi all, this works but its not really the result I want to see. This is fact counting the number of times a category appears in the list, what I...