I don't think the need the GROUP BY on the outer query, just a SUM() OVER(), so maybe this?:

SELECT

f.Country

,f.CompanyName

,f.InvoiceID

,f.SupplierCode

,f.InvoiceNumber

,f.[Scan Date]

,f.[Approval Date]

,f.[Days to Final Approval]

,f.[<7 Days]

,f.[>7 Days]

,SUM([>7 Days]) OVER(PARTITION BY f.Country...

You really do need a stored proc, given how complex the restore process could be, with a full backup, maybe differential, maybe log file(s).

I have a special user/utility db that...

Assuming you want to split first by a space, but if there's no space then by dash:

SELECT value, LEFT(value, ISNULL(NULLIF(CHARINDEX(' ', value), 0), CHARINDEX('-', value) - 1)) AS split_value

FROM (

...

If you:

1) always, or

2) almost always, or

3) most critically

search these tables using RECORD_TYPE_CD, as in this query, then you should cluster those tables first on RECORD_TYPE_CD. That...

If you:

1) always, or

2) almost always, or

3) most critically

search these tables using RECORD_TYPE_CD, as in this query, then you should cluster those tables first on RECORD_TYPE_CD. That...

Jeff Moden (7/1/2016)

---

ScottPletcher (7/1/2016)

---

I still say don't explicitly code it unless the code requires it (some system procs require unicode strings specifically, for example), because it can cause performance...

Jeff Moden (7/1/2016)

---

Agreed... and the catch here is that if this happens, what else could happen? If you use the "N" prefix for the literals whenever NVARCHAR is used,...

Sergiy (6/30/2016)

---

ScottPletcher (6/30/2016)

---

Jeff Moden (6/24/2016)

Shifting gears a bit and depending on how that's used, it could become a performance problem due to the implicit conversions of the string literals. ...

Jeff Moden (6/24/2016)

Shifting gears a bit and depending on how that's used, it could become a performance problem due to the implicit conversions of the string literals. Since @database2...

Jeff Moden (6/28/2016)

---

David92595 (6/28/2016)

---

@jeff

Because I inherited this database and the person that made it thought in spreadsheets not relational tables.

@scott

Thank you! Are their any other good ways to stop a...

David92595 (6/28/2016)

---

@jeff

Because I inherited this database and the person that made it thought in spreadsheets not relational tables.

@scott

Thank you! Are their any other good ways to stop a sql injection?...

As a quickie "solution", for now, something like this:

SET ANSI_NULLS ON;

SET QUOTED_IDENTIFIER ON;

GO

ALTER PROCEDURE <proc_name>

@ID int,

@State varchar(30),

@ColumnName varchar(100),

@NewValue datetime

AS

SET NOCOUNT ON;

IF @State LIKE '%[;]%' OR @ColumnName LIKE '%[;]%' OR @NewValue...

Or the object(s) could be in a schema that is not the default schema, since the q is written as:

DROP TABLE table1

rather than

DROP TABLE schema_name.table1

Almost certainly not the answer the...

Sorry if this overlaps already-posted code, was busy for a long while before I was able to get back to working on this:

SELECT string, CASE WHEN next_to_last_space = 0 THEN...

SELECT

T.CallQueue, T.ReportQueue, T.ServiceLevel,

CASE WHEN T.ServiceLevel = T.Threshold1 THEN C.Segment1

WHEN T.ServiceLevel = T.Threshold2...