Thanks for the quick response.  Both replies were very helpful.

John

I appreciate your comments and Sergiy's comments.  We've been working over the last 3 years to move our system from an as/400 to SQL Server, and a consulting firm has...

OK - thanks.   I appreciate your help.

Sergiy

Forget the Isactive_flag delete undelete stuff.  That's confusing and not related to my question.   What I want to be able to do is put a unique key constraint over a...

My question has to do with preventing duplicate records where the "key" is Client_id plus Code_id, and we're ignoring records where the isactive_flag = 'N'.  

Then if you try to "undelete"...

The Isactive_flag can only have 2 values: Y or N.  If it's N, then it means the record has been "deleted".   So I'm only concerned with the records where the...

That's what I needed.    Thanks!

This could be fine tuned a little more, but create an SP like this:

create procedure sp_quotes

 (@s varchar(200))

as

begin

while charindex(char(13)+char(10),@s) > 0

 begin

  set @s-2 = replace(@s, char(13)+char(10), ''',''')

 end

select

(1) yes - 0 means null

(2) if YY < 40 then assume 20YY, else 19YY

Thanks

It works!   Thanks

Thanks!

Could you also have something like this:

select jan_amt, feb_amt, mar_amt, Qtr1_amt,

apr_amt, may_amt, jun_amt, Qt2_amt,

Half_Year_amt

FROM (

Select *, jan_amt+feb_amt+mar_amt as qtr1_amt,

             apr_amt + may_amt + jun_amt as qtr2_amt,

jan_amt+feb_amt+mar_amt +...