WElcome to the SSC 🙂

can you please provide some information about your requirement? Its not clear to us..

Please follow the link in my signature about how to post a question,...

Adding some more points to the problem:

inspite of defining columns as SPARSE it is still taking space in database as I read on some blog that if we specify column...

Instead of delete if you fire TRUNCATE statement it will show data size is 0

Cadavre (8/21/2013)

---

kapil_kk (8/21/2013)

---

Yes, I have used MERGE before but not in much depth like this....

USING (SELECT a,b,c

FROM @tblTempTable) [Source](a,b,[bit]) ON [Target].AccountOfficeId =...

Koen Verbeeck (8/21/2013)

---

Try reading articles by Jeff Moden.

The key here is to avoid cursors and WHILE...

Cadavre (8/21/2013)

---

kapil_kk (8/21/2013)

---

Cadavre (8/21/2013)

---

kapil_kk (8/21/2013)

---

Koen Verbeeck (8/21/2013)

---

Sure. This is one of the examples where you don't need a tally table.

You can replace the logic beneath @bit = 1 with one...

Can anyone tell me from where I can learn about this SET Based approaches?

Cadavre (8/21/2013)

---

kapil_kk (8/21/2013)

---

Koen Verbeeck (8/21/2013)

---

Sure. This is one of the examples where you don't need a tally table.

You can replace the logic beneath @bit = 1 with one MERGE statement.

The...

Koen Verbeeck (8/21/2013)

---

Sure. This is one of the examples where you don't need a tally table.

You can replace the logic beneath @bit = 1 with one MERGE statement.

The logic beneath...

Hi Koen,

here is one sample of cursor that is used in one of the object:

DECLARE curApplication CURSOR FAST_FORWARD LOCAL FOR

SELECT a,b,c FROM @tblTempTable

OPEN curApplication

FETCH NEXT FROM curApplication

INTO @a,@b,@bit

WHILE @@FETCH_STATUS=0

...

npranj (8/20/2013)

---

Thanks Kapil. It wont work because we need a join with the ID. NEed to check TimeId against each Person ID.

Got the query. IT was simple. -

select PDD.*

...

have you checked the execution plan?

try this_

select t1.PersonID, t1.LeaveTimeId

FROM tbl_PersonDetails t1

JOIN tbl_PersonLeaveDetails t2 ON t1.PersonID = t2.PersonId

WHERE t1.LeaveTimeId NOT IN (select t1.LeaveTimeId FROM tbl_PersonLeaveDetails t2 WHERE t1.LeaveTimeId BETWEEN t2.LeaveFromTimeID AND t2.LeaveToTimeID)

you question is not clear to us...

untill you dont provide some more details what you required we cant able to help you

Good question to start the day 🙂