Viewing 3 posts - 1 through 3 (of 3 total)
Yes, Pat, that was the trick. Treating it as two tables and referencing itself. Thanks for your help.
March 15, 2006 at 9:59 am
#626839
Yes, you're 2nd post is more of what I'm looking for. However, that still returns more than one user per ProjectID.
March 15, 2006 at 9:14 am
#626813
I would take at this article from the Database Journal: http://www.databasejournal.com/features/mssql/article.php/1459181
The article describes how to execute a DTS package in a stored procedure without using the xp_cmdshell command.
Matt
January 10, 2006 at 6:35 am
#613778