This sounds like the perfect use for a Calendar table. You can find an example here:  https://www.mssqltips.com/sqlservertip/4054/creating-a-date-dimension-or-calendar-table-in-sql-server/

Here is a quick example of using Out-GridView as a menu:

$Menu = [ordered]@{

1 = 'Do something'

2 = 'Do this instead'

3 = 'Do whatever you  want'

}

$Result = $Menu | Out-GridView -PassThru ...

It is hard to understand exactly what you want to do.

Is this going to be interactive or not?

If it is interactive then you could create a menu structure to be...

With this command you are not actually doing anything with it....which is why it sends the data back to SQL and the screen. Normally you would put this into a...

You best bet would be to check out Ola Hallengrens backup solution (https://ola.hallengren.com/). Check out the FQA section and he details how you can use the backup with SQL...

Personally, this article is more likely to make me trust the company.
They acknowledged the issue, laid out their findings on what happened, owned up to their shortcomings and...

I believe that the maintenance plans will actually run under the service account for the SQL Server Agent.

This account must have read/write access to the drive where...

I have an Amazon echo at home which is great. Easy to use for music, weather, etc,etc....

My wife is a carer for a woman who is paralysed from...

A final update.........

The original code was running for 10 hours and then failing with timeout issues. A MERGE statement was created and tested with a small set of data to...

Hi Scott,

Thanks for the explanation.....

I have been working through the MERGE command on a few websites trying to work out how it works....latest one being this one.

http://www.made2mentor.com/2013/05/writing-t-sql-merge-statements-the-right-way/

Thanks again.....

Unfortunately there is no column in i200 with that name, which is why I changed it...

Hello SSCrazy, I'd like to say thanks for the code.....I have been looking at it this morning and it is coming up with some errors in the OUTPUT section. These...

Hi Grant, thank you for your input. I have sent off an e-mail asking the supplier if they really need the COLLATE statements in there.

Do I need the MERGE statement...

We can change the code as long as we run it past the external company for testing. I am sure that they would be more than happy to have some...