Cheers!

>>Given that the other procs don't reference this view...<<

No but the reference the BASE tables that the view is using and DUE TO THE SCHEMABINDIG on the view anything touching...

I used the name DISCHARGES for the lack of one supplied by you.

But yeah, feel free to replace it and you will be good to go

why do you need to do that? varchar ---> int ---> varchar

how about

declare @s-2 nvarchar(40), @sval int

set @s-2 = 'select @sval = 0x2C'

exec sp_execsql @s-2, N'@sval int out', @sval...

Aparently your Agent(s) are still active!

You have to remove replication! (if you are not using it for any othe publication)

what type of replication did you set up?

Yep, you are right. I call it the cut and paste effect

(H3PRBL-H3POD+H3POD+H3IOD+H3AIBL+H3FOD) / (case when [H4CURR]= 'CHF', then 1.5476 else 1 end)

AS LNRTotalClaimEUR

hth

and to add to johns' suggestions try to limit the calculations on the temp table to a date range

hth

Is this what you are after ?

select  d1.authid, d1.memid, (select max(dischargedate)

                              from  discharges d

                              where Subq.memid = d.memid

                              and

                              d.dischargedate < SubQ.MaxDate) as PrevDate

From

discharges d1

join

(select memid,...

alter table table_name add [col] [int] NOT NULL CONSTRAINT [CON] DEFAULT (0) WITH VALUES

go

Maybe I don't understand your problem but

Is this what you are trying to accomplish:

select    a.StreetCode

 , a.HouseNumber

 , a.Equal_Unequal_HouseNumbers

 , a.AreaCode1

 , b.Areacode2

from

 TableA a

 join

 TableB b

 on a.StreetCode = b.StreetCode

    and a.HouseNumber >= b.HouseNumber_From

   ...

how about :

select NPA, NXX, CIRC

from test

where CIRC = '9010'

union all

select NPA, NXX, CIRC

from test t2

where not exists ( select *

     from test t3

            where CIRC = '9010'

   ...

are you sure the transactions are being delivered to all subscribers?

I have no idea of what is unique on your data but this is a start

Select a.Company, a.Contact, a.CustomerNumber, a.State, a.City From

   ...

this is supposed to be for internal use but... I can anticipate that x0802 means has haccess x0801 -- Does not