hmm...just a thought, but...

not quite sure what...

ok...in which case the solution from rVadim will work for you.

for more info, suggest you...

Hi

will you only "ever" have columns A and B to pivot on?

whats supposed to happen if you have these records?

INSERT INTO #Site (site_id, location_id, [description])

VALUES ('06', '18a4', '18a4'),

('06', '18a5', '18a5'),

...

what are tables 1,2,3?

what are the...

SELECT(2 + 3) * 4;

SELECT 2 + (3 * 4);

SELECT 2 + 3 * 4;

at this juncture, it may be prudent to provide some further sample detail to fully describe the

possible permutations of the millions of records you have.

GSquared (8/8/2012)

---

If execs are looking for ad hoc reporting tools, it's hard to go wrong with pivot tables. PowerPivot and Excel have been mentioned already. I haven't used...

Luis Cazares (8/8/2012)

---

I used it on few projects, mostly for demos.

It's easy to learn and has a simple GUI.

Scripting is very similar to T-SQL and can be protected to prevent...

Luis Cazares (8/7/2012)

---

I'm not sure if there's a conflict of interests by posting the following but...

If you're looking for a nice tool that can be easy for the execs to...

USE [tempdb]

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[testmonths]') AND type in (N'U'))

DROP TABLE [dbo].[testmonths]

GO

CREATE TABLE [dbo].[testmonths](

[testMonth] [varchar](50) NULL

) ON [PRIMARY]

GO

INSERT INTO [dbo].[testmonths]([testMonth])

SELECT N'May-11' UNION ALL

SELECT N'May-12'...

what are the are datatypes of dbo.BVActions.orderedTime and dbo.BVActions.ScheduledTime

as an idea....is this anywhere close to what you are looking for?

SELECT MERCHANDISING_WEEK_START_DATE ,

DATEPART( WEEK , MERCHANDISING_WEEK_START_DATE ) - DATEPART( WEEK ,...

no offence...but 50 levels of grouping seems a lot...are you...