NEWS

Monday, January 30, 2012

Query to concatenate column values without loop


DECLARE @Vals varchar(500)
SET @Vals=''
SELECT @Vals= ISNULL(@Vals,'') + CAST(Col1 AS VARCHAR(3)) + ',' from tblData
SELECT @Vals
Posted by at
Labels:

3 comments:

  1. oakleysesNovember 19, 2014 at 7:34 PM

    louboutin, louis vuitton outlet stores, louis vuitton outlet, coach factory outlet, tory burch outlet, michael kors outlet, true religion jeans, polo ralph lauren outlet, prada handbags, jordan shoes, burberry outlet, oakley sunglasses, longchamp outlet, polo ralph lauren outlet, air max, prada outlet, longchamp handbags, true religion jeans, louboutin outlet, coach purses, coach outlet, gucci outlet, ray ban sunglasses, ray ban sunglasses, oakley sunglasses cheap, christian louboutin shoes, louis vuitton handbags, oakley sunglasses, nike shoes, louis vuitton, longchamp handbags, michael kors outlet, air max, tiffany and co, chanel handbags, michael kors outlet, coach outlet store online, louboutin, kate spade outlet, michael kors outlet, michael kors outlet, tiffany and co, kate spade handbags, burberry outlet, nike free, michael kors outlet, louis vuitton outlet

    ReplyDelete
  2. AnonymousMay 13, 2016 at 10:57 PM

    herve leger, timberland boots, giuseppe zanotti, iphone cases, insanity workout, mac cosmetics, reebok shoes, hollister, bottega veneta, vans shoes, soccer shoes, gucci, mont blanc, new balance, soccer jerseys, nike roshe, babyliss, converse, valentino shoes, ray ban, jimmy choo shoes, birkin bag, north face outlet, nike air max, baseball bats, nike air max, hollister, louboutin, nike trainers, instyler, ralph lauren, chi flat iron, hollister, ferragamo shoes, vans, nfl jerseys, converse outlet, mcm handbags, nike huarache, celine handbags, p90x workout, wedding dresses, abercrombie and fitch, north face outlet, longchamp, lululemon, ghd, oakley, asics running shoes, beats by dre

    ReplyDelete
  3. AnonymousMay 13, 2016 at 11:04 PM

    canada goose uk, louis vuitton, swarovski, thomas sabo, canada goose outlet, doudoune canada goose, supra shoes, links of london, karen millen, moncler, sac louis vuitton pas cher, pandora jewelry, ugg,ugg australia,ugg italia, hollister, wedding dresses, juicy couture outlet, canada goose, moncler, barbour jackets, marc jacobs, pandora charms, toms shoes, pandora charms, bottes ugg, coach outlet, montre pas cher, canada goose outlet, louis vuitton, moncler, louis vuitton, ugg pas cher, ugg boots uk, barbour, lancel, pandora jewelry, moncler, louis vuitton, moncler, swarovski crystal, juicy couture outlet, canada goose, moncler outlet, canada goose, moncler, replica watches, ugg,uggs,uggs canada, canada goose, moncler

    ReplyDelete

Subscribe to: Post Comments (Atom)