I think what you are describing is done by using "WITH ROLLUP"  in the group by or perhaps a grouping set

have a look at this article

https://www.databasejournal.com/features/mssql/using-the-rollup-cube-and-grouping-sets-operators.html

for each of your dates...

We do a lot of work in marketing for other companies, most have different seasonal requirements.

I'm told that we make every "poppy" for rememberance day in the UK, so october...

Hehe - until you...

ok - the issue is why is ((0)) matching %PGDb007%

have you checked both the file security  for the shared folder AND the share permissions.

i'm not saying this is best practice, but what I tend to do is set "everyone"...

you will get this forever - especially if you use temp tables.

my advice - scrap it and rebuild, you will spend less time doing that than the hours of bug...

you might find that after adding the index that you will get a new index suggestion afterwards

I often have to go through 3 rounds of execution plans to get all...

depending on what mean by "job log" you're going to have to get this from msdb database

dbo.sysjobhistory , maybe a few more tables, but I can't see a way to...

I'd be tempted to say the measurement includes spooling to tempdb and either sorting or joining

if you have to sort/join without decent indexes then that would cause a lot of...

a slightly easier way could be using row_number over order by

for example, to get the first item in sysobjects by type (first table, first proc etc)

select x.* from (

select name,...

Number isn't a data type

use decimal and specify the precision and scale

https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-2017

are you using a fully qualified UNC path? such as

\\server\folder1\file1

or a local path

H:\file1

I've had issues with local paths and now everything is UNC for me

if your scaled out DB has just replicated a delete without a where clause then you are just as stuffed as if the scaled out cluster went...

• This reply was modified 6 years, 8 months ago by MVDBA (Mike Vessey).

sorry, that proc is huge and references views which have functions etc...

that was the first thing I tried