Hi,

Thank everyone for their advise,

I found out the exp_dt column which is datetime type is causing the error.

If I change it to convert(char(12),exp_dt, 103), it will be okay since

there is...

Hi,

Thank for your advise.

But my SP is in a transaction, any rollback, trigger will rollback/stop too.

hence it might not achieve what I want.

Hi,

Thank for your help.

First,any changes to the SP now or table structure, lot of existing SP have to

be change. We don't have the manpower to do it and test it.

Plus,...

Hi Otto,

First, thank alot for your advise, Yes, you get what I wanted.

However, I am using SQL Server 2000 and can't

change my table structure to use identity type column.

For my...

Hi,

I have similar problem in concentrating my column.

I have  the following query

select comp_nm from xxx

where comp_nm_id = 10000

The result will be

comp_nmid, comp_nm

================

1000, how

1000,are

1000,you

If I want to concatenate it into a...

Hi,

Thank for the advise.

1. When I edit the SP, it will default to 'Alter stored procedure xxx', so when I

press F5, it should parse and apply the new code. But...

Hi Jeff,

Thank for the advise. I know that having open transaction is bad. However,

for my application. There is many route for user to choose. Each level have different

router for them...

Hi John,

1. Thank for your advise.

2. Actually, my web application need this feature. It will let user update some data which will affect other data. This might go on for...

Hi Paul,

1. Thank for your advise.

2. BTW, during transaction, all the table involve will in some way be hold, is there any way to only lock those affected row without...

Hi,

I agreed that our knowledge, skill and brain are the best tool available in most cases.

The basic tool of SQL like profiler and monitoring tool are able to help us...

Hi,

I am also looking for some performance tunning tool and tool that

can help to monitor my SQL2k system at my client.

In the market, there are many vendor that provide SQL...

Hi,

Regarding the EFS, I like to know the following issues

1. Will the encrypted file still be encrypted after moving it to another NON-NTFS or NON-Windows OS ?

2. How to let...

Hi.

1. Yes, I am using the '' as my parameter when debugging, hence it is shown as '''' in the debug window, hence len > 1. I should have pass...

Hi,

Thank for the feedback/advise.

1. Yes, I am getting the correct result from stax68. My QA when I run it, will pass ''''

to the SP, hence it giving len > 1.

Plus,...

Hi,

Thank everyone for their feedback and comment.