Thank you for the link... I am using the sp_execute SP now, and see some of the benefits in it. However, since the userID contains '\' (domain\username),...

Thanks for your comments... I would prefer using the WHERE USERID = @ID, and it works just fine; however, the @whereclause part was my effort to utilize the same SP...

Thanks for your message Chris... very interesting, and thought invoking. The @ID represents the Session("AUTH_USER") variable passed when authenticating a user in a ASP page, and then passes that...

Could you elaborate on your statement? I created the stored procedure so the validation is not done through a select statement against the table itself, and the SP executed...

Found it... ''' was needed around the string in the SELECT statement

Thanks for your feedback Pete... I am using SQL Server 2000; haven't migrated to 2005 yet. I will explore the Access scenario or see if there is a way...

Unfortunately, Monarch is not an option right now. The thing that irks me is, the report will import just fine into Access or Excel set at OEM LF....

When using the WHERE NOT EXIST clause in the VALUES of the insert statement, does it need to be inside the () of the values, or outside.  The SP is...

Thank you for your comments... I will code the procedure tonight, and take into account the IF statements and usage of the SCOPE_IDENTITY.  I guess that is what I get...

Sergiy,

I am trying to follow the logic here, and understanding your insert statement.  The only columns that are unique in this table are the ID int Identity (1,1) and EventName varchar(50). ...

Thank you for your response... What would be the best method then to get the primary key (which is based upon a column called ID IDENTITY (1,1))?  The reason behind...

Thanks for your message... unfortunately, the datasource that creates these text files is an encrypted, vendor supported database.  Even the views that our apps support people have, are encrypted.  I...

Thank you for your responses... I got pulled away on another project.

Using DTS Wizard, I was able to build a fixed-width DTS package to import the text at least.  Since...

I will try out the subquery T-SQL

Since the column is varchar, it would order things like 1,11,12,13,14,2,21,22,25,3,30,31