Absolutely no problem, Gail... that's one of the highest forms of compliments I...

There's not much you can do to "tune" this proc... it needs to be written to use proper set-based code instead of the RBAR-on-Steriods that you're using in both this...

This is a duplicate post (I hate these!)... Check for the answer I gave on the other identical post...

http://www.sqlservercentral.com/Forums/Topic422993-338-1.aspx

So I have the following questions:

1) Does SQL Server 2000 allow me to access ntext fields from the inserted or deleted tables? If so, why I am getting the above...

Having those settings in the sproc will help with a lot of things... but I think you need to also have those setting turned on for YOUR session when you...

I'd keep it simple... create a linked server to the "other" server. Then do a SELECT TOP 1 * FROM [linkedservername].Master.dbo.Sysobjects (or, in 2k5, I think it would be...

I'm curious though... with over two billion numbers available to the INT datatype, why do you feel it's necessary to keep the ID column "gap free"? What is the...

Heh... Yes... it would return "45" on "4 out of 5 stars"... it wasn't designed to make "descisions"... current function was only designed to return characters that meet a pattern.

I...

Since it's been a 3 ¹/₂ days since I asked, I don't feel bad about saying this, at all...

I knew it! What a jerk you are! Folks like...

Maybe I'm going blind... but I don't see anything obviously wrong in your query code... heh, well except for the fact that it's embedded SQL 😉

With that in mind, you...

I'm thinking that if you want us to fix your car, ya gotta let us look under the hood... post both versions of the code and the precise error message.

Or, better yet... best of both worlds

select sum(CorporateRevenue07.CommissionableRevenue) as totals,

CorporateRevenue07.Code

from CorporateRevenue07

where CorporateRevenue07.ProcessDate = '6/1/07'

and CorporateRevenue07.CommissionableRevenue > 0

and CorporateRevenue07.Code like 'WCSSHORE%'

AND CorporateRevenue07.RevDate = '1/1/07'

and CorporateRevenue07.Gate = 'WW'

and CorporateRevenue07.RevType = 'TB'

group by...

select sum(CorporateRevenue07.CommissionableRevenue) as totals,

LEFT(CorporateRevenue07.Code,8) AS Code

from CorporateRevenue07

where CorporateRevenue07.ProcessDate = '6/1/07'

and CorporateRevenue07.CommissionableRevenue > 0

and CorporateRevenue07.Code like 'WCSSHORE%'

AND CorporateRevenue07.RevDate = '1/1/07'

and CorporateRevenue07.Gate = 'WW'

and CorporateRevenue07.RevType = 'TB'

group by LEFT(CorporateRevenue07.Code,8)

Is it possible to say, "Starting at the right of the DestHost field, go left until the 2nd dot and drop that dot and everything to the left of it....

Actually, Michael... according to that bit of information, I don't think you give a rat's...