Thanks for the suggestions, I ended up using DMO, via TSQL. Here is my hack, if you are interested.

Declare @rc int

DECLARE @object int

declare @Output varchar(255)

Declare @Method varchar(255)

DECLARE @src varchar(255)

Declare...

In case you are interested I answered my own question. Here is my solution. Came to me as I when to get something out of the vending machines....

Maybe I don't make myself total clear. What I want is to have is a complete error messages as a single column. So basically you need to concatinate...

How about something like this (not tested):

SELECT DISTINCT

a.JobId,

a.fromstoreId,

b.storeName,

a.toStoreId,

c.storeName

FROM tblJob a,

tblStore b,

tblstore c,

tblClient cl

WHERE

AND cl.clientId = b.clientId

AND a.fromstoreId = b.storeId

and a.tostoreid = c.storeid

AND a.toStoreId <>...

You have the sub-query a little wrong, thought you wanted one by event_date. Try this:

select a.* from (select p.people_id, p.last_name, p.first_name,

c.cases_id as casesid,

ep.start_date,

st.site_id, st.site_name as PfizerSiteName,

ev.event_id,...

You could add an id field to each table like this, so you could do the join.

create table aaa (a1 int)

create table bbb (b1 int)

insert into aaa values (6)

insert into...

You might try a correlated sub query like this:

select * from Northwind.dbo.[Order Details] a

where

ProductId = (select top 1 productid from Northwind.dbo.[Order Details]

...

I always do logins first. I use sp_help_revlogin to accomplish the moving of logins. More info here about sp_help_revlogin

http://www.databasejournal.com/features/mssql/article.php/2228611

Gregory Larsen, DBA

If you looking for SQL Server Examples check...

Jeremy, hopefully jpipes and DavidBurrows answered your question. If not let me know.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

use xp_help_revlogin. You can find a copy here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

You might consider looking into using the DATAPART function and summing and averaging on the WEEK datepart.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at...

Here is an example that shows the 76th highest salary. You might be able to do something like this with dynamic SQL to change the 76 to some N...

I use SQLCompare. Think you can download a trial copy. If you like it I would buy it. It is a great tool for a number of...

I'm not so quick to agree. We logging all successful logins, as well as unsuccesful logins. One reason we do this is to audit logins to see when...

We have in the past gone a number of months between reboots.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples