Hi guys. Everything is working perfectly now!! Special thanks to Sean, Chris, Todd and all those that contributed. I really appreciate the time and effort you guys put into helping...

Hi guys. I really appreciate all of the help in optimizing this sproc. Chris, I've tested the code you submitted and everything works fine but I need the results to...

Hi Sean. For this segment of code, there is only one record in this table and it will be the only one every entered for this table. This is how...

Uh oh. I thought I was done! The cursor was the only way I was able to get it to work the way I needed it to but if that...

I finally got the procedure to do what I wanted it to do. The modified procedure is listed below. Special thanks to all that contributed!!

USE [ISPurchasing]

GO

/****** Object: StoredProcedure [dbo].[cust_CreateJournalEntry]...

No kidding. The database I'm working with has over 900 tables with sprocs calling sprocs, it is a nightmare!! Thanks again for your help Sean.

Thanks Chris. I will try this when I get back to my office.

There is nothing advanced or difficult about the T-SQL in your stored procedure. Basic garden variety junk someone with a month's knowledge of T-SQL put together. Also, the comments...

There was no purpose for this particular query other than to help me see the results I wanted. I have cleaned the code up and posted it below.

SELECT ...

Thanks Sean. I will look at a better way to code this. I actually inherited this database and I’m trying to modify it the best way possible without reinventing the...

Thank you all for your help. I found that the tracing approach is helping me figure out what tables and applications are involved in the database transactions. I wasn't able...

No, I am running SQL Server 2008.

skcadavre, thanks for the scripts, but when I run them, I get the following errors:

1st script:

Msg 195, Level 15, State 10, Line 3

'Object_schema_name' is not a recognized built-in function...

There are a few existing applications but the only problem is that I am using SQL Server Management Studio Express to connect to the database and don't think SSMSE have...

I apologize for not being clear. I know how the write SELECT statements, my problem is that I don't know how the database was designed so when I receive a...