thank you for reply but I've in T40 one millions of records ... :ermm:

thanks so much

I tried this but the table is not exporting in txt file:

[SQL] DECLARE

@SQL VARCHAR (8000) SELECT

@SQL = 'bcp mytable out \\XX.XX.XX.XX\output.txt -T -c -t'

Affected rows: 0

Time: 0.041ms

Affected rows: 0

Not Sir, the db is to remote server and I use...

This is an ongoing process, planned in the server

thank you for help.

I need to get data from a table into a file txt.

Anything since 72 hours ago from now.

thanks a lot!

thanks a lot!

thank you, but:

[SQL] SELECT * FROM tbl WHERE CONVERT(datetime, [myDateString], 103) > DATEADD(day, -3, getdate())

[Err] 22007 - [SQL Server]Conversion failed when converting date and/or time from character string.

the value of...

thanks a lot

thank you for help:

SET dateformat dmy;

SELECT

CONVERT (

datetime,

'31/12/2012 16:30'

);

Output:

2012-12-31 16:30:00.000

thanks a lot!

Yes sir, I see and I love it!

In case you have more than 5 employees...

dwain.c (12/26/2012)

cms9651 (12/26/2012)

I tried your full code, I have the same...