Use UnPivot.

Haven't done a performance comparison, but I wouldn't be surprised if your all math solution were faster than just about any string solution including the one I posted.

Instead of using EXEC... use PRINT(@Query) and post the result, please.

Thanks for the code and the write up... it's exactly what I was afraid of though. In your example just for layer #1, if you have a million rows...

gan (8/26/2008)

---

Jeff Moden (8/25/2008)

---

If the clustered key is set by date or, perhaps, identity and the identity column is indicative of entry order, then sectional deletes (or insert to archive,...

MrBaseball34 (8/26/2008)

---

Kind of wondering how you would catch any errors when moving the file.

I make a copy to a tempfilename passed into the procedure and then if there is an...

All those are well and good, but the OP still hasn't provided an answer to the question of which numeric field (or both) to sort on for some of the...

sg (8/26/2008)

---

Hi Amit Khanna,

Thanks for ur reply. I am an asp.net developer, not a dba :rolleyes: but still i have a good knowledge on db.

I have used joins on...

Sorry... new job has kept me busy... I think I may have a solution soon. Yep, I know you already have one using REPLACE on the quotes... there's just...

developer6 (8/26/2008)

---

Jeff: I can only assume that you are not resident in the UK. If being stupid was in any way a prevention for getting old the population...

swtrans (8/19/2008)

---

I have a table with data in 4 columns.

C1 C2 C3 C4

110 99...

Start with using Visio to reverse engineer a diagram of the database... hopefully, they actually used Foreign Keys...

Hi Jim,

Indexes also count towards the size of the mdf. If you have wide indexes and a clustered index along with "fk" indexes, the size of your indexes can...

Even if you concatenate and convert to text using something like...

[font="Courier New"]SELECT CAST('1'+'2'+'3' AS TEXT)[/font]

...you still won't be able to see more than 8192 characters in a single column, view...

Robert...

I know it's been over a year since this article came out, but want to say what an outstanding article you've written... very easy to read and great examples!...