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.
 |
 BEAUTIFUL WALNUT VICTORIAN GINGERBREAD COLUMNS WITH ORNATE CARVING AND DETAIL $24.99 Time Remaining: 9h 57m |
 TURNCRAFT Architectural load bearing Wood Columns $185.00 Time Remaining: 13h 53m Buy It Now for only: $185.00 |
 TURNCRAFT Architectural load bearing Wood Columns $165.00 Time Remaining: 13h 54m Buy It Now for only: $165.00 |
 Pair of antique French turned oak columns Ideal interior design $39.48 Time Remaining: 1d 6h 20m |
 Pair of antique French turned oak columns Ideal interior design $39.48 Time Remaining: 1d 6h 23m |
 varnished oak wood residential fluted columns with largely intact capitals $1,500.00 Time Remaining: 1d 8h 6m |
 Antique Oak Fireplace Mantel columns carving mirror has been refurbished $995.00 Time Remaining: 1d 8h 50m Buy It Now for only: $995.00 |
 quartered oak wood residential columns with pressed gesso ornamented capitals $1,050.00 Time Remaining: 1d 10h 22m |
 varnished white oak wood residential room divider columns $950.00 Time Remaining: 1d 10h 24m |
 late american victorian era varnished oak wood interior residential columns $995.00 Time Remaining: 1d 10h 26m |
 Pair of Antique French 19th C solid mahogany Wooden columns $45.82 Time Remaining: 1d 20h 35m |
 OldTEMPLECOLUMNSLAXMILaxsmiLAXSHMIWEALTHALTARSHRINEWOOD CARVEDBUILDING $3,000.00 Time Remaining: 2d 7h 34m Buy It Now for only: $3,000.00 |
 victorian era solid varnished oak wood interior residential columns $1,250.00 Time Remaining: 2d 8h 15m |
 Authentic Antique Primitive Neo Classic Design Garden Accent Column $575.00 Time Remaining: 2d 9h 7m |
 oversized tapered birch wood interior residential floor to ceiling columns $1,050.00 Time Remaining: 3d 6h 43m |
 residential varnished oak wood fluted columns with ionic capitals $1,050.00 Time Remaining: 3d 6h 45m |
 late 19th century varnished oak wood columns with ionic capitals $1,050.00 Time Remaining: 3d 6h 51m |
 Massive Solid Mahogany Fireplace Mantle with Columns and Carvings $2,500.00 Time Remaining: 3d 8h 53m Buy It Now for only: $2,500.00 |
 Pair of 8 4 Pine Architectural Salvage Columns $875.00 Time Remaining: 3d 15h 59m Buy It Now for only: $875.00 |
 Antique carved mahoganny columns archway and door surrounds $6,500.00 Time Remaining: 4d 4h 48m Buy It Now for only: $6,500.00 |
 2 Wood Fluted Square Columns 72 1 4 Tall $539.00 Time Remaining: 4d 5h 1m Buy It Now for only: $539.00 |
 Two Art ColumnsThese are NOT antiqueAbout ten years oldWood98x12 $650.00 Time Remaining: 4d 5h 5m Buy It Now for only: $775.00 |
 4 Antique 19thC Folk Art Carved Painted Masonic Columns w Cast Iron Capitols $330.00 (13 Bids) Time Remaining: 4d 11h 25m |
 c1900 SQUARE boxed porch column post SEARS ROEBUCK house 56 h x 9 EGG dart $150.00 Time Remaining: 4d 16h 28m Buy It Now for only: $150.00 |
 Reclaimed Vintage Antique Hollow Wooden Columns $300.00 Time Remaining: 5d 6h 12m Buy It Now for only: $300.00 |
 EARLY 1900s 2 ANTIQUE MATCHED PAIR TAPERED 9 HOUSE HOME ARCHITECTURAL COLUMNS $995.00 Time Remaining: 5d 7h 44m Buy It Now for only: $1,295.00 |
 An Impressive Pair of Indian Carved Teak Wood Columns $899.00 Time Remaining: 6d 5h 35m Buy It Now for only: $999.00 |
 HUGE 18thC Antique Carved Wood Architectural Corinthian Column Capitol NR $305.00 (7 Bids) Time Remaining: 6d 11h 1m |
 Pair Antique Carved Architectural Columns Nice Old Paint Virginia $595.00 Time Remaining: 6d 18h 58m Buy It Now for only: $595.00 |
 Antique Very large 24 Dimeter Columns 133 Tall $4,000.00 Time Remaining: 7d 2h 32m Buy It Now for only: $4,000.00 |
 Ornate Antique Newel Post Column Stairs Walnut Wood $535.60 Time Remaining: 7d 3h 38m Buy It Now for only: $535.60 |
 Heavy Antique Architectural Painted Oak Framed Column Mirror 4 Antique Hooks $325.00 Time Remaining: 8d 2h 16m Buy It Now for only: $325.00 |
 PAIR 17thc WOOD COLUMNS CARVED TOP CAPITALS 71 IN $4,000.00 Time Remaining: 8d 6h 7m Buy It Now for only: $4,000.00 |
 ARCHITECTURAL GARDEN COLUMN $89.00 Time Remaining: 8d 15h 34m Buy It Now for only: $89.00 |
 Set of Six Porch Columns 104 Turn of the Century Home $1,500.00 Time Remaining: 11d 21h 30m Buy It Now for only: $1,500.00 |
 Vtg Antique Lot Of Five Wooden Spindled Baluster Porch Columns Railings Post $249.99 Time Remaining: 12d 41m Buy It Now for only: $249.99 |
 2 Vintage Wood Pillars Columns $199.99 Time Remaining: 13d 4h 45m Buy It Now for only: $199.99 |
 pr VICTORIAN gingerbread porch column CORBEL brackets gray PAINT 10 x 6 x 15 $45.00 Time Remaining: 13d 13h 27m Buy It Now for only: $45.00 |
 Antique Satin Wood Teak Columns India c1900 30436 $3,800.00 Time Remaining: 14d 10h 16m Buy It Now for only: $3,800.00 |
 ANTIQUE BUILDING COLUMNS WOOD POST THREE $299.00 Time Remaining: 14d 12h 24m Buy It Now for only: $299.00 |
 Fluted Ionic Cherry Columns Architectural Salvage NY 2 $195.00 Time Remaining: 14d 13h 57m Buy It Now for only: $195.00 |
 Mahogany Columns with carved capitals 9 Feet Tall $1,750.00 Time Remaining: 14d 15h 6m Buy It Now for only: $1,750.00 |
 Lot of 50 Antique Oak Architectural Corinthian Columns out of 60+ year storage $10,000.00 Time Remaining: 14d 18h 18m Buy It Now for only: $10,000.00 |
 Pair of Grand Fluted Wood Columns $4,950.00 Time Remaining: 15d 7h 16m Buy It Now for only: $4,950.00 |
 Antique Solid Wood Columns $1,800.00 Time Remaining: 15d 12h 27m Buy It Now for only: $1,800.00 |
 LARGE PAIR OF ITALIAN CARVED 19TH CENTURY WOOD COLUMNS $4,999.99 Time Remaining: 15d 19h 52m Buy It Now for only: $4,999.99 |
 ANTIQUE WOOD FIREPLACE MANTEL W TAPERED COLUMNS SPIDERWEB MOTIF $1,250.00 Time Remaining: 17d 5h 5m Buy It Now for only: $1,250.00 |
 ANTIQUE OAK FIREPLACE MANTEL WITH MIRROR COLUMNS $799.00 Time Remaining: 17d 14h 9m Buy It Now for only: $799.00 |
 11 mahogany victorian porch spindle baluster turned column 24 30L x 175 $85.00 Time Remaining: 18d 25m Buy It Now for only: $85.00 |
 15 PAINTED victorian STAIR spindle baluster turned column 275L x 175 $95.00 Time Remaining: 18d 29m Buy It Now for only: $95.00 |
 11 OAK varnished victorian STAIR spindle baluster turned column 22L x 175 $85.00 Time Remaining: 18d 31m Buy It Now for only: $85.00 |
 ARCHITECTURAL 2 PILLARS Antique Wood COLUMNS PEDESTALS $1,600.00 Time Remaining: 19d 3h 28m Buy It Now for only: $1,600.00 |
 Victorian mantle with mirror and fluted columns $850.00 Time Remaining: 20d 5h 38m Buy It Now for only: $850.00 |
 Ornate Salvaged Architectural Wood Porch Column Large Victorian Exterior Post $235.60 Time Remaining: 20d 8h 16m Buy It Now for only: $235.60 |
 Ornate Salvaged Architectural Wood Porch Column Large Victorian Exterior Post $153.56 Time Remaining: 20d 8h 36m Buy It Now for only: $153.56 |
 Architectural Salvage Wood Porch Column Large Arts Crafts Exterior Fluted Post $235.60 Time Remaining: 21d 3h 48m Buy It Now for only: $235.60 |
 Vintage Salvaged White Mantel w Columns Architectural $825.00 Time Remaining: 21d 5h 57m Buy It Now for only: $825.00 |
 Architectural Salvage Wood Porch Column Simple 75 Foot Exterior Post Capital $173.56 Time Remaining: 21d 6h 18m Buy It Now for only: $173.56 |
 Salvaged Architecture Wood Porch Column Antique 9 Foot Exterior Post Capital $235.60 Time Remaining: 21d 6h 30m Buy It Now for only: $235.60 |
 Salvaged Architecture Wood Porch Column Antique 55 Foot Exterior Post Capital $183.56 Time Remaining: 21d 7h 1m Buy It Now for only: $183.56 |
 Wood Porch Column Salvaged Architecture Hollow Victorian Exterior Fluted Post $153.56 Time Remaining: 21d 7h 12m Buy It Now for only: $153.56 |
 75 Wood Porch Column Salvaged Architecture Exterior Structural Post Antique $183.56 Time Remaining: 21d 7h 46m Buy It Now for only: $183.56 |
 Victorian wood Column turned Post porch Vintage $135.00 Time Remaining: 21d 10h 17m Buy It Now for only: $135.00 |
 Vintage Solid Wood Column 84x9 Great for Art decor $150.00 Time Remaining: 22d 9h 4m Buy It Now for only: $150.00 |
 Antique Balinese Set of 4 Honey Teak Columns From Bali $3,786.00 Time Remaining: 22d 9h 22m Buy It Now for only: $3,786.00 |
 Pair of American Antique Oak Columns 2 Circa 1900 1910 78 height $385.00 Time Remaining: 22d 9h 38m Buy It Now for only: $385.00 |
 Vintage INDONESIAN Wood Pillars COLUMNS Posts HAND CARVED Teak BALINESE Pair $3,998.00 Time Remaining: 23d 3h 33m Buy It Now for only: $3,998.00 |
 Salvaged Fir Wood Mini Columns Smaller Wooden Posts Antique Architecture $150.00 Time Remaining: 23d 5h 23m Buy It Now for only: $150.00 |
 c1830 LARGE doric column capital blocks 36 sq x 5 $425.00 Time Remaining: 23d 12h 56m Buy It Now for only: $425.00 |
 c1900 set of FOUR tapered DORIC porch columns 99 tall $750.00 Time Remaining: 23d 12h 56m Buy It Now for only: $750.00 |
 13L ROOM divider DENTIL pediment FLUTED columns 1 4OAK $1,850.00 Time Remaining: 23d 13h 19m 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: 23d 13h 20m Buy It Now for only: $475.00 |
 OAK room divider OCTAGONAL columns w STAR motif dentil pediment PILASTERS 9L8H $2,250.00 Time Remaining: 23d 13h 20m Buy It Now for only: $2,250.00 |
 PAIR circa 1890 SOLID wood TAPERED round PORCH columns capitals bases 103h $395.00 Time Remaining: 23d 13h 35m 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: 23d 13h 35m Buy It Now for only: $850.00 |
 3 salvaged pieces 2 thick boards ORIGINALLY porch columns supports 30 15 x13 $85.00 Time Remaining: 23d 13h 35m 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: 23d 13h 49m 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: 23d 13h 49m Buy It Now for only: $495.00 |
 c1900 set of FOUR tapered DORIC porch columns 92 tall $750.00 Time Remaining: 23d 13h 49m Buy It Now for only: $750.00 |
 c1900 Square BOXED PINE columns 86 tall x 8 sq $150.00 Time Remaining: 23d 13h 49m Buy It Now for only: $150.00 |
 ANTIQUE VENETIAN PALACE Wood Carved Door Entry WayMARBLE BASE Corinthian Column $4,699.99 Time Remaining: 24d 3h 50m Buy It Now for only: $4,699.99 |
 7 nicely turned wood column $200.00 Time Remaining: 24d 6h 34m Buy It Now for only: $200.00 |
 Antique Chippy White Paint Salvaged Column Piece Architectural Wood E261 $45.00 Time Remaining: 24d 8h 20m Buy It Now for only: $45.00 |
 7 Antique Decorative Columns Architectural Salvage $875.00 Time Remaining: 25d 14h 51m Buy It Now for only: $875.00 |
 Antique Victorian Pine Wood Porch COLUMN Front Porch POST Beam Simple White $183.56 Time Remaining: 26d 5h 42m Buy It Now for only: $183.56 |
 Antique Victorian Pine Wood Porch COLUMN Front Porch POST Beam Simple White $153.56 Time Remaining: 26d 5h 44m Buy It Now for only: $153.56 |
 Victorian Turned Wood Column Lamp Archetictural Salvage $95.00 Time Remaining: 26d 11h 58m Buy It Now for only: $95.00 |
 Set of 4 Porch Columns Fluted 82 Tall 12 Diameter $499.99 Time Remaining: 27d 2h 11m 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: 28d 9h 43m Buy It Now for only: $7,800.00 |
 Antique Turned Wooden Porch Column s 4 available $175.00 Time Remaining: 29d 34m Buy It Now for only: $175.00 |
 Victorian Turned Wood Column Lamp Archetictural Salvage $95.00 Time Remaining: 29d 2h 6m Buy It Now for only: $95.00 |
 Victorian Turned Wood Column Lamp Archetictural Salvage $95.00 Time Remaining: 29d 2h 10m Buy It Now for only: $95.00 |
 Antique Carved Wood and Terra Cotta Columns $575.00 Time Remaining: 29d 7h 40m Buy It Now for only: $575.00 |
 WALNUT HALF MANTEL WITH DOUBLE COLUMNS AND CORINTHIAN CAPITALS $3,356.00 Time Remaining: 29d 9h 13m Buy It Now for only: $3,356.00 |