-- Sure, just remove ActType and Points from the GROUP BY...

SELECT

h.[hours],

Activities = COUNT(a.ActType),

Points = SUM(x.points)

FROM #tblActivities a

CROSS APPLY (

SELECT

[hours] = CASE

WHEN a.ActType = 'Motion' THEN DATEPART(HOUR,...

-- expand this repeating sequence to cover the maximum number of sales by customer

SELECT

CustomerID,

SaleDate1 = MAX(CASE WHEN rn = 1 THEN SaleDate ELSE NULL END),

Location1 = MAX(CASE WHEN rn...

serviceaellis (8/19/2015)

---

Currently working with

DECLARE @yr AS int;

SET @yr = 2015;

which is used in

WHERE (YEAR(EndDate) = @yr)

...

dudekula.kareemulla (8/19/2015)

---

Hi Thanks for your reply ,,,,

I got your point but here situation may be swipe-in and swipe-out machines are separate and

new joiners may be confused and done instead of...

Jeff Moden (8/20/2015)

---

Really, really looks like and sounds like homework. Even if it's not, you should at least try. And rules 4, 5, and 6 create an oxymoron...

coolchaitu (8/20/2015)

---

Dear Chris sir,

There is remote join in the query you posted. I came across an article that says Remote join doesn’t work well on SQL server 2005. Ours is...

In case this spills past UK time, this is what I have so far:

DECLARE @lobid INT = 3,@LineOfBusiness VARCHAR(50)='ECN'

DECLARE @CmsContractID VARCHAR(MAX)='H9285'

SELECT DISTINCT D.DeterminantID AS BEN_CAT_ID

,DENSE_RANK() OVER...

Eric M Russell (8/19/2015)

---

OUTER APPLY (

SELECT...

Thanks. What about the content? What do the results tell you?

Thanks for your help Luis - there's plenty to go round in this...

Here's the first part. Run it, report back with your findings. Are there loads of dupes in the output?

IF OBJECT_ID('tempdb..#DeterminantAttributeValue') IS NOT NULL DROP TABLE #DeterminantAttributeValue

SELECT

DAV.DeterminantAttributeID, DAV.TypeID,

Value1Part =...

squvi.87 (8/19/2015)

---

ChrisM@Work (8/19/2015)

---

Fantastic, thanks.

1. Spilling sorts occur when the number of rows received by the sort operator is more than the estimate. If you examine the property sheet of the...

Fantastic, thanks.

1. Spilling sorts occur when the number of rows received by the sort operator is more than the estimate. If you examine the property sheet of the sort operator,...

Can you post the entire query please, and the definition of the tvf "splitstring".

Cheers.

;WITH ProcessedData AS (

SELECT EmpName, SwipeDate, MIN_SwipeTime = MIN(SwipeTime), MAX_SwipeTime = MAX(SwipeTime), SwipeType, grp

FROM (

SELECT EmpName, SwipeDate, SwipeTime, SwipeType, grp = rn1-rn2

FROM (

SELECT

EmpName, SwipeDate, SwipeTime, SwipeType,

rn1 = ROW_NUMBER()...