Happy to help.

http://www.AcronymFinder.com

HTH.

And I guess this is why >>

create proc p2 as

insert exec p1

GO

create proc p1 as

insert exec p2

GO

Well it can be done... but I'd strongly suggest going to the insert into temp table solution.

Can we see the proc code?

Can't happen with those string manipulations.

also the question would have been, can I get divide by 0 errors and not : "that I'm occassionally getting an error that would indicate...

BOLS.

Try it on a test server AS YOU ALWAYS SHOULD ANYWAYS.

I think it's time you start TRYING to learn on your own. I'm not paid to show you every...

yup. Or recreate the table with the option set to on so you wouldn't have to set it at each statement.

RUN this before the update :

SET ARITHABORT ON

or I think you can also try to recreate the table with that option on too but I'm not sure it'll solve...

Worth a shot if it means avoiding dynamic sql .

Just have to cast everything to varchar...

don't you mean this ?? :

select

case @ReportType

when 'A' then ColumnA

when 'B' then ColumnB

ELSE NULL

END,

count(*) from test_table

group by

case @ReportType

when 'A' then ColumnA

when 'B' then ColumnB

ELSE NULL

END

ALTER TABLE Inet.dbo.dmvrequest ADD

DRclaimRaw AS LEFT(REPLACE(DRclaimNumber, ' ', ''), 256)

GO

CREATE NONCLUSTERED INDEX IX_Temps_DRclaimRaw ON Inet.dbo.dmvrequest (DRclaimRaw)

Can you post the table ddl and some sample data, then when you add...

That can't be caused by that script... was that problem present before you did this?

HTH.