Hi there

I have the following pivoting table that I manage to do and here's the result and I want to put a bit further.

**NTRITCode; NTRIId; Parameter; Usage; Rate**

CURRENT; 4; Peak; 100; 0.1
CURRENT; 4; NonPeak; 200; 0.2

PROPOSED; 6; Peak; 100; 0.2
PROPOSED; 6; NonPeak; 200; 0.3

PROPOSED; 8; Peak; 200; 0.3
PROPOSED; 8; NonPeak; 200; 0.5

As you can see there is 2 sets of proposed (ID=6 and 8). I want somehow display like this below so each set has a pair of CURRENT as well as the PROPOSED one as follow:

**Sequence; NTRITCode; NTRIId; Parameter; Usage; Rate**

1; CURRENT; 4; Peak; 100; 0.1
1; CURRENT; 4; NonPeak; 200; 0.2
1; PROPOSED; 6; Peak; 100; 0.2
1; PROPOSED; 6; NonPeak; 200; 0.3

2; CURRENT; 4; Peak; 100; 0.1
2; CURRENT; 4; NonPeak; 200; 0.2
2; PROPOSED; 8; Peak; 200; 0.3
2; PROPOSED; 8; NonPeak; 200; 0.5 

Again all I can think off is using combination of CURSOR and UNION but is there any TSQL that can do this?

Thanks