yes the second one takes null and updates to processed then selects based on field="processed"

I know its probably the best way to do it....

Hi Jared

Thanks for getting back..

I've tried this...

There are two update that happen,

one changes the flag for the previous run to completed

the other changes null to Processed

then...

Hi Ed..

Thanks,

Actually I did sort of do the first one...

first part of the query updates the flags marked 'Processed' to 'Completed'

second part updates "null" to "Processed"

then data is written...

Hi Ed,

Thanks for getting back..

so I followed the blog and it worked fine

USE msdb

EXEC sp_start_job @job_name = 'C387D481-5A3D-4DF8-89BC-10A55A5FE1F4'

But....

I wanted to run a second step which EXEC an sp which...

Static its in XML format

Thanks for the replies...

It's odd The report is blank when I run w step2(The update of the flag)

I'll look closer to see if I'm missing something.....

sorry for being really CONFUSED...

If I run The SP I get the xml in the results window

but running thru the email when I open I get different results??

BTW:

I was just looking again and it outputs as a TXT file..

IS it the for XML statement ?

Thanks for the info E4D4...

Ok so after what you send I have this ...

Created an SP XMLTest...

USE [Test]

GO

/****** Object: StoredProcedure [dbo].[XML_Test] Script Date: 04/30/2013 10:29:34...

Thanks and sorry....

I was caught up with something and should have thought it out before I posted it

That is great..

I can be nice and I can be mean!!! lol

Thanks for sharing

t-sql

Hey.. I actually figured it out !!! lol!!

=sum(iif(Fields!xmark.Value ="X" or Fields!xmark.Value ="D", 1,0))

Thanks Adi...

WOW I feel dumb!!

so I got it workiung with

=Format(Fields!START_DATETIME.Value, "dd") +" " + WeekDayName ( WeekDay( Fields!START_DATETIME.Value ) )

but can i GET Fri instead of Friday?

and or on 2 lines like ...