Database

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

smcnulty2000 wrote:

I'm curious enough to continue researching this but let us know if you decide on
a solution.

Mycroft Holmes wrote:

but we use Oracle for any really big data (multi TB)

Mycroft Holmes wrote:

our legacy systems were designed by incompetent, moronic, lazy, uneducated,
idiots who only had a vague idea about the business and absolutely no idea about
data structures

Mycroft Holmes wrote:

Still does not make sense to me. Why not take a copy of the procedures and run
them on the test server.