Bifurcation of tables in sql server 2005

By chhabra.pranav ·
Dear All,

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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Um not sure I get you here, do you mean

by Tony Hopkinson In reply to Bifurcation of tables in ...

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....

Related Discussions

Related Forums