Mark Cowne (1/28/2015)

---

ChrisM@Work (1/28/2015)

---

GilaMonster (1/28/2015)

---

That doesn't return alternate rows, it returns rows with odd values of...

SUM(CASE WHEN...

GilaMonster (1/28/2015)

---

That doesn't return alternate rows, it returns rows with odd values of BusinessEntityID. There's a...

Here's another way:

;WITH Preaggregate AS (

SELECT Grp, [Result] = SUM(numLow) + SUM(numMedium) + SUM(numHigh) + SUM(numZeroScore)

FROM historyTable h

CROSS APPLY (

SELECT [Grp] = CASE

WHEN h.asAtDate > DATEADD(DAY,-7,CAST(GETDATE() AS DATE)) THEN...

Good...so what do you think the query should look like?

Almost...

SELECT n, n%1, n%2

FROM (VALUES (1),(2),(3),(4),(5)) d (n)

ayh1 (1/28/2015)

---

thanks seems to work if i wanted to add attendance status = 2,3,4,5,6,7 to the second line

SUM(CASE WHEN a.AttendanceStatus = 2 THEN 1 ELSE 0 END) AS...

Bhushan Kulkarni (1/28/2015)

---

Check this sample query without using % or mod

USE [AdventureWorks2008]

GO

SELECT P.*

FROM

(SELECT *,ROW_NUMBER() OVER(Order by BusinessEntityId) AS RID FROM Person.Person )P

INNER JOIN (SELECT ROW_NUMBER() OVER(Order by BusinessEntityId) *...

ayh1 (1/28/2015)

---

Hi

I have a query which works:

SELECT dbo.tblGP_Practices.OrganisationCode, SUM(dbo.tblAppointments.AttendanceStatus) AS [Total Attended], dbo.tblAppointments.AttendanceStatus

FROM dbo.tblGP_Practices INNER JOIN

...

Use ROW_NUMBER() and select either even or odd numbers.

A standard month. It will be...

cyberdaemon (1/27/2015)

---

Good day,

I am having problem with the unpivot function of sql 2012, i unpivot my column then i get the result that i wanted but the error that i...

-- You may need to extend the range of the virtual tally table.

SELECT [QuarterName] = 'Q' + DATENAME(qq,DATEADD(QQ,n,startdate)) + ' ' + CAST(YEAR(DATEADD(QQ,n,startdate)) AS VARCHAR(4))

FROM (SELECT startdate = '01/JUN/2011', enddate...

Jeff Moden (1/26/2015)

---

Details are in the code...

--===== Conditionally drop the working table to make reruns in SSMS easier

IF OBJECT_ID('tempdb..#QU','U') IS NOT NULL

...

Gosh :blush: thanks Koen! I like what Jeff's done with it.