Attn: Enthusiast

Disregard my last post, I got it working properly. 

Thanks again for all your help.

Awesome.  All the quote you wrote does work the way I want it.  The only exception is the Receipt.UserId applied to the OUTER JOIN.  When I add the OUTER JOIN...

All the field headers display, but the existing data is not displayed.

Attn:  Enthusiast

I used both examples above, that included the fields in the table.  However, when I run the select statement, even though, there are records in the table.  It does...

I currently have a view called vwSelect_Receipts, but I don't have the second line (in red above) as part of the view.  Can I use the following line within the...

I just tried the code you posted and did not receive an error.  The message was display after I created the table.

(3 row(s) affected)

(3 row(s) affected)

In creating the stored procedure that takes a user's login as a parameter and returns the correct credential, how is this accomplished.  My user login requires the user to enter their...

Thanks, I will give that a shot.

Would I use the DECLARE @Receipt, @OfficeCostCtr, then use SET @Receipt = SELECT etc.

I've never used a variable before, so I'm not sure how to use it in a TRIGGER.   ...

I'm not doing a bulk insert.  It's one record at a time, so how can I get the value first and then include it in my insert statement.

Thank you so much for the time you spent on resolving my problem.  I'm very appreciative also of the resolution you came up with.  Once again, thanks. 

Here's the script file.  I wasn't sure if I could import the .sql file into this post, so I copied the file below.

Note:  If there is a way to upload...

Thank you, David.  I will try that.

To:  Julian

Ye, I tried the SQL statement and it worked the way you said.  I'm so happy.  (I still need to know if this will work with a View or...

To: Julian Kuiters

I'm building a front end application that will be accessed through our intranet with a SQL backend.  When the users login, they will be directed to a main...