var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Creating one string from multi records
My problem is that i have a table in my DB that is used for multi list boxs which is linked to a header record.
so 1 header record can have none, 1 or many entries in this table.
So, is there a way in a query to concatinate however many entries in the table into 1 record seperated by a ; that i can link to my header record.
select stuff((select ';'+columnname from tablename where headerid = t.headerid for xml path('')),1,1,'') from tablename t
didnt even know this function existed...
xml path function will works from 2005 and above .