Bhuvnesh (3/21/2013)

---

Kwisatz78 (3/21/2013)

---

My question is, in this case, would that be the best way to code this or would splitting the string first and placing it in a temp table...

shohelr2003 (3/21/2013)

---

Can you please tell me the basic difference between FOR INSERT and INSTEAD OF INSERT Trigger.

I know there are lots of resources on it. But please tell me...

Wait types?

Well, this SP should be pulling the job tables every 5 min or so and seeing if any are running longer than defined SLA for that job, so, if the...

SQLCrazyCertified (3/20/2013)

---

Thanks Eugene, what you mean by not really good idea?....what are the...

Not really good idea to do so, but if you really need it, use xp_cmdshell.

xp_cmdshell 'c:\MyBatch.bat'

It depends! Which exact waits types you are having problem with?

Are you sure that they are CPU dependent ones?

Who are you calling SSCrazy, SSC Journeyman? 😉

GUID's are evil! B-r-r-r-r-r! :hehe:

SQL_NuB (3/20/2013)

---

the values that are different so for example

if Active is true in DB2 and now coming in as FALSE in DB1, I need that.

as for NULL values, I...

What do you mean by this? Which values?

Also, when you compare your data in the WHERE clause the way...

shohelr2003 (3/20/2013)

---

CREATE TRIGGER [dbo].[Discount]

ON [dbo].[Product]

INSTEAD OF INSERT

AS

Declare @disc int;

Declare @line int;

Declare @pdid as varchar(10);

BEGIN

select @disc = i.DiscPercentage from inserted i

select @line = i.LineNumber from inserted i

select @pdid = i.ProdId from...

akberali67 (3/20/2013)

---

Hi,

I am trying to join the table to itself many times on a condition. Is there a way to automate number of joins based on count of something from...

More than that! It not only didn't work,...

datwungai (3/19/2013)

---

It's a former DBA that hates me because unlike him, I take my job seriously and won't give him sa permissions. He thinks...

Could...