Thanks. I think i got it working! Thanks to  your help!

Or do I misunderstand... when you mean the bottom part of the query?

Thanks for your reply!

I do not really understand your result as it seems totally different, with new fields and all. I know how to do a normal basic UNION but...

OMG! Got  it working i think!

I tried the same earlier and it did not work! Do not know what i did wrong!

SELECT
Names.productName
,NameProperty.Value
,NameProperty.Property
FROM Names
LEFT OUTER JOIN NameProperty
ON Names.productName...

By the way, I tried that but it is not working :

SELECT
Names.productName
,NameProperty.Value
,NameProperty.Property
FROM Names
RIGHT OUTER JOIN NameProperty
ON Names.productName = NameProperty.productName
GROUP BY Names.productName
,NameProperty.Property
,NameProperty.Value

Hi Guys!

I start the WITH statement without the  semi column ;  then I will test also starting with the semi column.

I had to rewrite all of it and now it...

Hi Phil!

Thanks for your answer! I like the "as far as I know"... and I am sure you know a lot more than me 🙂

I think I am not on...

I got it working doing something like that.

RESTORE DATABASE OSTraining_98 --This is the destination name of the DB

FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\RodierTrainingFood.bak'

WITH MOVE 'OS_Trainer' TO 'C:\Program Files\Microsoft SQL...

Thank you all for your feedback. Like always. Best community ever. I will close this ticket as it is confirming my own opinion. Have a good day.

Thanks John for your help.

You pointed at me something I should have mentionned in my first post. Sorry : "That's a business decision, not a technical one"

We are OK to...

Dear all,

Thanks for your help and time. It is appreciated.

I am a bit lost still as my logs are backed up daily but they keep on increasing. I was reading...

Thanks again Crow!

I had to offline the DB and put it back online and then I did what you said. It worked!

Do you have a script that would backup all...

Hello Crow1969,

Thanks for taking time to answer me. It is really appreciated. Moreover, I think that you found my issue. I did what you told me and in fact, at...

spot on John.

I gave acces read/write to everybody on this folder and the script is now working. The original one.

So, do you know how to give access to the SQLAgent...

John, it is still not working when I replace my line with your line.

SET @fileName = '"' + @path + @name + '_' + @fileDate + '.BAK"'

PS:...