I would not recommend using triggers for this. Use foreign keys with cascading deletes as Gail suggested.

totally

The Dixie Flatline (6/10/2014)

---

Sean, I'm just kidding with you.

I wasn't continuing this discussion in order to "win" it. The best discussions ultimately reach a consensus, because everyone understands...

No fun spoiling here!!! The discussion is a good one but you both really want to be right and...

This all started when I asked IF the OP was able to modify the table. And if so, I suggested adding a new column. Both approaches have merit and the...

timgapinski-841846 (6/10/2014)

---

CREATE FUNCTION permission denied in database 'tempdb'.

not sure why i do not have permission over the tempdb but i could not get started with these much needed tools because...

below86 (6/10/2014)

---

Having a consistent naming convention for fields. I am as guilty as anybody at not doing this, but it is driving me nuts now. Years ago we...

Please!!!

y Collins

Ed Wagner (6/10/2014)

---

JAZZ Master (6/10/2014)

---

crookj (6/10/2014)

---

Sean Lange (6/10/2014)

---

JAZZ Master (6/10/2014)

---

Ed Wagner (6/10/2014)

---

Sean Lange (6/10/2014)

---

Ed Wagner (6/10/2014)

---

Sean Lange (6/10/2014)

---

Ed Wagner (6/10/2014)

---

crookj (6/10/2014)

---

Ed Wagner (6/10/2014)

---

SQLRNNR (6/10/2014)

---

Ed Wagner (6/10/2014)

---

BWFC (6/10/2014)

---

Stuart Davies (6/10/2014)

---

Revenant (6/9/2014)

---

Ed...

JAZZ Master (6/10/2014)

---

Ed Wagner (6/10/2014)

---

Sean Lange (6/10/2014)

---

Ed Wagner (6/10/2014)

---

Sean Lange (6/10/2014)

---

Ed Wagner (6/10/2014)

---

crookj (6/10/2014)

---

Ed Wagner (6/10/2014)

---

SQLRNNR (6/10/2014)

---

Ed Wagner (6/10/2014)

---

BWFC (6/10/2014)

---

Stuart Davies (6/10/2014)

---

Revenant (6/9/2014)

---

Ed Wagner (6/9/2014)

---

eccentricDBA (6/9/2014)

---

&...

kabaari (6/10/2014)

---

Thanks! I worked through it resolve

select b.model,

count(case when substring(u.unitcompleted, 1,2) = '05' then 0 end) '5AM',

count(case when substring(u.unitcompleted, 1,2) = '06' then 0 end) '6AM',

count(case when substring(u.unitcompleted, 1,2)...

You have a LOT of implicit casting going on here where you shouldn't be. DATEPART returns an integer, not a varchar. All of your comparisons are to a varchar. Change...

sql-lover (6/10/2014)

---

SQL is delicious (6/10/2014)

---

sql-lover (6/9/2014)

---

thomaswoof (6/9/2014)

---

I'm having the exact same problem. The table had at some point been reseeded while importing data from the old version of...

greg.bull (6/10/2014)

---

Thanks for this. The query is quite simple, so I'm going to do it like this:

declare @route int

set @route = 2

if @route = 1

begin

select cast(1 as decimal(10,2)) as...