Eugene Elutin (5/22/2012)

---

Jeff Moden (5/22/2012)

---

...

By posting data in a format that you need 2008 or above for, you're cutting out some pretty hefty SQL Ninjas who may not have a...

Hmm... Why do you think that every statement needs to end with a semi-colon in 2008R2? Also, GO is a batch terminator and will never require a semi-colon.

No. Partitioning is not a performance enhancer, it is to make maintenance easier and more manageable. There is no reason for you to partition this data.

How would any of that information, if it existed, guarantee that the function was obsolete? 🙂 I personally believe that the proper and best way to do it is to...

Tava (5/16/2012)

---

I didnt even know you could do that, you learn something new everyday. I will give this a go and hopefully I pick it all up but at least...

Sample code you can put at the end of your SP. MAke sure you declare any missing variables as I did not have time to completely edit it.

set @subject...

I would write a stored procedure to pull the data. I would then call that stored procedure from reporting services to generate a report. Either that, or create...

SQLCrazyCertified (5/16/2012)

---

Lynn Pettis (5/16/2012)

---

SQLCrazyCertified (5/16/2012)

---

erics44 (5/16/2012)

---

Hi

I have always been under the impression that in tables where there are a lot of inserts a clustered index should be avoided and clustered...

My first guess is the TEXT column. 2nd guess is the check constraint. Were any of these things added right before you saw the first error?

We tend to use RETURN in all of our SPs that are called by an application. They return 0 for success and then any number of integers depending on...

Can you please provide DDL for the table including indexes and such?

Ok, so it is more like 4 columns that have events in them where the data between columns is not necessarily related except by date and patient.However, just because a...

Ok, so in the example I referenced... Is there any relation between the first Type 1 measure to the Type 2 and Type 3 that makes it appear in the...

Cadavre seemed to grasp what you needed much quicker than I. Kudos! Can I ask, though, what is the purpose of this data. I ask because in your...

DataAnalyst110 (5/16/2012)

---

Hi Jared - You don't happen to have a link to...