Thanks. I restructured the string and put my Getdate() is single quotes and ran it and it worked ...Thanks

IF OBJECT_ID('tempdb..#Missing_Dates') IS NOT NULL

DROP TABLE #Missing_Dates

GO

CREATE TABLE #Missing_Dates(RowsINT,TransactionDate Datetime,Rundate Datetime)

--INSERT #Missing_Dates VALUES(244 ,'2008-07-28 00:00:00.000','2008-07-30 00:00:00.000')

--INSERT #Missing_Dates VALUES(11307,'2008-07-29 00:00:00.000','2008-07-30 00:00:00.000')

--INSERT...

Thanks got it right and it works with the variable.....

This now gives an error

Msg 102, Level 15, State 1, Line 62

Incorrect syntax near 'END'.

and the rest of the script doesn't work

I read the code and tested it and it works only if you hardcode the binary value you want to convert. But I want to use it on two tables....

Table...

Thank you...It works

How is this procedure invoked if the input is in a table #test

BUt this splits the string into one column. I want to split it into 14 columns so the result set is like

col1 col2 col3 ..........

how do I achieve that ...

I will try the full text indexing strategy and see what sort of performance I get if not I will go for the hits on words

Just so we are on the same page.. The < @EndDate + 1 is just to make sure that you select everything within the selected date range and the...

THANKS...IS USING BETWEEN ON DATES NOT A GOOD THING ?

THANKS...I WILL REMEMBER THAT NEXT TIME. I ENDED UP INCREASING MY AMOUNT COLUMN FROM DECIMAL(13,3) TO

DECIMAL(18,3) AND IT RAN SUCESSFULLY.

THANKS A LOT

I modified my script and when I run it, it blocks itself ...

--Create Rownum to allow "walking through the table"

ALTER TABLE tbExtract ADD Rownum INT IDENTITY(1,1)

--This code will return...

Thanks will check it out now and modify my script. I ran it and it loaded the files in 30 mins, thats after using bulk insert..

Thanks got it now. I have amended my script and it works.

--Uncompress Zip Files

EXEC master..xp_cmdshell '\\phumba\daily$\INFiles\Apps\gzip -d -S zip \\phumba\daily$\INCT\*.zip'

--Rename all files to files with .txt extension

EXEC ...