Steve Jones - SSC Editor (8/19/2014)

---

We are aware of the issue. When we see SPAM, we ban the account, and all posts get deleted, but it does take a little...

The amount of spam on this site is just out of control. Something needs to happen or our users are going to go elsewhere. I for one have been around...

OK. What part(s) are you struggling with?

rodd.wilken (8/19/2014)

---

I have a store proc that generates a list of individuals who need to get an email along with the subject and body of the email that each person...

Jack Corbett (8/15/2014)

---

paul.knibbs (8/15/2014)

---

I turned 7 in the middle of 77--I just about remember all the bunting being up for the Silver Jubilee. Can't remember if that was...

This is fairly straight forward. The easiest way to do this is with a cross tab. You can find a couple articles in my signature about the static and dynamic...

LOL. Why can't you change the...

Why don't you just change your datatype to varchar(max)? It should change seemlessly and avoids all the pain associated with using the deprecated text datatype.

sgmunson (8/14/2014)

---

I guess that will teach me not to trust older MS articles. I don't mess with triggers often, and I personally wouldn't set a trigger on a...

That is the definition of the word in common usage. It is not the same thing...

sgmunson (8/14/2014)

---

I think you just need to take the point of view of the trigger. Triggers operate with tables, but can fire off of a view, so the...

Don't think I should be...

rxm119528 (8/14/2014)

---

Attached is the script for authors table.

Basically what i am trying to understand is

"You may want to insert data to columns not visible in the view. To do so...

peanut butter

What "fix"...