This is just my "political" opinion but Health Care in the US is Huge business and in the US big business is the "bible" of the country.  Changing it from...

Your welecome.  Thanks for the feedback.

James.

Create a SQL Job with two steps.  The first step checks for the record and if not found then raise an error (severity 11).  Set the job to not process...

As for preventing the casts in each query I recommend bulk loading to a "staging" or temp table then have a function (created seperately) that merges/updates or replaces the values in...

No guarentees since you didn't post the full table definitions but based on what I saw I would think this would work:

UPDATE dbo.EMPLOYEE

SET CongDist = r.CongDist,

    UpperDist = r.UpperDist,

    LowerDist...

Thanks Jeff (sorry Peter).  I read it several times but my brain just wouldn't interpret it that way.  Must have been a senior moment.  I just re-read it and I...

Hey Peter, nice and neat, but you don't need the last " / 100.00".  It will give the -5 to +5 range without it.  At least when I tested it...

Try:

http://www.lincmad.com/countrycodes.html

James.

I don't have any direct knowledge of this error but a quick google search showed a number of similiar entries.  Most pointed to MDAC problems, maybe an older version and...

Ok, if you have to have negative numbers you could try this:

update mytable

set myvalue = myvalue +

              case when RAND(CAST(NEWID() AS VARBINARY)) > 0.50

                   then CAST(RAND(CAST(NEWID() AS VARBINARY))*-5+1 AS...

Try:

update mytable

set myvalue = myvalue + CAST(RAND(CAST(NEWID() AS VARBINARY))*5+1 AS INT)

James.

Oops, guess that won't produce any negative numbers.  Sorry.

Your welcome, and thanks for the feedback.

James.

Try:

update

telematchout set telephone = case when telephone is null

Ok, I'm confused.  High Safety is not one of the operating modes that I could find.  Since the other two listed were referenced and definately NOT automatic failovers I select...

Rex,

   You have my prayers and best wishes.  I bought a ticket and wish I could do more.  I'll try to remember and get another one next month.  Try not...