works perfect Liliana ... thanks again for everything

I'm a little slow at SQL, but usually can "get it" after looking at it a while.  I'm having a hard time getting Liliana's code into a table.

Jesper I wasn't...

That works great.  I'm embarrassed to ask this, but how can I get it into a table, LOL.

Lets assume I want the results I see on the screen added to...

Thanks I'm on my way to visit the school now but will try this when I return.

I'm thinking something like this.  I used 2000 for testing, changed table name to _fixdate. 

SELECT

Seq as Seq,

UserName as UserName,

Operation as Operation,

DateIn as DateIn

INTO ##TempDupStop

FROM _FixDate

WHERE Processed  <> 0

AND DATEDIFF(ss,DateIn,GETDATE()) <...

"why you are using a temporary table rather than a variable to hold the maximum sequence value"

I'm a hack.  Will look at your code.  Never used a variable.  Thanks!

I was close, figured it out.

EXEC master..xp_cmdshell 'osql -U______ -P______  -Q"SET NOCOUNT ON select * from MyTable" -dAutoMail -h-1 -oc:\output.txt', no_output

I'm using it to compare the data of two rows in five large tables.  The first row of data I'm pulling is data in the system from where the user...

SELECT * returns the data in the table.  What I'd like is the data and the column headers as data.

So in query analyzer, the results normally would look like this:

SampleField...

Yes that works well.  Thanks. 

The single command works like this:

EXEC master..xp_cmdshell 'MOVE C:\ImportData\ImportData.txt C:\ImportData\Finished\ImportDataChanged.txt'

When I add the + @NewFileName it does not work

EXEC master..xp_cmdshell 'MOVE C:\ImportData\ImportData.txt C:\ImportData\Finished\'  + @NewFileName 

The last line of this does not work  ...  any ideas?

DECLARE

@TodayDate as varchar(40),

@TodayHour as varchar(40),

@TodayMinu  as varchar(40),

@NewFileName as varchar(100)

SELECT @TodayDate = CONVERT(varchar(10), GETDATE(), 112)

SELECT @TodayHour = DATEPART(hh,GETDATE())

SELECT @TodayMinu = DATEPART(mi,GETDATE())

SELECT...

I'm getting closer:

EXEC master..xp_cmdshell 'REN C:\ImportData\ImportData.txt ImportData1.txt'

EXEC master..xp_cmdshell 'MOVE C:\ImportData\ImportData1.txt C:\ImportData\Finished\ImportData1.txt'

This will work for naming the file.  Now all I need to do is figure out how to move and rename the file.

DECLARE

@TodayDate as varchar(40),

@TodayHour as varchar(40),

@TodayMinu  as varchar(40)

SELECT @TodayDate...

Almost is probably the story of my life