elauri

I have following tables table1 nr_key1 nr_dad1 table2 nr_key2 value (repeated ~n times with same nr_key2 and different value) in table2 nr_key1 = nr_key2 After I have iterated through nr_key1 I want to use recursion to select nr_key1 = nr_dad1 and iterate again table2 with the new nr_key1. This should …

Hello all, my first post. I have identical tables in my db. Is there a way to create a view with dynamic query to combine/union all the identical tables into one view? dbo.table.x-1 dbo.table.x-2 dbo.table.x-3 dbo.table.x-{n}