Is this what you want?

SELECT x.RowID, x.ParentID AS ChildParentID, x.ChildID AS GrandchildID

FROM @ParentChild x

WHERE EXISTS (SELECT * FROM @ParentChild y WHERE x.ParentID=y.ChildID)

You can also use a range table for this

INSERT INTO Ranges(MinVal,MaxVal)

SELECT 1,10 UNION ALL

SELECT 11,30 UNION ALL

SELECT 31,60

SELECT r.MinVal,

r.MaxVal,

...

kiran.rajenimbalkar (4/18/2012)

---

Ya its working but I have many district so what can I do? and I want to show all columns as I have mentioned in my SQL.

So please do...

See if this works

DECLARE @t TABLE(dq_org_dist_id INT, dq_rec_seq_nbr INT, dq_rec_start_cycle_ind INT)

INSERT INTO @t(dq_org_dist_id, dq_rec_seq_nbr, dq_rec_start_cycle_ind)

SELECT 1130, 22, 0 UNION ALL

SELECT 1130, 21, 1 UNION ALL

SELECT 1130, 20, 0 UNION ALL

SELECT...

Here's another way

WITH CTE AS (

SELECT DatePresent, Status,

DatePresent - ROW_NUMBER() OVER(ORDER BY DatePresent) AS rnDiff

FROM @Tab)

SELECT COUNT(*) AS Days,

...

Oops, my bad. Needs SQL Server 2005 or above.

Lots of ways of doing this

WITH CTE AS (

SELECT id,

age,

...

I think there's a discrepancy in your results, one of the 8890 should be 2500?

with cte as (

select p.myID, p.programID, p.stSVT, r.subjectCd, r.merit, h.noOfMinSubject,

...

You don't need the comma in the regular expression

Guessing here

WITH CTE AS (

SELECT CASE WHEN AMOUNT>0 THEN FLAG1 ELSE FLAG2 END AS INBOUND,

CASE WHEN AMOUNT>0 THEN AMOUNT ELSE 0 END AS...

Does this help?

SELECT e.EMP_ID,

e.EMP_NAME,

e.EMP_ORGANIZATION,

e.EMP_DEPARTMENT,

...

Can you change the Calendar table? If so, you could add a computed persisted column " NextDay as dateadd(day, 1, Calendar.Date) "

Your join would then be

where OrderDate >=...

codebyo (3/30/2012)

---

Mark-101232 (3/30/2012)

---

with cte as (

select stageid,stagestatustypeid, applictaionid,

row_number() over(partition by applictaionid order by case when stagestatustypeid<>1 then 0 else 1 end,stageid desc) as...

with cte as (

select stageid,stagestatustypeid, applictaionid,

row_number() over(partition by applictaionid order by case when stagestatustypeid<>1 then 0 else 1 end,stageid desc) as rn

from test)

select...

Another way

SELECT TOP 1 WITH TIES

Company, Category, AcctgDate, Sequence, Amount

FROM #yourSampleData

ORDER BY Sequence DESC