new refactor suggestion

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

new refactor suggestion

Postby DanAvni » Fri Sep 24, 2010 9:40 am

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
DanAvni
 
Posts: 48
Joined: Wed Jun 15, 2005 12:55 pm

Postby Linda Hawksworth » Mon Sep 27, 2010 9:23 am

I have logged your feature request with reference SR-903. I will let you know if/when the status of this issue changes.
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am


Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 0 guests