That's not a pivot.

Easiest way to do what you are describing is to use Reporting Services and add a Grouping level to your table.

Is there a reason you can't just post the SQL in the body of your message? Sending people to your attachment is a good way to get no answers.

Is there a reason you are using a VARCHAR instead of a numeric type? If you used INT or some other numeric type, this would be pretty easy.

Can you post some dummy data so we can see what your data looks like? Are you importing this from somewhere or entering it manually? The reason I...

Struggling to write a Iif or Switch statement in the expression for the following:

If the cell value is "Y" then nothing

If TODAY() is 10 day or less prior to SV3...

You need CHARINDEX() to find the position of the second dash (if it exists).

This almost works:

use tempdb;

go

SELECT OrderNo

, CHARINDEX('-',OrderNo,4) AS FindDash

, LEFT(OrderNo,CHARINDEX('-',OrderNo,4)) AS NoSuffix

FROM (

SELECT 'SO-123456' AS OrderNo

UNION ALL

SELECT 'SO-123456-01'

UNION...

If you can avoid using UNION, I probably would. (Maybe SQL Server acts different than it's stepbrother Access, where union query performance was appalling, but I don't know.)

Are you querying...

What options did you choose when you installed SSRS? "Install but do not configure"? If you did a default install, the install script should have created a ReportServer database....

How about...

SELECT ClientID

--,MAX(ServiceDate) AS LastSvcDate

FROM #Services

GROUP BY ClientID

HAVING MAX(ServiceDate)<DATEADD(d,-80,GETDATE());

Then just join that back to the Client table to get the client info...

Either mail merge to Word and create mailing labels or create a report in SSRS and do the same thing.

Getting warmer, but it seems you should read this before posting:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

I'm not trying to be difficult, but it's really hard to recreate something like your situation without it. Could...

if the date in 'field B' is less then TODAY() then format the 'field B' as Background Color Red and Font color White,

if the date in 'field B' is equal...

Are you using AdventureWorks as your model? Or if not, please post T-SQL to create tables and add some sample data and expected results. Apologies if I'm slow,...

join to a table-valued function using CROSS APPLY?

Sounds like you're doing what i used to do - summarizing unnormalized healthcare/oncology data. If you can either normalize your underlying tables or create a stored procedure or view...