Database

<a href="http://www.sqlservercentral.com/scripts/Miscellaneous/32004/">http://www.sqlservercentral.com/scripts/Miscellaneous/32004/</a>[<a href="http://www.sqlservercentral.com/scripts/Miscellaneous/32004/" target="_blank" title="New Window">^</a>]

DECLARE @Col1 varchar(max)

SELECT @Col1 = COALESCE(@Col1 + ', ', '') + CAST(Col1 AS varchar(100))
FROM Table1
WHERE (................)

SELECT @EmployeeList

Declare @t table([Name] varchar(20),[Status] varchar(50))
insert into @t values
('John Smith','Pending Approval'),('John Smith','Waiting Email Verfication')
--,('User2','Pending Approved'),('User2','Sent email'),('User2','Other activity')
--Select * from @t

select Result = [Name] + '  ' +  Stuff((Select ',' + CAST([Status] as varchar(100)) from @t t2 where t1.[Name] 
= t2.[Name]  for XML Path('')),1,1,'')
from @t t1
group by t1.[Name] 

/*
Result
------
John Smith  Pending Approval,Waiting Email Verfication
*/

djj55 wrote:

The stored procedure is executed on a server not a database. You can have
multiple databases on one server.

_Zorro_ wrote:

Not so sure about that, I may be wrong though.

djj55 wrote:

If you try running a stored procedure that stores to the c:\ drive, see where
the file ends up.

djj55 wrote:

This rings a bell but I cannot remember.

CREATE SYNONYM [ schema_name_1. ] synonym_name FOR <object><br />
<br />
<object> :: =<br />
{<br />
    [ server_name.[ database_name ] . [ schema_name_2 ].| database_name . [ schema_name_2 ].| schema_name_2. ] object_name<br />
}<br />

USE tempdb;<br />
GO<br />
-- Create a synonym for the Product table in AdventureWorks2008R2.<br />
CREATE SYNONYM MyProduct<br />
FOR AdventureWorks2008R2.Production.Product;<br />
GO<br />
<br />
-- Query the Product table by using the synonym.<br />
USE tempdb;<br />
GO<br />
SELECT ProductID, Name <br />
FROM MyProduct<br />
WHERE ProductID < 5;<br />
GO<br />