I just want to make sure we get this right.  You're saying that you want to eliminate all book details for books that DO exist in the books table?

I just...

Phil's code works perfectly if you can guarantee that the OrderDate column does...

I have no quantitative numbers on what I'm about to say but... I've...

To get the Orders where the...

Also, check with the other Developers in the company.  You should be checking your code into some form of source control.  They should also have a "onboarding" process that lets...

Jeff, format date is not the issue.

If you are willing to waste your time, do it on the real problem, the variable is the issue.

DECLARE @todays AS VARCHAR(20) SELECT...

Hi, this is what I am trying to do,

DECLARE @todays AS VARCHAR(20) SELECT @todays = format(cast(getdate() as date),'yyyyMMdd')

EXEC xp_cmdshell 'copy C:\Test\@todays\ *.* C:\Newtest\';

But, I can figure out the syntax...

Thanks for your reply Phil, Someone suggested PIVOT would do this, so I was trying to figure out how to do that. While this would be the answer if...

Why not just create a stored procedure to produce the data and have Excel pull the data on demand?  That way, you don't end up creating files for a bazillion...

It was a suggestion based on previous experience that was meant to prompt you into checking for them.  That worked. ...

• This reply was modified 3 years, 7 months ago by Jeff Moden.

Awesome news about the Substring parameters.  And, I've not run it but it looks like your @SmearStart will likely do the trick.

All of that and your previous column additions means...

Have you taken a look at your execution plan since you've done that?

That's one of my biggest frustrations with Microsoft.

[quote-1...

Have a look at the following article to support such "Dynamic CrossTabs".  Use MAX() instead of SUM() like Scott Pletcher did.  With the understanding that I have little love for...

It's part of the windows operating system.  Just Google it.