Creating a table with custom field columns

jim van dick

14y2.3kSQL

Hi All.I have a question about how to best pull data for a report. I have a main table work_orders that has a related table called custom_fields. it is a 0 to many relationship. I am having a real problem trying to figure out the best way to display data in a report efficiently. What I want to do is display the work_order data and also all the custom_fields as a single row. I have attempted to use linq and I cant seem to figure out the best way to efficiently do this. I am relatively new to SQL Server and was wondering if anyone had an idea to efficiently do this.

Thanks in advance.

Jim

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
Hi Jim,

If you have more data in these two tables then go for the indexed view , because normal view work like normal query. It will execute the script and load into view.

If you are not using this joining of two tables in many places then you can go for joins and create the indexes wherever required.
0
Nitesh Kejriwal14y ago
You can also use JOINS to retrieve your data by joining on the related column.
0
Mahesh Chand14y ago
You can create a View from both tables the way you want your report to look like. Then just find your report from the View.
0