Bifurcation of tables in sql server 2005
Dear All,
I want to bifurcate the tables regarding data. Means differentiate the tables who have data. How can I do it?
Networks
Dear All,
I want to bifurcate the tables regarding data. Means differentiate the tables who have data. How can I do it?
by chhabra.pranav Accepted solution
by tony hopkinson Accepted solution
something like
If the value of a field is X put it in tableA or if not in TableB?
Stored procedure would be my pick.
Give it a useful name and make the parameters the data values.
Then test the parameters and insert it into the relevant table.
You should only do this if the data has a wildly different meaning, in wahich case one would have to ask why was it coming from the same place....
This discussion is closed to new replies.
Sort by Trending