Wood Columns
Posted in Garden Antiques on 07/28/2010 10:17 am by adminSQL: How do you comma-separate values from multiple columns in groups according to another column.?
For example, if you visit http://www.sql-tutorial.com/sql-aggregate-functions-sql-tutorial/ and look at the first table they have displayed, and only using the OrderPrice and CustomerName columns, how would a SELECT statement look in order to produce the following result:
Smith 160,420
Johnson 190
Baldwin 500,2000
Wood 1000
Oracle and MySQL have functions that will allow this, but with MS-SQL 2005 you need to be creative. Monkeying with output from one of the XML functions, you can get results with something like:
SELECT CustomerName,
left(stuff((SELECT ', ' + OrderPrice
FROM Orders Z2
WHERE Z2.CustomerName = Z1.CustomerName
ORDER BY OrderID
FOR XML PATH('')), 1, 1, ''), 56) [Order Prices]
from dbo.Orders Z1
group by CustomerName
Unless your order price is a string, you'll need to do a CAST and perhaps a xTRIM on it to a character type.
There are also several examples of CLR code out on the Internet that will be bit more efficient and certainly easier to use. In short, they make a user aggregate function that mimics the Oracle and MySQL function--sadly all examples I've seen have problems with NULL values and having an embedded function (such as ISNULL or COALESCE) within.
 |
 Antique carved mahoganny columns archway and door surrounds $6,500.00 Time Remaining: 46m Buy It Now for only: $6,500.00 |
 oversized tapered birch wood interior residential floor to ceiling columns $1,050.00 Time Remaining: 1h 48m |
 late 19th century varnished oak wood columns with ionic capitals $1,050.00 Time Remaining: 1h 48m |
 residential varnished oak wood fluted columns with ionic capitals $1,050.00 Time Remaining: 1h 48m |
 Set of Six Porch Columns 104 Turn of the Century Home $1,500.00 Time Remaining: 16h 6m Buy It Now for only: $1,500.00 |
 Vtg Antique Lot Of Five Wooden Spindled Baluster Porch Columns Railings Post $249.99 Time Remaining: 19h 18m Buy It Now for only: $249.99 |
 2 Vintage Wood Pillars Columns $199.99 Time Remaining: 1d 23h 21m Buy It Now for only: $199.99 |
 Pair of antique French turned oak columns Ideal interior design $39.36 Time Remaining: 2d 27m |
 Pair of antique French turned oak columns Ideal interior design $39.36 Time Remaining: 2d 27m |
 Home Theater Columns $500.00 Time Remaining: 2d 2h 3m |
 Pair of 18th Century Italian Gilded Columns From Gothic Altar $450.00 Time Remaining: 2d 6h 20m |
 3 antique french walnut wood columns $14.00 (1 Bid) Time Remaining: 2d 6h 52m |
 pr VICTORIAN gingerbread porch column CORBEL brackets gray PAINT 10 x 6 x 15 $45.00 Time Remaining: 2d 8h 4m Buy It Now for only: $45.00 |
 Antique Satin Wood Teak Columns India c1900 30436 $3,800.00 Time Remaining: 3d 4h 52m Buy It Now for only: $3,800.00 |
 ANTIQUE BUILDING COLUMNS WOOD POST THREE $299.00 Time Remaining: 3d 7h Buy It Now for only: $299.00 |
 Mahogany Columns with carved capitals 9 Feet Tall $1,450.00 Time Remaining: 3d 9h 42m Buy It Now for only: $1,450.00 |
 Lot of 50 Antique Oak Architectural Corinthian Columns out of 60+ year storage $10,000.00 Time Remaining: 3d 12h 54m Buy It Now for only: $10,000.00 |
 4 WOOD COLUMNSANTIQUE STRUCTUAL PORCH COLUMNS9 4 TALL 112 14 BASE $0.99 (1 Bid) Time Remaining: 3d 19h 30m |
 Pair of Grand Fluted Wood Columns $4,950.00 Time Remaining: 4d 1h 53m Buy It Now for only: $4,950.00 |
 EARLY 1900s 2 ANTIQUE MATCHED PAIR TAPERED 9 HOUSE HOME ARCHITECTURAL COLUMNS $995.00 Time Remaining: 4d 3h 29m Buy It Now for only: $1,295.00 |
 Antique Solid Wood Columns $1,800.00 Time Remaining: 4d 7h 3m Buy It Now for only: $1,800.00 |
 The BEST OLD ARCHITECTURAL FLUTED COLUMN 6 1 2 Tall Awesome Details 1 of 2 $128.49 (2 Bids) Time Remaining: 4d 7h 47m |
 OMG OLD ARCHITECTURAL SQUARE FLUTED COLUMN 6 1 2 ORNATE White Details 2 of 2 $25.00 Time Remaining: 4d 7h 57m |
 LARGE PAIR OF ITALIAN CARVED 19TH CENTURY WOOD COLUMNS $4,999.99 Time Remaining: 4d 14h 29m Buy It Now for only: $4,999.99 |
 2 wood decorative architectural columns $150.00 Time Remaining: 4d 23h 55m |
 Authentic Antique Primitive Neo Classic Design Garden Accent Column $575.00 Time Remaining: 5d 4h 45m |
 ANTIQUE BUILDING COLUMNS WOOD POST TWO $99.00 Time Remaining: 5d 5h 58m |
 An Impressive Pair of Indian Carved Teak Wood Columns $899.00 Time Remaining: 5d 13h 46m Buy It Now for only: $999.00 |
 ANTIQUE WOOD FIREPLACE MANTEL W TAPERED COLUMNS SPIDERWEB MOTIF $1,250.00 Time Remaining: 5d 23h 41m Buy It Now for only: $1,250.00 |
 victorian era solid varnished oak wood interior residential columns $1,250.00 Time Remaining: 6d 1h 44m |
 varnished white oak wood residential room divider columns $950.00 Time Remaining: 6d 1h 44m |
 varnished oak wood residential fluted columns with largely intact capitals $1,500.00 Time Remaining: 6d 1h 44m |
 varnished oak wood room divider columns with ornamental capitals $950.00 Time Remaining: 6d 1h 47m |
 late 19th century interior residential varnished oak wood tapered columns $695.00 Time Remaining: 6d 2h 2m |
 ANTIQUE OAK FIREPLACE MANTEL WITH MIRROR COLUMNS $799.00 Time Remaining: 6d 8h 46m Buy It Now for only: $799.00 |
 11 mahogany victorian porch spindle baluster turned column 24 30L x 175 $85.00 Time Remaining: 6d 19h 2m Buy It Now for only: $85.00 |
 15 PAINTED victorian STAIR spindle baluster turned column 275L x 175 $95.00 Time Remaining: 6d 19h 5m Buy It Now for only: $95.00 |
 11 OAK varnished victorian STAIR spindle baluster turned column 22L x 175 $85.00 Time Remaining: 6d 19h 7m Buy It Now for only: $85.00 |
 ARCHITECTURAL 2 PILLARS Antique Wood COLUMNS PEDESTALS $1,600.00 Time Remaining: 7d 22h 4m Buy It Now for only: $1,600.00 |
 Victorian mantle with mirror and fluted columns $850.00 Time Remaining: 9d 15m Buy It Now for only: $850.00 |
 Ornate Salvaged Architectural Wood Porch Column Large Victorian Exterior Post $235.60 Time Remaining: 9d 2h 52m Buy It Now for only: $235.60 |
 Ornate Salvaged Architectural Wood Porch Column Large Victorian Exterior Post $153.56 Time Remaining: 9d 3h 13m Buy It Now for only: $153.56 |
 Architectural Salvage Wood Porch Column Large Arts Crafts Exterior Fluted Post $235.60 Time Remaining: 9d 22h 24m Buy It Now for only: $235.60 |
 Vintage Salvaged White Mantel w Columns Architectural $825.00 Time Remaining: 10d 34m Buy It Now for only: $825.00 |
 Architectural Salvage Wood Porch Column Simple 75 Foot Exterior Post Capital $173.56 Time Remaining: 10d 54m Buy It Now for only: $173.56 |
 Salvaged Architecture Wood Porch Column Antique 9 Foot Exterior Post Capital $235.60 Time Remaining: 10d 1h 6m Buy It Now for only: $235.60 |
 Salvaged Architecture Wood Porch Column Antique 55 Foot Exterior Post Capital $183.56 Time Remaining: 10d 1h 38m Buy It Now for only: $183.56 |
 Wood Porch Column Salvaged Architecture Hollow Victorian Exterior Fluted Post $153.56 Time Remaining: 10d 1h 48m Buy It Now for only: $153.56 |
 75 Wood Porch Column Salvaged Architecture Exterior Structural Post Antique $183.56 Time Remaining: 10d 2h 22m Buy It Now for only: $183.56 |
 Victorian wood Column turned Post porch Vintage $135.00 Time Remaining: 10d 4h 54m Buy It Now for only: $135.00 |
 Vintage Solid Wood Column 84x9 Great for Art decor $150.00 Time Remaining: 11d 3h 40m Buy It Now for only: $150.00 |
 Antique Balinese Set of 4 Honey Teak Columns From Bali $3,786.00 Time Remaining: 11d 3h 58m Buy It Now for only: $3,786.00 |
 Pair of American Antique Oak Columns 2 Circa 1900 1910 78 height $385.00 Time Remaining: 11d 4h 14m Buy It Now for only: $385.00 |
 Vintage INDONESIAN Wood Pillars COLUMNS Posts HAND CARVED Teak BALINESE Pair $3,998.00 Time Remaining: 11d 22h 9m Buy It Now for only: $3,998.00 |
 Salvaged Fir Wood Mini Columns Smaller Wooden Posts Antique Architecture $150.00 Time Remaining: 11d 23h 59m Buy It Now for only: $150.00 |
 c1830 LARGE doric column capital blocks 36 sq x 5 $425.00 Time Remaining: 12d 7h 33m Buy It Now for only: $425.00 |
 c1900 set of FOUR tapered DORIC porch columns 99 tall $750.00 Time Remaining: 12d 7h 33m Buy It Now for only: $750.00 |
 13L ROOM divider DENTIL pediment FLUTED columns 1 4OAK $1,850.00 Time Remaining: 12d 7h 56m Buy It Now for only: $1,850.00 |
 PR fluted tapered DORIC porch columns CAPITALS w steel plinth bases 8 9 tall $475.00 Time Remaining: 12d 7h 56m Buy It Now for only: $475.00 |
 OAK room divider OCTAGONAL columns w STAR motif dentil pediment PILASTERS 9L8H $2,250.00 Time Remaining: 12d 7h 56m Buy It Now for only: $2,250.00 |
 PAIR circa 1890 SOLID wood TAPERED round PORCH columns capitals bases 103h $395.00 Time Remaining: 12d 8h 11m Buy It Now for only: $395.00 |
 Set of 5 1890 SOLID wood TAPERED round PORCH columns 885 h x 8 dia $850.00 Time Remaining: 12d 8h 11m Buy It Now for only: $850.00 |
 3 salvaged pieces 2 thick boards ORIGINALLY porch columns supports 30 15 x13 $85.00 Time Remaining: 12d 8h 11m Buy It Now for only: $85.00 |
 c1830 pr 13 greek revival IONIC tapered fluted columns WOOD 16 to 22 diameter $5,600.00 Time Remaining: 12d 8h 25m Buy It Now for only: $5,600.00 |
 PAIR oak columns w FANCY gesso capitals SET for a colonnade room divider 64h $495.00 Time Remaining: 12d 8h 25m Buy It Now for only: $495.00 |
 c1900 set of FOUR tapered DORIC porch columns 92 tall $750.00 Time Remaining: 12d 8h 25m Buy It Now for only: $750.00 |
 c1900 Square BOXED PINE columns 86 tall x 8 sq $150.00 Time Remaining: 12d 8h 25m Buy It Now for only: $150.00 |
 ANTIQUE VENETIAN PALACE Wood Carved Door Entry WayMARBLE BASE Corinthian Column $4,699.99 Time Remaining: 12d 22h 27m Buy It Now for only: $4,699.99 |
 7 nicely turned wood column $200.00 Time Remaining: 13d 1h 10m Buy It Now for only: $200.00 |
 Antique Chippy White Paint Salvaged Column Piece Architectural Wood E261 $45.00 Time Remaining: 13d 2h 57m Buy It Now for only: $45.00 |
 Antique Victorian Pine Wood Porch COLUMN Front Porch POST Beam Simple White $183.56 Time Remaining: 15d 19m Buy It Now for only: $183.56 |
 Antique Victorian Pine Wood Porch COLUMN Front Porch POST Beam Simple White $153.56 Time Remaining: 15d 21m Buy It Now for only: $153.56 |
 Victorian Turned Wood Column Lamp Archetictural Salvage 5467 $89.00 Time Remaining: 15d 6h 34m Buy It Now for only: $89.00 |
 Set of 4 Porch Columns Fluted 82 Tall 12 Diameter $499.99 Time Remaining: 15d 20h 48m Buy It Now for only: $499.99 |
 4 c1830 10 greek revival IONIC tapered fluted columns WOOD 13 16 diameter $7,800.00 Time Remaining: 17d 4h 20m Buy It Now for only: $7,800.00 |
 Antique Turned Wooden Porch Column s 4 available $175.00 Time Remaining: 17d 19h 11m Buy It Now for only: $175.00 |
 Victorian Turned Wood Column Lamp Archetictural Salvage $95.00 Time Remaining: 17d 20h 42m Buy It Now for only: $95.00 |
 Victorian Turned Wood Column Lamp Archetictural Salvage $95.00 Time Remaining: 17d 20h 46m Buy It Now for only: $95.00 |
 Antique Carved Wood and Terra Cotta Columns $575.00 Time Remaining: 18d 2h 16m Buy It Now for only: $575.00 |
 WALNUT HALF MANTEL WITH DOUBLE COLUMNS AND CORINTHIAN CAPITALS $3,356.00 Time Remaining: 18d 3h 50m Buy It Now for only: $3,356.00 |
 Antique Oak Fireplace Mantel columns carving mirror has been refurbished $995.00 Time Remaining: 20d 21h 5m Buy It Now for only: $995.00 |
 5 matching TURNED victorian porch column posts NEVER USED 975 h x 45 square $450.00 Time Remaining: 21d 1h 44m Buy It Now for only: $450.00 |
 OldTEMPLECOLUMNSLAXMILaxsmiLAXSHMIWEALTHALTARSHRINEWOOD CARVEDBUILDING $3,000.00 Time Remaining: 21d 2h 11m Buy It Now for only: $3,000.00 |
 Massive Solid Mahogany Fireplace Mantle with Columns and Carvings $2,200.00 Time Remaining: 22d 3h 29m Buy It Now for only: $2,200.00 |
 Pair of 8 4 Pine Architectural Salvage Columns $875.00 Time Remaining: 22d 10h 36m Buy It Now for only: $875.00 |
 2 Wood Fluted Square Columns 72 1 4 Tall $539.00 Time Remaining: 22d 23h 37m Buy It Now for only: $539.00 |
 c1900 SQUARE boxed porch column post SEARS ROEBUCK house 56 h x 9 EGG dart $150.00 Time Remaining: 23d 11h 5m Buy It Now for only: $150.00 |
 Reclaimed Vintage Antique Hollow Wooden Columns $300.00 Time Remaining: 24d 49m Buy It Now for only: $300.00 |
 Antique Very large 24 Dimeter Columns 133 Tall $4,000.00 Time Remaining: 25d 21h 8m Buy It Now for only: $4,000.00 |
 Ornate Antique Newel Post Column Stairs Walnut Wood $535.60 Time Remaining: 25d 22h 15m Buy It Now for only: $535.60 |
 Heavy Antique Architectural Painted Oak Framed Column Mirror 4 Antique Hooks $325.00 Time Remaining: 26d 20h 52m Buy It Now for only: $325.00 |
 PAIR 17thc WOOD COLUMNS CARVED TOP CAPITALS 71 IN $4,000.00 Time Remaining: 27d 43m Buy It Now for only: $4,000.00 |
 ARCHITECTURAL GARDEN COLUMN $89.00 Time Remaining: 27d 22h 43m Buy It Now for only: $89.00 |
 LARGE ANTIQUE CARVED WOOD COLUMN TOP CANDLESTICK $62.98 Time Remaining: 28d 16h 34m Buy It Now for only: $62.98 |
 LARGE ANTIQUE CARVED WOOD COLUMN TOP CANDLESTICK $67.70 Time Remaining: 28d 16h 35m Buy It Now for only: $67.70 |