Lots of good suggestions! Thanks, guys! It did cross my mind that 90 days <> 3 months, but the person giving this spec to me wasn't too clear so I...

If you can spare some time... why is that the chosen method, though both gives exact result including milliseconds?

Thanks.

JN

I think I solved my own issue by posting here...

GETDATE() - 90 works just fine giving me 2/10/05, which is 90 days ago!

JN

I am not sure how I can do Insert only. I need to insert IDs only if they are not already found in my table, but if they are found...

I did read about deadlocks so have some general knowledge on that. Just not sure how to resolve related issues.

In my sproc there is only one INSERT statement at the...

I don't think this would work for what I need to do...

I have a 3rd Sproc that executes from 2nd Sproc and inserts or updates values (Checksum) into a table...

I am not sure if that can be done...

The 2nd Sproc doesn't have Param like @OfficeID and for me to do the Function call from 2nd Sproc, I need value...

Not sure what your situation is, but if Timestamp field is of data type DATETIME or SMALLDATETIME then yes, you can do following:

DECLARE @NewRowsTime DATETIME

SET @NewRowsTime = '4/5/05'

SELECT * FROM...

Thanks, I tried and it's working, but getting an error - thinking need to change syntax? Following is how my Sproc looks like now:

CREATE     PROCEDURE...

Thanks for your response.

Let's see...

UpdateDt is NOT realiable, because I don't care about each and every field changed in this table. If the fields are NOT used in my SP then...

Thanks for all your suggestions. What I still would like to know is how can I stop my DTS from executing if let's say I found using FSO that the...

The following command works now:

XCOPY \\WEB-JNN-IISJNN1\METROS\PUBLIC\106-COLO\JNN_ID_PHOTOS\*.JPG C:\TEMP\*.* /D:3-21-2005 /S /L /EXCLUDE:\\WEB-JNN-IISJNN1\METROS\PUBLIC\106-COLO\JNN_ID_PHOTOS\ExcludeFolder.txt'

If you read about this command in Windows Help then it specifies that the exclusions must be provided in...

Yeah, try all your suggestions already, but same error, Can't read file: \Thumbnails\ OR Can't read file: "\Thumbnails\" OR Can't read file: \Thumbnails\*.*

I am looking at using XXCOPY from http://www.xxcopy.com...

I am trying to exclude the directory \Thumbnails. I tried your suggestion, but get the same error. See following that I got from DOS... but it doesn't work for me.

XCOPY...

I found a command line solution to what I need to do, but it's not completely working...

Exec master..xp_cmdShell 'xcopy \\web-jnn-iisjnn1\metros\public\106-colo\JNN_ID_PHOTOS\*.jpg C:\TEMP\*.* /D:3-21-05 /EXCLUDE:\Thumbnails\ /S /L'

If I remove the EXCLUDE:\Thumbnails\...