It is my sample data:
-- creating table APERSON
USE [concat_test]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[aperson](
[lid] [int] NOT NULL,
[szname] [char](50) NOT NULL,
CONSTRAINT [pk_aperson] PRIMARY KEY NONCLUSTERED
(
[lid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
USE concat_test
INSERT INTO [dbo].[aperson]
(lid, szname)
SELECT '1','Paul McCartney' UNION ALL
SELECT '2','Bob Dylan' UNION ALL
SELECT '3','Jimmy Bralower' UNION ALL
SELECT '4','Jimmy Cliff' UNION ALL
SELECT '5','Glenn Miller' UNION ALL
SELECT '6','Neal Conway' UNION ALL
SELECT '7','Louis Armstrong' UNION ALL
SELECT '8','Dave Stewart' UNION ALL
SELECT '19','Genesis' UNION ALL
SELECT '20','Mike Rutherford' UNION ALL
SELECT '9','Martin Gore' UNION ALL
SELECT '10','Diana Krall' UNION ALL
SELECT '11','Donovan' UNION ALL
SELECT '12','Edith Piaf' UNION ALL
SELECT '13','Freddie Mercury' UNION ALL
SELECT '14','Pet Shop Boys' UNION ALL
SELECT '15','Queen' UNION ALL
SELECT '16','The Beatles' UNION ALL
SELECT '17','Eurythmics' UNION ALL
SELECT '18','Annie Lennox'
GO
-- creating table AROLLE
USE [concat_test]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[arolle](
[lid] [int] NOT NULL,
[szname] [char](40) NOT NULL,
CONSTRAINT [pk_arolle] PRIMARY KEY NONCLUSTERED
(
[lid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
USE concat_test
INSERT INTO [dbo].[arolle]
(lid, szname)
SELECT '1','Performer' UNION ALL
SELECT '2','Author' UNION ALL
SELECT '3','Composer' UNION ALL
SELECT '4','Arrangeur'
GO
-- creating table JINGLE
USE [concat_test]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[jingle](
[lid] [int] NOT NULL,
[sztitle] [char](50) NULL,
[lpublisherid] [int] NULL,
[szshortinfo] [char](80) NULL,
CONSTRAINT [pk_jingle] PRIMARY KEY NONCLUSTERED
(
[lid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
USE concat_test
INSERT INTO [dbo].[jingle]
(lid, sztitle, lpublisherid,szshortinfo)
SELECT '1','StationID','1','IDshortinfo' UNION ALL
SELECT '2','Traffic','2','TRAFFICshortinfo' UNION ALL
SELECT '3','Carpet','3','CARPETshortinfo'
GO
-- creating table JINGLEPERSONROLLE
USE [concat_test]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[jinglepersonrolle](
[ljingleid] [int] NOT NULL,
[larolleid] [int] NOT NULL,
[lapersonid] [int] NOT NULL,
CONSTRAINT [pk_xjpr] PRIMARY KEY NONCLUSTERED
(
[ljingleid] ASC,
[larolleid] ASC,
[lapersonid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
USE concat_test
INSERT INTO [dbo].[jinglepersonrolle]
(ljingleid, larolleid, lapersonid)
SELECT '1','1','17' UNION ALL
SELECT '1','2','18' UNION ALL
SELECT '1','3','8' UNION ALL
SELECT '1','4','8' UNION ALL
SELECT '2','1','5' UNION ALL
SELECT '2','1','14' UNION ALL
SELECT '2','2','2' UNION ALL
SELECT '2','2','7' UNION ALL
SELECT '2','3','1' UNION ALL
SELECT '2','3','2' UNION ALL
SELECT '3','1','15' UNION ALL
SELECT '3','1','16' UNION ALL
SELECT '3','1','19' UNION ALL
SELECT '3','2','1' UNION ALL
SELECT '3','2','2' UNION ALL
SELECT '3','2','20' UNION ALL
SELECT '3','3','1' UNION ALL
SELECT '3','3','2' UNION ALL
SELECT '3','3','20' UNION ALL
SELECT '3','4','13'
GO
-- creating table PROGRAMMITEM
USE [concat_test]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[programmitem](
[lid] [int] NOT NULL,
CONSTRAINT [pk_programmitem] PRIMARY KEY NONCLUSTERED
(
[lid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
USE concat_test
INSERT INTO [dbo].[programmitem]
(lid)
SELECT '1' UNION ALL
SELECT '2' UNION ALL
SELECT '3'
GO
-- creating table PUBLISHER
USE [concat_test]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[publisher](
[lid] [int] NOT NULL,
[szname] [varchar](120) NULL,
CONSTRAINT [pk_publisher] PRIMARY KEY NONCLUSTERED
(
[lid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
USE concat_test
INSERT INTO [dbo].[publisher]
(lid, szname)
SELECT '1','EMI' UNION ALL
SELECT '2','Warner' UNION ALL
SELECT '3','Universal'
GO
-- creating table S_ELEMENT
USE [concat_test]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[s_element](
[planelemid] [int] NOT NULL,
[planheaderid] [int] NULL,
[lprogrammitemtypid] [int] NULL,
[lprogrammitemid] [int] NULL,
[sendeplatz] [datetime] NULL,
CONSTRAINT [pk_s_element] PRIMARY KEY NONCLUSTERED
(
[planelemid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
USE concat_test
INSERT INTO [dbo].[s_element]
(planelemid, planheaderid, lprogrammitemtypid, lprogrammitemid, sendeplatz)
SELECT '1','1','30','1','2014-03-25 12:31:00' UNION ALL
SELECT '2','1','30','2','2014-03-25 13:33:00' UNION ALL
SELECT '3','1','30','3','2014-03-25 14:38:00' UNION ALL
SELECT '4','1','30','1','2014-03-25 15:41:00' UNION ALL
SELECT '5','1','30','2','2014-03-25 16:45:00' UNION ALL
SELECT '6','1','30','3','2014-03-25 17:51:00'
GO
-- creating table S_PLANHDH
USE [concat_test]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[s_planhdh](
[planheaderid] [int] NOT NULL,
[filetype] [char](2) NULL,
CONSTRAINT [pk_s_planhdh] PRIMARY KEY NONCLUSTERED
(
[planheaderid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
USE concat_test
INSERT INTO [dbo].[s_planhdh]
(planheaderid, filetype)
SELECT '1','I'
GO