It sounds to me that you're making backups to the same file all the time and the backup sets are stacking up in the same file.  Either assign different...

There is a problem here that needs to be addressed.  The code you have for the end of the month will return the last day of the month - at...

I think I would start here:

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-executesql-transact-sql?view=sql-server-ver15

There is no need to concatenate the variables into your code.  That is SQL Injection at it's finest.  Use the variables as parameters.

Also,...

You need to pass something to export-cdv

$matched_itrms | Export-Csv ...

You are welcome, thank you for the feedback

I completely missed the different years - so change the where clause to:

WHERE Balance > 0
OR (last_modified_date >= '20210401' AND last_modified_date < '20220401')

So if the item has...

Yes, case is important.  You can use -ilike I think.

How about:

SELECT  A , B , C ...

From Table_A

WHERE ( last_modified_date  between '01/04/2021 00:00:00' and  '31/03/2022 23:59:59' ) 
OR ( balance  > 0 and last_modified_date  NOT...

• This reply was modified 3 years, 6 months ago by Jeffrey Williams.

So you are actually looking in each file for matching strings in the contents of the file.  Okay - the same general principle applies....

1. Create a list of folders to...

Definitely not for the first one.  Bump that up to at least 40:

EXEC...

• This reply was modified 3 years, 6 months ago by Jeffrey Williams.

Which will not work for an AOAG unfortunately.  To add a database to an...

For multiple servers\locations - define those in a separate file.  Then - get the contents of that file and loop...

$match_array = @("failed","error");
$fileLocations = Get-Content "\\somelocation\somewhere\ListOfFolders.txt"
$fileLocations | %...

Use s CTE or derived table

The LAG function can be simplified - no need to use ISNULL if you use the following:

     , Numdays  = DATEDIFF(dd, LAG(d.[End],...

...

SELECT SUBSTRING(V.YourString,CI4.CI+1, CI5.CI - CI4.CI - 1)
FROM (VALUES('Data:A:B:C:20:0:0'))V(YourString)
     CROSS APPLY (VALUES(CHARINDEX(':',V.YourString)))CI1(CI)
     CROSS APPLY (VALUES(CHARINDEX(':',V.YourString,CI1.CI+1)))CI2(CI)
  ...