Heh... if only it were that simple, Gary. 🙂 Op wants the 40th row... not the top 40. Of course, this is SQL Server 2005 and TOP is...

Chris Morris (9/10/2008)

---

Thanks Jeff, and thanks also for posting up your tally table article. One of these days I'll take the time to put them in my sig

INSERT INTO sig...

Chris Morris (9/10/2008)

---

Hi Khushbu

You're welcome, thanks for the feedback.

The number of rows will probably matter if there are hundreds of thousands. If the query runs too slowly (and it runs...

SanjayAttray (9/10/2008)

---

I know when tempdb size has grown as its a process which we perform once in a 3 months. I needed the space back because of space issue...

Well done, Chris! And, no bloody UDF, either!

khushbu,

If you don't know what a Tally table is or does, please refer to the following article. I believe you'll find...

I found absolutely no correlation between soft-skills...

There's lot's of tools like Performance Monitor, etc. But, I didn't use anything quite so sophisticated...

Good article, but you do have to audit all the drives beforehand to use it. And, what if a new drive is made available by the SysOps? The...

Heh... thanks for the feedback guys.

Timothy! Great article on NO EXPAND. Nicely done!

M Roush (9/9/2008)

---

This is nice however, how can u make a view more efficient when you are using other views or a linked query in the view? I guess...

Or, you could do it the way I showed you and not worry about correlation. 😉

GAURAVKAUSHIK26 (9/9/2008)

---

You can define cr/lf delimiter for getting data in rows. As far as columns are concerned, you can use substring function of sql to create and fill columns. eg:...

gardenlady (9/8/2008)

---

I'm back from vacation and working on this code again. I'm hung up on creating (or recreating?) the indexes. Here's a piece of my code. The error I get...

keywestfl9 (9/8/2008)

---

TYPE PFORM TNAME ...