Viewing 15 posts - 11,131 through 11,145 (of 18,923 total)
Can you post some sample data and the required out. I don't have quite enough test data to go on with this!
November 16, 2006 at 8:45 am
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...
November 16, 2006 at 8:44 am
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...
November 16, 2006 at 8:34 am
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....
November 16, 2006 at 8:03 am
Can you post the final solution so that users finding this thread with a search engine can benefit form your eureka moment?
November 16, 2006 at 7:48 am
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...
November 16, 2006 at 7:36 am
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...
November 16, 2006 at 7:31 am
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...
November 16, 2006 at 7:23 am
Yup and here's the link :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=323359
November 16, 2006 at 7:00 am
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...
November 16, 2006 at 6:58 am
May I also suggest a job that will periodically delete useless data from that table?!?!
November 15, 2006 at 2:56 pm
Ya we'll pick it up in the morning.
L8r
!
November 15, 2006 at 2:41 pm
Viewing 15 posts - 11,131 through 11,145 (of 18,923 total)