J Livingston SQL (3/17/2014)
sample data would help us help you....do you know how to provide this?
No, I don't know. Do you mean about upload of database backup file? Or that I write you a script for generating sample base properly for the query I asked?
drew.king1 (3/18/2014)
Do you mean like this:SELECT
s_element.sendeplatz,
RTRIM (ISNULL(jingle.SzTitle, '')) + ' ' +
ISNULL (auths.szname, '') + ' ' +
ISNULL (comps.szname, '') + ' ' +
ISNULL (performs.szname, '') + ' ' +
ISNULL (arrangs.szname, '') + ' ' +
ISNULL (publisher.szname, '') + ' ' +
RTRIM (ISNULL(jingle.lid, '')) + ' ' +
RTRIM (ISNULL(jingle.szshortinfo, '')) AS CatColumn
No, I don't. This concatinate *constant number* of different columns, and no multiple (indeterminate number) of the same parameter rows.