Database

SELECT 
    'TotalValue' AS Sum_Total_Values_By_City, [London], [Tehran], [Paris]
FROM
  (SELECT City, Value 
   FROM MyTable) AS SourceTable
   PIVOT
   (
     SUM(Value)
     FOR City IN ([London], [Tehran], [Paris])
   ) AS PivotTable

Alex Lush wrote:

Any help or pointers on where to start looking greatly apreciated.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

SELECT order_no, order_line_no, line_type, product, long_description + ' ' + (SELECT B.long_description FROM Table1 B WHERE B.line_type = 'C' AND A.order_no = B.order_no AND A.product = B.product) AS long_description
FROM Table1 A
WHERE line_type = 'P'

create table #t2
(
    order_no          varchar(255),
    order_line_no     int,
    long_description  varchar(8000),
    done              bit
)

Insert	Into #t2 (order_no, order_line_no, long_description, done)
Select  order_no, 
        order_line_no, 
        long_description,
        0
From    #t1
Where   line_type = 'p'

Declare @i int
Set @i = 1

While (Select count(*) From #t2 where Done = 0) > 1
Begin

    Update  t2
    Set     t2.long_description = t2.long_description + ' ' + t1.long_description
    From    #t1 t1
    inner join
            #t2 t2
    On      t1.order_no = t2.order_no
    And     t1.order_line_no = t2.order_line_no + @i
    And     t1.line_type <> 'P'
    And     t2.done = 0
    
    
    Update  t2
    Set     t2.done = 1
    From    #t1 t1
    inner join
            #t2 t2
    On      t1.order_no = t2.order_no
    And     t1.order_line_no = t2.order_line_no + @i
    And     t1.line_type = 'P'

Set @i = @i + 1

End

Dim SQL As String = "Insert into Receipts (ReceiptDate,ReceiptTotal) values (:0, :1)"

BEGIN TRANSACTION

CREATE TABLE Test (Id BIGINT)
INSERT INTO Test (Id) VALUES (1)

ROLLBACK

SELECT * 
  FROM information_schema.tables
WHERE TABLE_NAME = 'Test'

Danzy83 wrote:

However, the tables created within the transaction are not dropped from the database. This is unusual to me.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]