I moved the files out to the server and it works now.

Thank you

If I have it installed, how do I even access it?

If I go to Sart/Programs/MS SQL Server I have

Client Network Utility

Configure SQL XML...

EnterPrise Mgr

Import and Export Data

Profiler

Query Analyzer

I'm not familiar w/ Reporting Services. Is this built in to SQLServer already? Can you direct my to where I might find out more information about this?

Thank you

There is a primary key on this table - user_id.

I was wondering if I could do this in a single select - i.e. not using an if statement.

The values are...

I have a proc with this:

DECLARE @TempRoles TABLE

(db_name char(25),

app_name char(25),

db_role char(25),

role_dscr varchar(255))

select @select_var = 'INSERT INTO @TempRoles (db_name, app_name, db_role, role_dscr).........

The proc compiles OK but when I...

Works great - thanks so much!

When I added the '333' record from above and ran your suggestion:

SELECT TOP 1 WITH TIES......

it only brought back the one record ('333') which had the latest date. I would...

Peter's select will not work if I add the following in GREEN

INSERT @Sample

SELECT 123, 456, 'U'