avishain (6/24/2013)

---

J Livingston SQL (6/24/2013)

---

do you have any other columns available that hold date info ...eg yyymmdd?

also what are you expecting to happen when the end time is two or...

While you're investigating JLS' questions, this is worth playing with:

SELECT

[DTstart date],

[DTend date],

SecondsDifference = DATEDIFF(second,[DTend date],[DTstart date]),

SecondsDifference = ABS(DATEDIFF(second,[DTstart date],[DTend date]))

FROM (

SELECT

[DTstart date] = CONVERT(DATETIME,STUFF(STUFF(CAST(d.[start date] AS VARCHAR(8)),3,0,':'),6,0,':'),114),

[DTend date]...

Can you post the actual plan (not the estimated plan) for this batch, please?

-- Determine what is in the patch container

SELECT TOP(1000) DISTINCT M_SCNTYPE, M_FAMILY0, M_MLABEL0, M_SLABEL0, ContainerID = @TargetContainerID

INTO...

Same reason as Feynman diagrams are now so familiar, Jan 😉

SELECT...

You might need an input style for CONVERT:

;WITH Sampledata AS (

SELECT lastrundate = CAST(20130620 AS INT)

)

SELECT

lastrundate_INT = lastrundate,

lastrundate_CHAR8 = CAST(lastrundate AS CHAR(8)),

lastrundate_DATE = CONVERT(DATE, CAST(lastrundate AS CHAR(8)),112)

FROM Sampledata

Yes there is, but not up there 😉

Shouldn't take too much...

sagesmith (6/18/2013)

---

The first article by Jeff Moden in your signature makes...

whenriksen (6/18/2013)

---

If "Show Actual Execution Plan" is set prior to executing the code and then both the queries (the CURSOR based one and the recursive CTE based one) are executed,...

sagesmith (6/18/2013)

---

ChrisM@Work (6/18/2013)

---

sagesmith (6/18/2013)

---

Please post the times each approach takes, this is the only basis for a conclusion. As others have already mentioned, in many scenarios the cursor far...

T.Ashish (6/18/2013)

---

Dear All,

While testing a query when we run it second time, it uses cache so performs better then previous run.

...

This appears to work:

SELECT

ID = ROW_NUMBER() OVER(ORDER BY MIN(DateRange)),

Employee, Job, [Workload],

StartDate = MIN(DateRange),

EndDate = MAX(DateRange)

FROM (

SELECT ID, Employee, Job, [Workload], DateRange,

Grouper = DENSE_RANK() over (order by...

sagesmith (6/18/2013)

---

Please post the times each approach takes, this is the only basis for a conclusion. As others have already mentioned, in many scenarios the cursor far outperforms the...

Jonathan AC Roberts (6/18/2013)

---

I thought this looked a good candidate for CROSS APPLY:

insert into dbo.def (SeqNo, Date_Field, Payment)

SELECT A.Seqno, X.Date_Field, A.Payment

FROM dbo.abc A

CROSS APPLY (SELECT DATEADD(mm, T.N,...