"Re: "Who on earth would put that on a credit application or purchase?" - obviously a married man with a mistress...there can't be a more "desperate" cause for a credit...

The purpose of this site it to give people a place to  learn. No one said that the only things being taught here is SQL.

I will be happy to make the post. I have been a nature lover since I was 14. Such beautiful shapes, sizes, colors, all different and all lovely.

Could you please post your DDL and data.

check this web page

http://www.aspfaq.com/etiquette.asp?id=5006

HTH

Mike 

The purpose of this site it to give people a place to  learn. No one said that the only things being taught here is SQL.

Ray thanks for the great link. I will stick this one in my pocket and use it often

Mike

I think I have one of the last 386s still running. I keep it so when I get frustrated with slow I can be reminded of what SLOW really is. Turn...

The proplem is one of scope. You are opening a session setting the 'SET IDENTITY_INSERT" on/off then closing the session returning the identity_insert property back to off the default value. Try something like:

SET...

syshila you are right as usual. And in honor of my being is such a foul mood I am going to do the...

J.C. was actually kind (well for him kind  ) not even a single rant. He is always worth reading as his knowledge base is HUGE...

Just an aside one of the things I love about C is that when you want to delete file you just Kill it. So much more satisfying.

Sorry asleep at the wheel this morning change the statement to. Is not null works as well as >0

hth Mike

IF Object_Id('tempdb..#guk_temp_current_appointment_card_roles') is not null 

   DROP TABLE #guk_temp_current_appointment_card_roles

change this IF Object_Id('#guk_temp_current_appointment_card_roles') is Not Null

to IF Object_Id('#guk_temp_current_appointment_card_roles') >0

hth

Mike 

Hi formating is best i performed on the client rather than the server.

Mike

sushila sometimes i feel like I am on a merry-go-round the scenes change but You never get anywhere.

Mike