that fixes the syntax but it displays 0s for every row - even those where the measure that is tested is set to 1...

DISTINCTCOUNT( {CASE WHEN [Measures].[Alerts Completed] = 1...

you are right - thanks. let me see if that fixes ikt

figured it out - this will get error to show:

RAISERROR ( 'ERROR: boo',

...

i can get the BCP to create the export - thanks. I also created a format file but am not clear on how to specify the output to '|'...

thanks.

Thanks - that is a lot easier than the direction i was headed: what about first day of last month?

I had this:

CONVERT(VARCHAR, MONTH(DATEADD(mm, -1, GETDATE()))) + '/01/'...