Running Totals

I am dealing with issues on my SQL Server 2022 instance related to collation. I have an instance collation of Latin1_General_CS_AS_KS_WS, but a database collation of Latin1_General_CI_AS. I want to force a few queries to run with a specified collation by using code like this:

DECLARE @c VARCHAR(20) = 'Latin1_General_CI_AS'

SELECT  p.PersonType,
        p.Title,
        p.LastName,
        c.CustomerID,
        c.AccountNumber
 FROM Person.Person AS p
 INNER JOIN Sales.Customer AS c
 ON c.PersonID = p.BusinessEntityID
 COLLATE @c

Will this solve my problem?

See possible answers

Running Totals

Running Total Performance

Blogs

SQL Server 2025 GAs Today

Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe

The Roundup for T-SQL Tuesday #192

Forums

Best way to log Data Flow errors in SSIS 2005?

Advanced Excel Mastery for Finance, Accounting & Payroll – 2025 Edition

2025 Form 1099 Reporting Requirements: Essential 1099 NEC Updates

Question of the Day

Specifying the Collation