Try this:

DECLARE @DBA_USERS TABLE( USERNAME varchar(10), 

                                               [PASSWORD] varchar(10))

INSERT INTO @DBA_USERS

SELECT 'FIRST', '123' UNION ALL

SELECT 'SECOND', '345' UNION ALL

SELECT 'THIRD', '678' UNION ALL

SELECT 'FOURTH',...

That's probably better for more information.  You'll just have to make a #TempTable with the various TableName(s) in it...

Here's a start.  You may need to jump databases to get both into one print out...

SELECT CONVERT( varchar(50), so.name) AS TableName,

             CONVERT( varchar(25), sc.name) + '(' +

            ...

Hi buddy! 

Either you're right or you're SCC razy...   

Please do not cross post...

I am not sure what you mean by MAX REVISION.  This sounds like a pretty simply query; to that end, I may have misunderstood just precisely what you are looking...

Try this...

If what you are looking for is appending all the possible [Description]s, this should work...

IF EXISTS( SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.Products')

          AND OBJECTPROPERTY(id, N'IsUserTable') =...

This works, but I am thinking you may actually want more than a single character, (or integer) passed into your @Parameter?  Hence the need for IN(...). 

Therefore I have written...

Try this:

SET @queryString = 'SELECT ' +  @EmployeeNo + ' = b.employee_no, @AccessLevelID = a.Access_Seq FROM ' +

                               @dbName + '..employee a, ' + @dbName + '..userlog b...

You have performed beyond my wildest expectations for not having studied!!! 

You could try adding an ISNULL, but I am not sure that will increase your processing time. 

WHERE( ISNULL( E.Unit, @unit) LIKE '%' + @unit + '%') ...

Other than the loop, it is pretty set-based.  Good to hear from you again, Mr. Smarty-pants! 

I tried it a bit different than Gopi Nath Muluka by adding a table with the "prefix" values and using two functions, (one to remove those values rather than directly...

Glad I could help.  Thanks for replying from another post!