September 12, 2005 at 10:12 pm
Dear All,
I need to create a report based on sales data using the format below
1. Electronic 30
A. Television 10
B. Refrigerator 20
2. Food 10
A. Soft Drink 10
a. Coca Cola 5
b. Pepsi 5
Any idea how to add a bullet and numbering?
September 13, 2005 at 1:27 am
Well to number your list u can use RowNumber & RunningValue Functions as shown in this forum:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=212522
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=213425
September 13, 2005 at 1:42 am
Great, I just don't get it. Why this function placed under Aggregate function . I guess I can also use this function in case I want to format the number using A, B, C etc --> A = Chr (RowNumber () + 56)
Thanks a lot
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply