question

raghuvalipe avatar image
raghuvalipe asked

how to get details from sqljob without running every time

Hi , i am new to SSC, my scenario is, i have created tables A,B,C which have foreign key relation ships in between them. i need to join these 3 tables every time in procedures to get results.its bit time consuming every time. so for this purpose i created a table 'R' and a procedure . in this procedure i am joining all the tables(A,B,C) and storing the result in table R.to get result into this table i create SqlJob which runs daily 1 time. but here is the problem,sometimes i want the results from A,B,C tables whose records inserted recently. Is there any solution to get the result from R table without running SqlJob every time. sorry for typo mistakes, if any. Thank you.
joinstemporary-table
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
might just need a view named R rather than a table named R
3 Likes 3 ·
JohnM avatar image JohnM commented ·
Define a bit time consuming? Can you tune the procedures to increase performance? What happens if the data changes in the three tables? Do you reload the data in table R?
1 Like 1 ·
askcoffman avatar image askcoffman commented ·
Can you define how often "sometimes i want the results"? How often do you need to run the sql job? Is this in a production server?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.