but that shouldnt affect from first @@rowcount value..right?.. is thr any other way to make sure a rows are inserted or updated?

yes ofcourse..... Perfect guidance... thanks jeff

http://www.sqlservercentral.com/articles/T-SQL/62867/... i got ur article jeff

Hi Jeff...

Could please tell me why you use following snipit in your split function?... whts it purpose exactly?

WITH

E1(N) AS ( --=== Create Ten 1's

...

great!!!!!!! thank u jeff, wayne and ALZDBA for ur help....

Great!!!!... thanks a lot

perfect!!!!!!!!thanks a lot....

in mean time if someone access the same field tht will cause inconsistency or duplication

oh.. thanks for ur valuable information

thanks a lot... i will try as u said....

Hello Pradeep...

Please can u tell me how trace works... this is wht exactly i m looking for... can u pls explain?

actually in every SP i have to make a log entry of every tranction done within the SP. i have to log both success n failure of transaction.... any...

thanks a lot for reply.... can i store this log in any file? i mean can i create my own error log file? logging my desirable information not only error...

Hi..

Thanx a lot for ur effort.... but my doubt is how can i pass a result set to java....

for ex.. i have empno from employee table.

...