Thank you!

This syntax works for me too. And I mean it will be usefull for me in few other cases 🙂

Kind regards.

Thank You (both) very much. I'm so stupid ;)))

I updated my last post, please look above...

My tested example was:

CREATE TABLE Persons

(

P_Id int NOT NULL,

LastName varchar(255) NOT NULL,

FirstName varchar(255),

Address varchar(255),

City varchar(255),

CONSTRAINT chk_Person CHECK (P_Id<>0 AND City<>'Sandnes')

)

GO

INSERT INTO Persons

VALUES (1, 'MyLastname', 'MyFirstname', 'MyAddress', 'London')

GO

--

But I need to...

I found examples for many columns, as below:

CONSTRAINT chk_Person CHECK (P_Id>0 AND City='Sandnes')

but... it works independly for these columns, as two simple check constraints. I need a rule for relationship...

Yesterday I successfully tested this solution and used it in my production script (much longer). It works perfectly. I tested by...

Sean Lange (4/4/2014)

---

Ah so it is. My bad. So...

Can you explain the output you posted? It is all text on screen so there is no separation of columns. Is this...

... and? Please...

... and I need this rows concatenated as below:

2014-03-25 12:31:00.000StationIDAnnie LennoxDave StewartEurythmicsDave StewartEMI1IDshortinfo

2014-03-25 13:33:00.000TrafficBob Dylan, Louis ArmstrongPaul McCartney, Bob DylanGlenn Miller, Pet Shop BoysWarner2TRAFFICshortinfo

2014-03-25 14:38:00.000CarpetPaul McCartney, Bob Dylan, Mike RutherfordPaul...

... and current result is:

2014-03-25 12:31:00.000StationIDAnnie Lennox ...

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...

Ok, I'll try to prepare simple data as you mentioned and put it here.

No, I don't know. Do you mean about upload of database backup file? Or...

Hi, could anybody help me? Please.

Or please tell me, where (on which forum) can I find an aid.

RBarryYoung (3/4/2014)

---

OK, then what do...