Darn angle bracket filters! (blankety-blank!)

Hope...

One thing that I should add, If you pay for an estimate or an assesment, then it is yours, not theirs. You can do what you want with it,...

I agree with Steve and Doug on this: A customer does not have to pay for anything that they have not explicitly agreed to pay for ahead of time.

I feel bad for the OP, but we can't really do much for them until they can post something that we can see. Maybe an attachment?

Glad I could help. Let us know how it works out.

Yeah, it's definitely going to the wrong directory.

FYI, it is ALWAYS possible to construct a mathematical expression that will fit ANY finite set of numbers. for instance:

WHERE (month(dob)-2) * (month(dob)-6) * (month(dob)-7) * (month(dob)-8) *...

You should try the query that I posted, it is highly parallel also.

If you need a working version of Jeff's query, here is one that I modified but is only...

Anybody leave part of this cow for me?

This seems to me to be the most obvious approach, though perhaps not the fastest (when I needed this kind of query to...

I agree with Matt. You cannot do expressions in an EXEC statement.

As a general rule only [font="System"]Select[/font] and the major DML statements can have actual scalar expressions. The...

Hey Art, as long as you are here, ...

I notice that you post a lot of code on the forums, which is great, however, it would help some of...

The...

Try executing:

SET QUOTED_IDENTIFIER ON

GO

first.

Apparently, the author assumed this setting was already on, though it is not normally on and a bad practice in any event, IMHO.

Actually, upon further reflection, it seems likely that you need to add your backup directory name to the DIRectory command:

Insert into #BakDir exec xp_cmdshell 'dir D:\BKUP\Demo /B'

declare @file varchar(max)

Select @File...

Add the print statements and tell us what they say:

Insert into #BakDir exec xp_cmdshell 'dir /B'

declare @file varchar(max)

Select @File = FileName from #BakDir

Print 'Restoring from file:'

Print @file

Print '--======'

RESTORE DATABASE [Demo]...