add to my script:

where syscolumns.id = object_id(N'dbo.PROC_AllEvents')

and you'll see sky with diamonds!

SPs are in that list too.

SELECT     *

FROM         syscolumns

INNER JOIN syscomments ON syscolumns.cdefault = syscomments.id

Try to comment everything in SP but this statement and run it.

Looks like you look at wrong point.

Are trying to create reporting tool out of single query?

Answer on your last question depends on:

where you going supply results to;

what kind of presentaton format you gonna use;

etc...

But actually SQL...

Replace

SUM ( Quantity * UnitPrice ) AS [TOTAL AMOUNT]

with

'====' + convert(varchar(25), SUM ( Quantity * UnitPrice ) ) + '====' AS [TOTAL AMOUNT]

OR

If you will convert to CHAR(8) yes, not more than 8 chars will be allowed. In case of less than 8 chars string will be filled with spaces up to...

Same way. Just don't forget to convert "Total Amount" to any of char types before concatenation.

select '====' + convert(varchar(255), [Total Amount]) + '===='

Use Varchar(255) or Varchar(8000) instead of Char(8) if you need.

The only point is to use same type of data in the column. '=======' is char (varchar) data, so you cannot use...

It's just silly mistake:

cast(od.Orderid as char(8))

or

convert(char(8), od.Orderid)