Not sure I understand.  Does this help?  You'd have to add a where clause looking for your query text in the "text" column.

John

Is it because of your attempt to concatenate the $PSScriptRoot variable with the rest of the file path?  Perhaps you need to enclose the file path part in quotes, and maybe...

Ant

Try this.  It can probably be simplified and/or prettified, but it's a start.  And it seems to return the correct results. The Apportion and Nominal columns don't appear...

Gaurav

Better to start a new topic for a new question.  But I don't advise you to constantly change the job once it's set up.  You should alter your...

Then use your favourite scripting language to search the CSV file for "0,00" and replace it with "0".  Better still, explain to the user that he's wrong to want his...

I often wish that SELECT INTO didn't exist, because I find it's often abused.  You've nailed it, though - create the table once and then it's always there for you,...

Please don't do this.  If your 0 is accurate to two decimal places, you should show 0.00 instead of 0.  Otherwise, how do you know it's not 0.04 or 0.3...

INSERT INTO @FillistOnlyTable 
RESTORE FILELISTONLY 
FROM DISK = 'D:\BBBACKUP_2017\RC\FEBRUAR\easyplan-drift-170216-after.bak'

John

Have you tried renaming the old database before you do the restore?  Then you don't need to rename the new database, and if this problem is being caused by the...

OK, so your rowmodctr isn't anywhere near the threshold at which it updated last time.  How many rows are there in your table?

Leaving all that aside, you'll still...

Having sa own all databases isn't a good security practice.  Have a look at this article.  We go with number 5 in the Possibilities section here.  Adi is...