Check to see if @blocks is null before sending the email 🙂

I don't believe custom types will show up in object_id, try.

IF EXISTS(SELECT * FROM sys.types WHERE name = 'BP_Data_XXX')

Revenant (6/11/2015)

---

Eirikur Eiriksson (6/11/2015)

---

Ed Wagner (6/11/2015)

---

eccentricDBA (6/11/2015)

---

djj (6/11/2015)

---

Ed Wagner (6/11/2015)

---

crookj (6/11/2015)

---

Ed Wagner (6/11/2015)

---

djj (6/11/2015)

---

Stuart Davies (6/11/2015)

---

BL0B_EATER (6/11/2015)

---

Ed Wagner (6/10/2015)

---

Eirikur Eiriksson (6/10/2015)

---

Ed Wagner (6/10/2015)

---

ZZartin (6/10/2015)

---

Manic Star (6/10/2015)

---

Ed Wagner (6/10/2015)

---

Eirikur Eiriksson (6/10/2015)

---

crookj...

You hire a trust worthy sysadmin and pay him well considering he has access to everything you do.

bureaucrat

You might be able to try something like this(fill in field names for your table since you didn't provide any DDL)

CREATE TABLE #TEMP(COL_ONE varchar(30), COL_TWO varchar(30), ACCOUNT_NUM varchar(30))

INSERT INTO #TEMP

SELECT...

Hmm... well there's only one date in that table, how do you plan to get the original paid date and the most recent change date? And based on the...

Jeff Moden (6/7/2015)

---

The best communication methods and systems in the world are totally useless unless a company adopts a development and maintenance policy that few companies seem to implement and...

Latte

Couple thought, first 13000 records a month is a relatively small data set. Second why are you trying to lock the records at the data base level, wouldn't you...

Andy Warren (6/8/2015)

---

Jeff, maybe I didnt ask the question well. I'm not arguing with your choices - yours to make! Just curious to understand if/why joining a company that has...

There's plenty of other reasons not to take a government job.

There's also a pretty fundamental difference between government jobs which work...

Just to throw this out there but normalization is a methodology of data structures are designed, constraints like primary keys or foreigns keys are means to enforce that method of...

EdVassie (6/5/2015)

---

You could try a little role-play.

Call your developers into a meeting, and have a box of paper left outside the room.

Tell a developer you need some paper and ask...

Lynn Pettis (6/5/2015)

---

Eric M Russell (6/5/2015)

---

Andy Warren (6/5/2015)

---

Eric, I'd agree with that. But suppose there were two of you doing that. Same job, same skills. Virtual twins. Should they get...