Can you post some sample data?

Try this

WITH CTE AS (

SELECT

ID, CaseNumber1, DateFiled, OpenActionCode, JudgeNumber, TermDate, TermActionCodeID, ReOpenedCase, VisitJudge, CaseTypeNumber, SubmittedDate, RulingDate,

PreviousFileDate, Note, CDatefiled, CTermdate, CSubmittedDate, CRulingDate,

ROW_NUMBER() OVER(PARTITION BY CaseNumber1 ORDER BY TermDate DESC) AS rn

FROM

tblSupremeCourt

WHERE

TermDate...

SELECT r.value('@EMAIL','VARCHAR(30)') AS EMAIL,

r.value('@PHONE','VARCHAR(30)') AS PHONE

FROM @xml.nodes('/P/REC_LIST/REC') AS x(r)

WITH Summary AS (

SELECT ID,

SUM(CASE WHEN status=5 THEN 1 ELSE 0 END) AS Fives,

SUM(CASE WHEN status=6...

WITH CTE AS (

SELECT UserID, TaskID,

COUNT(*) OVER(PARTITION BY UserID,TaskID) AS cn,

ROW_NUMBER() OVER(PARTITION BY...

If you know the maximum number of iterations, you can use a series of joins as below, otherwise you'll have to use a recursive query.

DECLARE @t TABLE(dnsname VARCHAR(30),alias VARCHAR(30),zone VARCHAR(30));

INSERT...

In the "Save Grid Results" dialog click on the arrow on the "Save" button, you can set the encoding to ANSI there.

Something like this?

DECLARE @t TABLE(name1 VARCHAR(30), type1 VARCHAR(10), name2 VARCHAR(30), type2 VARCHAR(10))

INSERT INTO @t(name1,type1,name2,type2)

SELECT 'Report1','report','table1','table' UNION ALL

SELECT 'Report1','report','view1','view' UNION ALL

SELECT 'report2','report','view2','view' UNION ALL

SELECT 'report2','report','table1','table' UNION ALL

SELECT 'view1','view','table2','table' UNION...

cidr (9/2/2010)

---

Just to let you know. I tried this one from another forum and it touched 56 rows. I've not tried your method yet Wayne, but I wil...

SELECT coursecode,

MAX(CASE WHEN attendancetype='L' THEN attendancetime END) AS L,

MAX(CASE WHEN attendancetype='T' THEN attendancetime END) AS T,

...

WayneS (8/31/2010)

---

Mark did a good job.

If you also need dates to show if there were zero tickets for all reps for that date, then you need to utilize a calendar...

WITH Reps AS (

SELECT DISTINCT Rep

FROM TicketDtl)

SELECT h.TicketDate,

r.Rep,

COUNT(d.Rep)

FROM TicketHdr h

CROSS JOIN Reps r

LEFT OUTER JOIN TicketDtl...

WayneS (8/27/2010)

---

Jeff Moden (8/26/2010)

---

I'm waiting to hear back from the OP of what he wants to do if a couple of million row were to be returned because I'd like...

Try this

SET DATEFORMAT YMD

--Sample table

DECLARE @TABLE AS TABLE(

[RID] INT,

[EMID] INT,

[In Time] DATETIME,

[Out Time] DATETIME)

--Insert sample data

INSERT INTO @TABLE

SELECT 62, 12, '2005-08-18 06:02:00', '2005-08-18 06:31:00'

UNION ALL SELECT 63, 12, '2005-08-18 06:31:00',...

That is a bitwise "AND" and will return rows where both bits 4 and 5 are zero

http://msdn.microsoft.com/en-US/library/ms174965(v=SQL.100).aspx