I'm gonna say this one last time Sushila. I wanna freaking turn PRO and make a living a playing pool, so THAT'S MY LIFE.

Bob, I know this can be done, but that can't really be error proof (good pick). I know you can do it on the server, but you basically combine...

The whole asp call code with this version.

.Parameters.append.CreateParameter("@SRhospitalCanvass", adChar, adParamInput, 10, SRhospitalCavass)

Writting it isn't very long, but testing it is.

run this in query analyser :

exec sp_helpindex 'procure_det'

check for primary key, clustered in the description

Also are you trying to update a table or something else?

yup, simple search and replace which can't really fail in this case.

You' need to rewrite the whole freaking thing... making sure you don't make any mistakes, this would take you days, hours if you're good. Mine is 100% tested, so...

I would date more, but it would interfere with my work, pool and or social life so I refrain from it .

update procure_det set

vendor_no = 'GINALEVAN',

remit_to = '1',

buy_from = '1',

gtc_code = '1'

where vendor_no is NULL and source_code = 'A'

does this work?

And do you have a primary key.

OK

final thaughts :

MyCn.Open 'just needs an opened connection before the next line

MyCmd.ActiveConnection = MyCn 'set the connection

MyCmd.Execute exec_sp_biginsert

MyCn.Close 'assuming you're done with it

ReturnValue = CInt(MyCmd.Parameters("@Return").Value) 'you'll need to declare...

That's what we told you in a not too beautiful way. Good luck with that project.

Post the code you are using... you can update only from one table at the time, but you can update all the fields at once if needed.

That's the code for the asp side of it!!!!!!!!!!

Did you actually test it?

You can't use As Datatype in asp and you didn't correc this yet : Set MyParam = New...

I don't wanna seem over analytic here, but if your table comprise such rows :

"caty 1" --typo

" cAt 2" --space before

"cats 3" --actually correct

"cats and dogs" --WTH??

and that you...

I feel like saying : Can you provide less details?? But you couldn't.

What exactly is happening, where, how did you get there, what's the problem?

Here's a solution that doesn't need a trigger... but I'd test it against the trigger to see which one is faster :

Create an indexed view on that table :...