I have 2 "similar" SQL Selections that pull data from a Column Table. Some of the selections are the same. Between the 2 sql selects, 3 of the "where" clauses are the same and both have another one that is different.
1. Would it be better to create a single SQL using the similar where clauses and then select out the different data from Table Variable?
2. The big question I have Is:
Is there any difference in performance when selecting from a column table vs a Variable Table? I can't seem to find any information on this online.
Thanks!