Hello,

Well it's priced far less than many textbooks universities use:) If $ is really a problem I'll...

RAC is at your service for splitting delimited strings. For example:

create...

Again using RAC:

Exec Rac

@transform='Max(Signal) as Signal & Max(Detect) as Detect & Max(PValue) as PValue',

@rows='Common_ID',

@pvtcol='EAID',

@from='output_info',

@row_totals='n',@grand_totals='n',@rowbreak='n',

@rotate='nest',

@racheck='y',@shell='n'

Common_ID Signal_22 Detect_22 PValue_22 Signal_23 Detect_23 PValue_23

--------- --------- --------- --------- --------- --------- ---------

1 ...

psmg01 (12/17/2008)

---

Hi Jeff,

I have a table that has the following values.

col1 | col2 | col3 | col4

1 | val1| val2 | val3

2 ...

Steve Jones - Editor (12/16/2008)

---

Derek,

Interesting and a nice argument.

However I'd argue that we need lots of checks in there. It can be the tools adding them, but we are more...

Jeff Moden (12/6/2008)

---

Very cool... 2 seconds huh? That was going to be my next question. What kind of hardware are you running? I'm running a 6 year...

Nice job and write up Jeff. For what it's worth, here's your sample data using RAC 🙂

http://beyondsql.blogspot.com/2008/12/sql-server-dynamic-crosstabs-by-jeff.html

best,

steve

www.beyondsql.blogspot.com

Jeff Moden (12/4/2008)

---

rog pike (12/4/2008)

---

Exec Rac

@transform='(Room) as Room',

@rows='[Floor]',

@pvtcol='Room',

@from='Rooms',

@defaults1='y',@rank='Room',@racheck='y',@shell='n'

Floor Room1 Room2 Room3 Room4 Room5 Room6

------- ----- ----- ----- ----- ----- -----

Floor 1 101 102 103...

Since you're getting flack you can try RAC 🙂

The RAC utility will let you do want you want very easily. For example:

create table Rooms (Room int primary key, State varchar(20),...

Hello Steve,

I agree with you that while excitment sells it doesn't necessary mean progress. And not everyone wants to blow the same whistle and reach for the newest brass ring....

rog pike (11/12/2008)

---

An array is a 'type', something the archaic computer science of sql knows nothing about. You have to move to a 'real' relational system to find a list/array...

An array is a 'type', something the archaic computer science of sql knows nothing about. You have to move to a 'real' relational system to find a list/array type. You'll...

You seem to have a case of PMS, pivot madness syndrome. You should check out the RAC utility where the madness (code) is eliminated and you can easily solve your...

simon phoenix (9/2/2008)

---

Hi

Jeff

In order to trap the first and last record of each sequence , the scenario we had was based on max(id) and min(id), now if there those...

Jeff Moden (8/30/2008)

---

--===== Show first and last PRD and date of each SetSequence

SELECT yt.SetSequence,

MAX(CASE WHEN d.MinID = yt.ID THEN PRD END)...