In SQL also its possible to use cursor...

Can you please explain your query with example ?

🙂

I got it...

DECLARE @temp_table VARCHAR(100)

SET @temp_table = '##my_temp_table'

IF NOT EXISTS (SELECT 'x'

FROM tempdb..sysobjects

...

Try with this...

select cast(right('14:19:57.110 CET Wed Oct 10 2007',11) + ' ' + left('14:19:57.110 CET Wed Oct 10 2007',12) as datetime)

Is this format u r looking for..?:)

Good day

Ignore my above reply

It's wrongly posted here

😎

This one is useful link to search and replace SQL Server data in all columns of all tables, in a given database?

http://vyaskn.tripod.com/sql_server_search_and_replace.htm

🙂

more info about worktables

🙂

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarsqlsg/html/msdn_showplan.asp

MSDN ->

The relational engine may need to build a worktable to perform a logical operation specified in an SQL statement. Worktables are typically generated for certain GROUP BY, ORDER BY,...

Thanks for your response

I am creating using import/export wizard

It could be fine if you offered both way, i will try on those way

thanks in...

Hi

How to create task in DTS package. So far i am creating single DTS package for each table.

thanks in advance

venkat

Thanks to all for your soultion on this. I am also working on that and will back to you as soon as  i got the solution for this