Hi All, i have different situation where i am selecting from 4 tables into temporary table and one of these table contains identity column, so while i am selecting the records into this temp table the IDenity column is also creating, my logic needs to have new identity column for this results and columns from this 4 tables are always variant so can any one suggest what should be the best solution for this problem.
I have two options but i feel these are not optmized.
1) adding another column and copy the Idenitity column values into the new column then dropping the identity column
2) changing the sytem configuration files but needs addition permissions
Start Free Trial
