Viewing 15 posts - 1 through 15 (of 15 total)
Thank you!
This syntax works for me too. And I mean it will be usefull for me in few other cases 🙂
Kind regards.
April 27, 2015 at 7:58 am
Thank You (both) very much. I'm so stupid ;)))
April 21, 2015 at 5:23 am
I updated my last post, please look above...
April 21, 2015 at 5:15 am
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...
April 21, 2015 at 5:04 am
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...
April 20, 2015 at 3:51 pm
J Livingston SQL (4/5/2014)
this may help you on your way....
Yesterday I successfully tested this solution and used it in my production script (much longer). It works perfectly. I tested by...
April 9, 2014 at 4:04 am
Sean Lange (4/4/2014)
Can you explain the output you posted? It is all text on screen so there is no separation of columns. Is this...
April 9, 2014 at 3:51 am
... and? Please...
April 4, 2014 at 9:28 am
... 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...
March 26, 2014 at 4:42 am
... and current result is:
2014-03-25 12:31:00.000StationIDAnnie Lennox ...
March 26, 2014 at 4:26 am
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...
March 26, 2014 at 4:23 am
Ok, I'll try to prepare simple data as you mentioned and put it here.
March 19, 2014 at 9:45 am
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...
March 18, 2014 at 6:43 am
Hi, could anybody help me? Please.
Or please tell me, where (on which forum) can I find an aid.
March 17, 2014 at 8:50 am
RBarryYoung (3/4/2014)
domingo.sqlservercentral (3/4/2014)
My intention is, that query returns not multiplicated rows from s_element with concatenated matched rows from these four tables (and separated with some special character).
OK, then what do...
March 4, 2014 at 4:14 pm
Viewing 15 posts - 1 through 15 (of 15 total)