Creat a Pivot Table with several options

Create a pivot Table similiar to Microsoft Access Pivot Command, Specify if there should be totals at the bottom, right or both..Uses a temporary table to hold the values..Bad part is the SQL that is generated can have no more than 4000 Characters..If not using any NVARCHAR characters, could make the sql up to 8000 […]

2002-11-18

1,993 reads

Blogs

Daily Coping 3 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – December 2020 – Participate in the Advent of Code.

By

Christmas. Depending on where you live it’s a big deal even if you aren’t...

[Video] Azure SQL Database – Import a Database

By

Quick Video showing you have to use a BACPAC to “import” a database into...

Read the latest Blogs

Forums

How can I exclude records from this table?

By NineIron

How do I exclude the "Appointments" that are not adjacent to a "Discharge"? This...

Disable Package Expression

By DinoRS

Hi SSC, I've got 2 Project Variables which I use to control wether a...

Inflow / outflow report per day

By milo1981

Hello, I have two simple tables: Invoices InvoiceID Date Value and PaymentsReceived PaymentID Date...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers