How to manipulate two or more composite data type into single results set
In SQL server, Temp table,
they are using two or more temp tables inside the single procedure.
Now i am consider those temp tables as a composite records
For example i have two composite data type rec1 and rec2
I need to combine with these composite two records for aggregation process and also they are need to grouped by grouping function
Is there is anyway to reach ?
Note: Multi-set operators doesn't required for my requirement.
Here only need aggregation process .
Kindly correct me if I am wrong.
Any help with be really appreciated