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.