You can't suppress the trigger entirely based on a condition like that... it's going to fire every time. But you could do that check as the first action of...

Take a look at the article in my signature on cross tabs / pivots.

You're using just moncall in your middle expression, not moncalladd or moncalldelete... that table isn't in your query.

You have to stop thinking of it in terms of elapsed time, as Dave said. That's not what the calculation is intending to figure out. You can go...

You can get this via fn_get_sql (if you have the right SP, it's one of the hotfixes on sp2 or included in SP3). You can also use profiler.

http://phelabaum.com/archive/2010/03/dbcc-inputbuffer-vs-fn-get-sql/%5B/url%5D

If you're...

Have you tried creating a linked server to the pervasive db from your MS SQL Server db and doing the join using that?

Jeff Moden (3/11/2011)

---

Lowell (3/11/2011)

---

how about using the PARSENAME function to chop up the IP address?

--using Stefan's setup:

/*--Results

(No column name)(No column name)

1172.24

322.25

3223.25

*/

SELECT Count(IPAddress),parsename(IPAddress,4) + '.' + parsename(IPAddress,3)

FROM #tempIPTable

Group By parsename(IPAddress,4) +...

If I were to hazard a guess, it'd have to do with when the optimizer was choosing to apply the WHERE clause. It might be applying it before the...

See the link in my signature on CrossTabs/Pivots. Great explanation of how to accomplish this there.

Also, if you want people on the forums to help you write code, you'll...

You need to decide which fields you care about when they change. Instead of just joining based on client_code, maybe you want to join on client_code and Month, or...

drew.allen (2/10/2011)

---

What I've done in these cases is use a TRY/CATCH block leaving the CATCH block empty.

BEGIN TRY

EXEC msdb.dbo.sp_send_dbmail <your parameters here>

END...

The easy way: Delete any rows that match the criteria of the one you're about to insert before you insert it.

The better way: Check to see if the row...

This syntax won't work for an object that doesn't already exist:

insert into #AposGrpwisetemp

Select @ReportNo ReportNo,* from AposGrpwisetest

You'd instead need to do that like this:

Select @ReportNo ReportNo,*

into #AposGrpwisetemp

from AposGrpwisetest

That syntax...

To my knowledge there's nothing standard that'd do that for you. I've written similar functions in the past to do incrementing that included letters. Here's one of them...

That table doesn't exist at the point that you're trying to select out of it. Check the following.

Is it actually a "temp" table, (Preceded with #),

Is...