Sean Lange (4/16/2013)

---

Lowell (4/16/2013)

---

Sean Lange (4/16/2013)

---

jimoa312 (4/16/2013)

---

... DO NOT RUN THIS IN PRODUCTION!!!!!!!

...Run this ONLY ON A DEV/TEST server!!!!

One last thing...did I mention that you should not run this in...

Sean Lange (4/16/2013)

---

you should...

really?

to me, the WHERE just does not look right:

I see two huge issues:

first, each EXISTS seem to reference THREE tables, and there's no joins...i don't even think it should work:

WHERE...

Minnu (4/16/2013)

---

Hi,

Below is the query am using..

create or replace trigger tr_stud

after insert or update or delete

of stud_code , name

on stud

referencing old as old new as new

for each row

begin

...

it's been a long time since you followed up on this, and you've changed which tables you are referring to.

did you fix the issue on MODEL_CODE and now have the...

just a suggestion, but in the past i've used port 14330 (1433 x 10)

and also on my current dev machine, that has every version as an instance,

they use ports...

ugh; sounds more like a "Create a Blame-Thrower Tracking Device" to me;

I'd try to turn this into a list of the proactive things you've put into place to avoid disasters...

no;when you install MySQL, both providers(32 bit and 64 bit) are installed. there's...

jbulldog (4/15/2013)

---

Thanks Lowell for the quick reply. But when I altered the code as you presented it the query returned nothing. I would be satisfied if that were the case...

you are pretty consistently ignoring the possibility that values might be null.

You've got to bulletproof your code to consider datatypes (converting int to varchar, for example), where the data...

Sean's been very helpful here as well; when you ask strangers for help, you've got to put some effort and thought into it yourself. YOU are the one who has...

your sample data really needs to INSERT into your table you posted; all we will really have is whatever you post here; if we cannot simply run it in...

your outer query has Two WHERe statmeents; the second one should be an AND, i think:

SELECT

dbo.ACCOUNT.PORTFOLIO

FROM dbo.ACCOUNT

INNER JOIN dbo.SERVICE_JOIN

...

your question needs the same solution you can see in this link from a couple of days ago:

if you post DDL and sample data the way you see in that...

this thread on SSC is what i have saved, and has been working for me:

http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx