By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,289 Members | 3,049 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,289 IT Pros & Developers. It's quick & easy.

Using CTE Common Common Table Expressions

P: 2
I have set of standard tables like Products, Customers, Orders, OrderDetails, and so on - but I need to run reports on a particular subset of the data or categorize the tables to make it one or few big tables to generate reports.
I am wondering which approach is good, using Common Table Expressions or the stored procedure or if you have any good approach please suggest
Jun 21 '07 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 404

have you considered defining a set of views for the reporting requirements

Jun 21 '07 #2

P: 2
No. The company standard is not to use any views. So, I can not use any views.
Jun 21 '07 #3

P: 13
It dipends.
If you use crystal reports for meke reports you can use stored procedure with parameters.

Or you can crate neutral tabele where you insert the data you need you must add a field like WorkstationId that contains the unique name in your natwork of pc that request the data.

You make table like this :


You insert your data always in your netrual table fo every user that need reports.
Before a user start inetrrogation you delete the data in the table that exist for that user and after execute the querys that populate the neutral table.
Jun 22 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.