Hi....seems interesting...but really haven't the time right now to test it for you....any reason why you...

Japster (4/2/2014)

What I want is

SerialBox SerialNo1 SerialNo2 SerialNo3 SerialNo4 ...

article posted today

http://www.sqlservercentral.com/articles/T-SQL/107611/

this will work for your sample data.....but maybe there are other issues as well?

SELECT SVP,

SUM(Wk1) AS wk1,

SUM(Wk2) AS wk2,

SUM(Wk3) AS wk3,

SUM(Wk4) AS wk4,

SUM(Wk5) AS wk5,

Y,

Q

FROM KPI

GROUP BY SVP,Y,Q

ORDER BY SVP,Y,Q

this may help you on your way

http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

this may help you

http://www.connectsql.com/2010/11/sql-server-management-studio-generate.html

/*possible proof of concept when applied to wide tables*/

/*response to Jeff's comments

"Also, because you have to make a copy of both the INSERTED and DELETED logical trigger tables,

this could...

Hi Jeff.....really appreciate your comments.

my thoughts and response to your post below:

Just a couple of recommendations on this type of generic "field-level" trigger.

First, the PK, OldValue, and NewValue columns should...

the following may help you on your way

/*This provides code to create a trigger on any table to record changes in the data

the changes made are recorded in a single...

Eirikur Eiriksson (4/5/2014)

Lets do both with the same solution

😎

/* SAMPLE DATA */

SELECT

X.NUM

INTO...

some significant changes between these two editions.....which one is in use now?

maybe more helpful to all of us (including your goodself) , if you provide some set up scripts for tables and sample data and expected results......that way we can address...

this may get you started

IF NOT EXISTS (

SELECT *

FROM sys.objects

WHERE object_id = OBJECT_ID(N'[YOURTABLE]') AND type IN (N'U')

)

BEGIN

CREATE TABLE [YOURTABLE] ([num] [int] NOT NULL) ON [PRIMARY]

END

GO

just to be absolutely sure....you are running SQL 7 or SQL 2000....not a later version?

this may help you on your way....

USE [tempdb]

GO

-- reconfigured your original query...and removed the subeselects and aliases

-- hopefully you can follow structure

SELECT s_element.sendeplatz,

jingle.sztitle,

arolle.szname AS ptype,

aperson.szname AS pname,

publisher.szname AS pub,

jingle.lid AS...