I am working with Sql 2000.

I have a job that runs and successfully gets the data I need.

It creates a file that is too big for I want.

SELECT (CPARENT_ALIAS)+ '.' +(CUSTOM_ALIAS) AS clientmatter
FROM dbo.CUSTOM2

What I need is to get just the data that was written today in my output file?

what can I add that will give me the differential data? (doesnt even have to be changed, can just be the new data added to the table)

thanks for the help.

Do you have a date column in the table? And, if you do, it would sure be helpful if you told us what it is...

--Jeff Moden

Use D-softs Data Comparer to help youwww.d-softs.com