You're very welcome, and thank you for the nice feedback.

Like this?

SELECT

t.*,

x.RollingSum

FROM #team t

OUTER APPLY (

SELECT RollingSum = SUM(expense_amt)

FROM #team ti

WHERE ti.team_id = t.team_id

AND ti.date <= t.date

AND ti.date >= DATEADD(month,-3,t.date)

) x

WHERE t.date >= DATEADD(year, -1, GETDATE())

ORDER BY...

There won't be a person on...

maheendra.puttareddy (5/15/2015)

---

UPDATE Tablename

SET Year= casewhen MSDate > '2011/06/30' and MSDate < '2012/07/01' THEN '2012'

when MSDate > '2012/06/30' and MSDate < '2013/07/01' THEN '2013'

when MSDate > '2013/06/30' and MSDate...

cms9651 (5/14/2015)

---

Hi all, hope in your help.

I have problem to execute query with interval date.

If try this query I don't have problem and the output is correct:

SELECT * FROM dotable

WHERE

dotableDate...

Have a look at the REPLACE function in Books Online (SQL Server help)

There are at least two alternatives which may perform better than your original. How much better depends to a great extent on indexing:

SELECT t.*, x.SUB_TYPE

FROM #TEMP t

OUTER APPLY (

SELECT...

andrew_dale (4/30/2015)

---

many thanks for the replies, they do make sense.

checking the execution plan, if I run a simple query and include one of the index fields in the where clause...

Remove POST_DT from the GROUP BY.

-- Write the query the simplest way. It doesn't get much simpler than this:

SELECT DISTINCT

created_dttm AS Created_Datetime,

proj_task_id AS Project_Task_Id,

CAST([text] AS VARCHAR(2000)) AS [text]

FROM dbo.P_T

WHERE...

Stephen Knott (5/7/2015)

---

Hi Chris,

I didn't yet - but I will.

I have added COMMITTED SNAPSHOT isolation as it was the least invasive - i.e. didn't need to change any...

Stephen Knott (5/4/2015)

---

...Another suggestion has been to try and use an exists before the update as below

IF EXISTS( SELECT based on above criteria )

( UPDATE as...

-- The WHERE clause must be evaluated for each row in the Stock table

-- in order to determine which rows qualify for the UPDATE.

-- The likelyhood of a table lock...

DROP TABLE #Team

CREATE TABLE #Team

(

[FirstName] [varchar](20) NULL,

[LastName] [varchar] (20) NULL,

[Team] Varchar (20) NULL,

[TransactionID] int,

Price float,

NoofTickets int

) ON [PRIMARY]

INSERT INTO #Team

...

Have you tried a bog-standard aggregate?

SELECT ColA, ColB, ColC = MAX(ColC)

FROM …

GROUP BY ColA, ColB