What's the datatype of the column ?

Declare @a varchar(100)

SET @a = 'http://www.google.com/intl/en_ALL/images/images_hp.gif'

select SUBSTRING(@a,8, charindex('/',@a, 8)-LEN('http://')-1)

WHERE charindex('/',@a, 8) > 0

AND LEFT(@a,7) = 'http://'

This will work if the url starts with 'http://' and there...

search for "Split function" on this site and you will get quite a few scripts.

Here is one of them

http://www.sqlservercentral.com/scripts/contributions/1529.asp

Check out these links

http://support.microsoft.com/default.aspx?scid=kb;en-us;328173

http://support.microsoft.com/default.aspx?scid=kb;en-us;328151

DECLARE @v-2 sql_variant

SET @v-2 = N'Decsription goes in here'

EXECUTE sp_addextendedproperty N'MS_Description', @v-2, N'user', N'dbo', N'table', N'TableNameGoesHere', N'column', N'ColumnNameGoesHere'

Look up sp_addextendedproperty in BOL.

Look for the topic "DTS Polling" on this home page of this site. It might give you some direction.

Hi Radhika,

Search on this site for "dropping identity" and you will find couple of solutions. Another option is to add a new column to he table, copy over the value...

Try sp_help. Look up BOL (Books Online)

sp_help <Table-Name>

You can change the backup name by using sql statements

/*

Backup file name concatenated with date & time as yyyymmdd_hhnnss

*/

DECLARE @DtTime varchar(30)

DECLARE @FileName varchar(100)

SET @dtTime = CONVERT(varchar(20),getdate(),112) + '_' +...

Could be the length of line that you are writting is too long. Try writting just the last 2 fields. Or open a second output file and write the last 2...

Whoa - this update was done in 1 sec.

Thanks Joe - I made one small change though

UPDATE http_log_process

   SET log_user

      ...

SELECT Header.Mem_No, Detail.Mem_No, MAX(Detail.CrDate)

FROM Header INNER JOIN Detail ON Header.Mem_No  = Detail.Mem_No

GROUP BY Header.Mem_No, Detail.Mem_No

I was able to create the computed column with dateadd(d,0,datediff(day,0,log_date)) but still got the same error while creating the index on the computed column.

And the update query was taking over 5 minutes (killed...

Yes, there is an index on log_user.

I got an error when creating index on the computed column

alter table http_log_process add log_date_only AS

CONVERT(datetime,CONVERT(varchar(12), log_date, 101) )

CREATE INDEX http_log_process_idx6 ON http_log_process...

The current plan does not show any table scans (there was a Hash Match/Inner Join taking the most processing time). Also no triggers on the table.

I also tried having a...