Greetings,

The link for the function: udf_schedule_description does not appear to be working. When I tried it, I got a 404 error.

Greetings,

Would it be that RedGate has found out where Gilligan's Island is and will send a rescue party there to help get everybody who is still there, and alive, off...

Jeff Moden (8/8/2011)

---

Beer has some interesting freezing qualities... take it down to somewhere between 26 and 28^oF and it's still liquid. Give it a little bit of a sharp...

Jeff Moden (8/8/2011)

---

Heh... yeah... the ol' "hot ice" trick works pretty well but makes the beer taste pretty bad. That's why I use the "Chill'n'Tap" method, instead. 😛

Thanks for...

Greetings Jeff,

That was a wonderful and very insightful article about rCTE's and ways to count out of the box. I will have to put some of the pseudo-counters into...

Greetings All,

Ok, some of you are complaining about the use of the LEFT JOIN. Please allow me to explain. When I am running some reports on the data,...

Greetings All,

I have not had time to reply to your messages individually due to time constraints so I will try to shed some light here.

The calendar and temporary tables were...

Greetings Richard,

That was very informative and helpful. I am starting to work with some XML now so thank you for showing how to solve the problem just before I...

Greetings Laura,

Yep! My bad.

Greetings Ben,

Yes, you are correct. However, I did not know that algorithm so I could not apply it. Instead I came up with a different solution. Your...

Ken McKelvey (10/7/2010)

---

I am glad the order difference technique worked but unfortunately I cannot claim credit for the idea. The technique was used to win a competition but I cannot...

Greetings Ken,

We Have A Winner!!! 😀

I can't say I fully understand how or why it works yet, but it does seem to do what I have been wanting to...

Greetings Derrick,

In this case, it would show up as 1 line (2010-01-01 to 2010-01-10). I have extra code that would check for vacant or non-loaned lines as needed but...

Greetings all,

As a heads up, I do have some code that will return a correct result. The problem that I am having is that it is too slow. ...

Greetings John,

Thank you for your reply, but it does not quite answer the problem. Your solution is grouping by the StudentID first, and then getting the Loan and Return...