I tried my hand at curing my own bacon for the first time. It came out of the cure Saturday morning and hit the smoker later on Saturday. I was...

ScottPletcher (9/2/2016)

---

Sean Lange (9/2/2016)

---

ScottPletcher (9/2/2016)

---

A clustering index is enough to avoid having a heap, you don't have to have a primary key. In particular, don't slap an identity column...

ScottPletcher (9/2/2016)

---

A clustering index is enough to avoid having a heap, you don't have to have a primary key. In particular, don't slap an identity column on the table...

ZZartin (9/1/2016)

---

Lynn Pettis (9/1/2016)

---

xsevensinzx (9/1/2016)

---

David.Poole (9/1/2016)

---

My definition of good enough would be significantly lower if the"we promise to fix this if it causes problems" was a firm commitment rather than...

djj (9/1/2016)

---

Sean Lange (9/1/2016)

---

Odd...I can't find it....

Odd...I can't find it. And when going...

There is still something missing here but why not just add an identity column? Then make it the primary key since it doesn't seem to matter what the clustered index...

J Livingston SQL (9/1/2016)

---

am I being a bit stupid here....but given the following I get the same results for each city ???

shouldnt it

London 0.75

Madrid 0.25

Declare @t table(City varchar(6),YearMonth varchar(7),Gender...

quentin.harris (9/1/2016)

---

@Sean - Thanks for the swift response.

This worked when i put in into the query which selected the source data used for the table i presented (which was the...

antonio.perez (8/31/2016)

---

Thanks Sean

I rewrote the stored procedure eliminating the sp_ prefix in the call to another procedure, regarding the function calls do not quite understand you want to tell me,...

What a great job posting ddl, sample data and the desired output!!! When you post all the details this makes it so much easier to help. Thank you!!

The query for...

GilaMonster (8/31/2016)

---

So, I got roped into doing a professional development session for the local SQL Saturday.

"Becoming a successful SQL Developer"

Never done a professional development session before. Not sure how to...

There are a number of things I would recommend from this code. First, try to figure out what all those functions are doing because using a loop like this is...

Eric M Russell (8/30/2016)

---

Personally, I dislike coding CRUD procedures, because it turns into busy work and becomes a distraction with all the numerous tasks that have to be tracked...

At our rehearsal dinner my father in-law (to be at the time) quoted the entire "mawwiage" passage. It was awesome!!!