Thanks.

I should have been more specfic with the question.

option 1: I can have a table as follows

create table t1 (i int, t1 text) and put the XML string > 8000...

Thanks. Reading information in the link, it looks like Jason has the same idea but he also has the same question - would the method work or not. Would really appreciate...

DECLARE @dtmDateTime dateTime

SET @dtmDateTime = getdate()

SELECT @dtmDateTime as [Current Date Time],

CONVERT(DATETIME,CONVERT(varchar(11), @dtmDateTime), 112)

Declare @RequiredLength int

Declare @ToConvert int

select @ToConvert = 22

select @RequiredLength = 5

select replicate('0', (@RequiredLength - len(@ToConvert))) + convert(varchar,@ToConvert)

Declare @RequiredLength int

Declare @ToConvert int

select @ToConvert = 22

select @RequiredLength = 5

select replicate('0', (@RequiredLength - len(@ToConvert))) + convert(varchar,@ToConvert)

declare @date char(8)

set @date = '06122004'

select convert(char(10), convert(datetime, substring(@date,3,2) + '/' + substring(@date,1,2) + '/' + substring(@date,5,4)), 104)

With so many requests for deleting duplicates coming to this forum, it seems like it would be nice if Microsoft provides a query on the lines of - delete duplicate from...

Write a simple Active X script using Scripting.FileSystemObject.

If the only point is to change the database, would it make sense to use always the four part name for the table. <server><db><owner><table>.

Thanks

Another way is to run the following command and paste the output to query analyzer window and execute.

Hope it helps

select 'Grant select, insert, update , delete on ' + name...

One way is to find the date difference in date format and then usnig datepart(mm, <calc date&gt to use the group by.

One way is to use the age old approach and it may be OK in terms of peformance if the number of records to be loaded is in 100s or...

I always thought that if there is an existing table and you add an identity column only new rows will get number assigned. I just tried and was wrong and...

Thanks everyone for all the good ideas. The only question that remains is the table does not have an identity column. So I guess I have to add a column...

I am worried about adding a new column as well as the delete done in bulk (500000 rows) as it is a huge table.  What do you think?