new refactor suggestion

DanAvniDanAvni Posts: 55 Bronze 2
edited September 27, 2010 4:23AM in SQL Refactor Previous Versions
just like the split table, i came today with a need to do a horizontal splitting: i need to take some of the records from a table (using a specific where clause) and put them in a seperate table (with the exact same structure) and then modify all SPROCs that insert or update to do their job on either table (based on the same where clause logic from before) and of course also modify all selecs from the table to do a union of two selects
Dan Avni

Comments

Sign In or Register to comment.