I would say this risk exists more times than we'd like to admit because we don't always know which SPs are dependent on which tables...

Is there some reason you don't want to do this?

IF NOT EXISTS

(

select H

from table_1

where a = X...

Erikur is too quick for me but here's another way. Edit: If you need to limit your results to only those with 2 or more matching criteria, replicate the...

marko.celarc (2/5/2015)

---

I prefer using merge statement combined with output which enables me to perfrorm additional inserts.

Below is an example of such statement; my task is to make an update ...

Let's see if I can work past my blushing here and help out a little bit.

First off, Alan.B's got a great solution as it knocks off both of your specific...

When choosing the components to include in the PRIMARY KEY, you must allow for uniqueness. Meaning that you can only have one row per company, employee, pay period and...

Wayne West (2/4/2015)

---

This is the code that doesn't work:

SELECT st.*

FROM Students AS st

INNER JOIN SeekerUsers AS t

ON SeekerUserDBLogin = SYSTEM_USER

AND (t.SeekerUserRole = 1

OR st.DistrictNum IN (SELECT...

I am surprised and somewhat relieved that I am not entirely full of crap, despite what others may be saying...

Grant Fritchey (2/5/2015)

---

Brandie Tarvin (2/5/2015)

---

So I just got a workplace reminder to wear red tomorrow because of National Red Day[/url].

I didn't even know this was a thing, but it is....

ChrisM (@Home or @Work, whatever) - Your formatting certainly highlighted my calculational gymnastics better than mine did because of the limitation of the SQL code frame/window. Well done!

Interesting alternative...

GilaMonster (2/4/2015)

---

And about 5 more 'generating units' have gone offline. And it's still summer, I dread to think what winter's going to be like, current forecasts are we're getting the...

patrickmcginnis59 10839 (2/4/2015)

---

dwain.c (2/4/2015)

---

patrickmcginnis59 10839 (2/4/2015)

---

dwain.c (2/4/2015)

---

Sounds like a problem I had recently and the same solution too.

SQL Query invoked by Crystal Reports v9.2 Performance Issue

I'm a great believer in...

Yeah, me too. That's why I replied to this thread in the first...

Lynn Pettis (2/4/2015)

---

dwain.c (2/4/2015)

---

Lynn Pettis (2/4/2015)

---

gatorfe (2/4/2015)

---

We are running sql 2008 R2. We have the JE_DATE field set up as an int. We are trying to subtract 30...

KGJ-Dev (2/4/2015)

---

thank you dwain for your explanation. The reason why i am asking, is i have some exe's which have some program running on that time and it produces time...