Thanks again Grant,

I will see if it works for me...

I see now I did not make my question as clear as I should.

In the WHERE clause, I  want to be able to have the user toggle between

            
September 23, 2021 at 12:16 pm
            
#3932170

            
            
                                                
        

Thanks for all of your collective help.

I have enough input to work with now.

Regards,

Ah, I see

I had hoped I could use it in an SQL Script...

Thanks, Michael,

The query works fine, and it shows my list of Stored Procedures.

It does not seem to 'execute' this Query as a part of my script though.

What am I missing?

Thanks...

mmm, not what U hoped for, but it is a clear answer, though.

Thanks for your help, Grant

Good read. Thanks!

It's working  now!

I got this message:

(2 rows affected)
RESTORE command being run follows below:
RESTORE DATABASE [010] FROM DISK = 'D:\EOLBackup.BAK' WITH RECOVERY, FILE = 1, STATS = 05,...

Thanks for helping also.

I get these messages when running the script.

Msg 213, Level 16, State 7, Line 1
Column name or number of supplied values does not match...

Thanks again for your help Scott.

I get this returned:

(2 rows affected)
RESTORE command being run follows below:
RESTORE DATABASE [010] FROM DISK = 'D:\EOLBackup.BAK' WITH RECOVERY, FILE = 1,...

This works:

RESTORE DATABASE [010] 
FROM  DISK = N'D:\EOLBackup.bak' 
WITH  FILE = 1,  
MOVE N'EOLBackup_{7b720fb4-e0b8-4476-a97f-fcb8cf291344}'     TO N'C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\010.mdf', ...

Thanks for your help Scott, but to "adjust this as needed" is going way over my head.

I am sure this is what I need, but I am not able to...

It's very clear and good to understand for me.

So I now have a solution, AND the explanation of it.

Thanks again for your effort.

Arnold

Thanks very much for your solution Jacob...

This works perfectly !

Unfortunately I haven't got a clue how this works.

Do you mind explaining it a bit? Just to understand what you...

Thanks for your help Alvin,

That works okay.

One more thing. My query is about 140 lines long.

Is there a way to do the If Then on one select column only and/or...