Question Locked

Bifurcation of tables in sql server 2005

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Dear All,

I want to bifurcate the tables regarding data. Means differentiate the tables who have data. How can I do it?

2 replies

by tony hopkinson

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.