Database

BEGIN TRANSACTION
CREATE TABLE #EventType
(
 ID     INT
,[Name] VARCHAR(50)
)
INSERT INTO #EventType
      SELECT 1        ,'Party'
UNION SELECT 2        ,'Meeting'
UNION SELECT 3        ,'Something else that wasn''t mentioned'
 
CREATE TABLE #Person
(
 ID     INT
,[Name] VARCHAR(20)
)
INSERT INTO #Person
      SELECT 1      ,'Bob'
UNION SELECT 2      ,'Joe'
UNION SELECT 3      ,'Suzie'

CREATE TABLE [#Event]
(
 UID        INT
,EventID    INT
,EventType  INT
,Person     INT
)
INSERT INTO [#Event]
      SELECT 1,     1,           1,             1
UNION SELECT 2,     1,           1,             2
UNION SELECT 3,     1,           1,             3
UNION SELECT 4,     2,           1,             1
UNION SELECT 5,     2,           1,             3
UNION SELECT 6,     3,           2,             1
UNION SELECT 7,     3,           2,             2

SELECT DISTINCT EventId
           INTO #SomeTable
           FROM [#Event]

SELECT EventId
      ,[Name]
      ,SUBSTRING(CompoundColumn, 0, LEN(CompoundColumn) - LEN(', '))
      AS People
   FROM (
          SELECT ST.EventId
                ,ET.[Name]
                ,REPLACE(REPLACE(
                 (SELECT P.[Name]
                    FROM #Event E
                    JOIN #Person P ON E.Person = P.ID
                   WHERE E.EventID = ST.EventID
                    FOR XML AUTO), 
                 '<P Name="', ''), '"/>', ', '
                 ) AS CompoundColumn
            FROM #SomeTable ST
            LEFT JOIN #EventType ET ON ST.EventId = ET.ID
        ) AS tmp_cte

ROLLBACK

EventID     EventTypeName      People
-------------------------------------------------------
1           Party              Bob, Joe, Suzie
2           Party              Bob, Suzie
3           Meeting            Bob, Joe

EventId  Name                                       People
-------  ---------------------------------------    -----------------
1        Party                                      Bob, Joe, Suzie
2        Meeting                                    Bob, Suzie
3        Something else that wasn't mentioned       Bob, Joe

Bastard Programmer from Hell

DECLARE @String VARCHAR(8000)
set @String = ''
 
SELECT @String = @String + 'Name:' + ISNULL(Name,'NULL') + ' Age:' + Age + ' Total:' + Total + '; '
FROM TABLE

print @String

DECLARE @Temp TABLE(Name VARCHAR(20),Age TINYINT, Total INT)

INSERT INTO @Temp(Name,Age,Total)
SELECT 'Ram',26,800
UNION ALL
SELECT 'kumar',36,300
UNION ALL
SELECT 'Sam',34,200

DECLARE @SQLStr VARCHAR(8000)
SET @SQLStr = ''
 
SELECT @SQLStr = @SQLStr + 'Name:' + Name + ' Age:' + CAST(Age AS VARCHAR) + ' Total:' + CAST(Total AS VARCHAR) + '; '
FROM @Temp
 
PRINT @SQLStr

From link[^]:

Basically, when you failed to connect to your SQL Server, the issue could be:
1) Network issue,
2) SQL Server configuration issue.
3) Firewall issue,
4) Client driver issue,
5) Application configuration issue.
6) Authentication and logon issue.

thatraja

---

My Dad had a Heart Attack on this day so don't...
Pompeyboy3 here | Nobody remains a virgin, Life screws everyone

vkstarry wrote:

the max of varchar is varchar(8000)

Bastard Programmer from Hell