Replace all that with

SELECT FORMAT(GETDATE(),'yyyyMMddhhmmss')

Hi Brian,

I just tried that, but the file is still showing corrupted when viewed in OWA.

Its not am email client issue. I see the same corruption when sent to Gmail and viewing the attachment in Google docs. I also see the corruption if downloading the...

Thanks Sue, I have already upped the attachment size to 10MB as some of my files are 4-5MB and I got the size error message at first. Its not related...

After a little more noodling around, I think I refined (by trial and error more than skill) Brian's regex and came up with this which works

-[\s\S]*?-[\s\S]*?(?=- [0-3][0-9]\/[0-3][0-9]\/[0-9]{4})|[\s\S]*?(?<=\n)[\s\S]*

Thanks Brian,

That regex is close.  It matches all the notes except the last one because it stops matching when it gets to the next date so the last note will...

Thanks John, appreciate the...

Scott.

That is the best example of double nesting Dynamic SQL with Output parameters I've seen even 9 years later.  Just what I've been struggling with.  Thank you.

If anyone is interested, I figured it out.

This will dynamically give me columns for every combination of Category with Cost and Quanitity

DECLARE @Columns NVARCHAR(MAX)
DECLARE @sql NVARCHAR(MAX);
SET @Columns...

Yes, I can totally do that, but I'm asking if it's possible to do it a single query.

My production query does a Dynamic Pivot using Dynamic SQL so I'd prefer...

Thanks Drew.

I'm still testing this against my full production data-set, but it looks good.  In fact, you solution appears far superior to mine as it handles overlapping groups and is...

Here's a script to create some sample data.

Here we have 19 orders made by 3 employees.

My script and any new script should only show Employee 3.  Employee 1 only made...

Part of the issue is that with multiserver administration you push out jobs, not maintenance plans. And then a job may execute a maintenance plan.  Nonetheless, I don't think...

Thanks guys.

I don't have a problem dynamically creating a back up location.  What I'm attempting to understand is how you then take that dynamic path and add it to a...

So why does Database Mail which we've established runs under a service account mapped to a SysAdmin SID fail to retrieve data from a User Table but not a Temp...