I've seen this type of messages when monitoring tools change the 'show advanced options'  and forget to execute RECONFIGURE after it.

because this is a server wide setting all that is...

You are welcome

Sushila, now I am feeling hurt ..."my friend" ??? .. THAT, is too painful to bear

And you are...

A loooooooooooooooooooong time ago I saw Real Genius and it even though it was never popular I loved it because of the creative nature of the ideas portrayed

Other of my...

move you where clause for the Referal Table into the join:

Select p.DisplayName, count(r.ClientNumber) as 'Count'

from Providers p

left join Referral r

on  p.ProviderNumber = r.ProviderNumber and

     p.Facility = r.Facility and

    ...

if you really want to control that behaviour you need to know what is going to happen when a delete comes along which you haven't replied yet, also what about historical...

Juan use the UPDATE FROM as Steve posted it but without the where clause

UPDATE t1

SET FIELD1 = t2.FIELD1,

    FIELD2 = t2.FIELD2

FROM table1 t1 JOIN...

have a look at DateDiff2 on this site

Excellent point Kenneth

I as well as PW believe this is more a presentation issue than anything else. you can make the column a normal Identity and the numbering can be handled in...

I am sure PW meant to join by item and date :

Select Prices.*

From Prices

Inner Join

(

  Select item, Max([Date]) As LastPriceDate

  From Prices

  Group...

hehe you knew that I was coming don't you

There is a problem with that approach. Eventhough...

OK this is to help you with an starting point

select 'ALTER TABLE ' + TABLE_NAME + '  ALTER COLUMN ' + COLUMN_NAME + ' varchar(' + cast( CHARACTER_MAXIMUM_LENGTH as varchar(4) ) +...

Gary,

Two stored procedures for your consideration:

exec sp_update_resume

exec sp_distribute_resume

Does not looks good after what you just said ( you should take care of your self

if what you mean by (,) between parameter.. is that you need to convert them then just do it befor the call:

ex:

declare @i int, @a int , @b-2 varchar(20), @c...