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...

Matt is correct... he's beat the snare right off that drum... and guess what? He's right! Matt and I have done a huge amout of testing and using...

Matt,

Reformatting code that you've copied from those "Code" windows is actually pretty easy (although I wish they'd just...

Actually, you can get to the precise post Matt is talking about by clicking on the following... not need to hunt pages...

http://www.sqlservercentral.com/Forums/Topic419472-65-2.aspx#bm422799