The way it's set up is that the Oracle application is where the schema and tables exist for the report I'm creating, and I use the SQL Reporting database in...

The schema and table are found in the Toad for Oracle application, but the SQL query is being run in the SQL Reporting database of MS SQL Server Management Studio....

I'm not sure what that looks like or what it means when you refer to 'parsing input parameters into a derived table, but if it means better efficiency, I'm all...

wow! what an eye opener....I really appreciate your feedback... I didn't realize all that you mentioned. I will work with what you said and apply that to this query to...

It's worth a try...I'll give both options a run and see what happens, and whatever results I get, I'll reply back to this forum session.

thanks for your help!

Steve

Hi Jack,

The strange thing is that I'm not getting any errors...the LAST_RECORDS table seems to be stuck in limbo and not able to receive the information that's being passed from...

I appreciate your help on this issue...I'll take your suggestion and see where it leads me...if I run into any trouble, I'll reply back to this forum topic.

Thank you for...

Okay...so if I'm using SQL Server 2005, where do go to execute that command? when you say it's in there, are you referring to the dynamic management view (sys.dm_db_index_usage_stats)? I'll...

I apologize for not being clear...the goal was to total up the 'wgt_amount' column by adding the records with mx_2 code of 'CONSUME' OR 'SLOFF' and then remove (subtract out)...

I appreciate your help and guidance on this issue...it makes sense to me what you stated. I've learned something new today. Thanks Lowell!