Can you post some sample data and the required out. I don't have quite enough test data to go on with this!

Sorry I forgot to test this code... would have been simpler for you :

SET ROWCOUNT 10000

DECLARE @rc AS INT

SET @rc = 1

WHILE @rc > 0

BEGIN

DELETE FROM dbo.webproxylog where week_number...

I'm not following you.  If you are talking about the SP code, it works fine as it is.  The server takes care of adding the ' ' (assuming it needs...

Here's a complete shot in the dark but it might give you some light .

This is a computer generated code to execute your SP....

Our pleasure .

Can you post the final solution so that users finding this thread with a search engine can benefit form your eureka moment?

Ya but it works only if the word occupation is only found once in the sentence. 

You might want to add this where condition :

SELECT CASE WHEN FieldName LIKE...

This is from an access background but hey, it's worth a shot :

try calling the sp with dbo.usp_Update_Order_Header.

Make sure...

So how was the night???

No seriously :

how to build the shrinkfile command :

Select FileID from YourDbNameHere.dbo.SysFiles where name like '%_Log%'

--gives you the first parameter

SP_helpdb 'YourDbNameHere'

--in the 2nd resultset, check the size of...

Yup and here's the link :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=323359

Well actually there's a way.  In the instead of insert you just modify or swap the value from the inserted table.  But in fact you can't change the underlying data...

Ya that should do it .

May I also suggest a job that will periodically delete useless data from that table?!?!

Ya we'll pick it up in the morning.

L8r !