sql - Truncate multiple select and update clauses into a single clause -

-

the below query seems inefficient, doing swapping out 1 variable (cobrand) each query. there way consolidate query 1 clause , same result?

update temp_08.members set distinct_count= (select distinct_count temp_08.members cobrand='10001372' , month = '2016-09') cobrand='10001372' , month = '2016-10' or month = '2016-11';   update temp_08.members set distinct_count= (select distinct_count temp_08.members cobrand='10006164' , month = '2016-09') cobrand='10006164' , month = '2016-10' or month = '2016-11';    update temp_08.members set distinct_count= (select distinct_count temp_08.members cobrand='10005640' , month = '2016-09') cobrand='10005640' , month = '2016-10' or month = '2016-11';    update temp_08.members set distinct_count= (select distinct_count temp_08.members cobrand='10005244' , month = '2016-09') cobrand='10005244' , month = '2016-10' or month = '2016-11';

use postgres' update-with-join syntax:

update temp_08.members set distinct_count = dc (select cobrand, distinct_count dc       temp_08.members       month = '2016-09') x temp_08.members.cobrand = x.cobrand , month in ('2016-10', '2016-11')

you can add inner query if want update cobrands:

and cobrand in ('10001372', '10006164', '10005640', '10005244')

Comments

Post a Comment

Popular posts from this blog

php - Autoloader issue not returning Class -

-
problem? bootloader (autoloader) not seem working properly, or i'm missing something. here simplified code. the code below returns class "skeleton" not exist. on index.php file. index.php <?php include 'bootloader.php'; use skeleton\html\loginheader; $tool = new skeleton/html/loginheader(); bootloader.php <?php function boot($classname) { $filename = ''; $namespace = ''; // sets include path "src" directory $includepath = dirname(__file__).directory_separator.'src'; if (false !== ($lastnspos = strripos($classname, '\\'))) { $namespace = substr($classname, 0, $lastnspos); $classname = substr($classname, $lastnspos + 1); $filename = str_replace('\\', directory_separator, $namespace) . directory_separator; } $filename .= str_replace('_', directory_separator, $classname) . '.php'...
Read more

python - Getting next two indexes regardless of current index -

-
i trying create mock rock, paper, scissors game each name having 2 enemies, must able grab values of names regardless of position. say given list: names = ["kings", "queens", "jacks", "jokers", "masons", "warriors", "soldiers"] and trying use logic indexes being values , gather next 2 values of indexes. each index return these values. 0 - 1, 2 1 - 2, 3 2 - 3, 4 3 - 4, 5 4 - 5, 6 5 - 6, 0 6 - 0, 1 so 'warriors' have enemies of: soldiers , kings below being current implementation: def state_to_text(self): names = ["kings", "queens", "jacks", "jokers", "masons", "warriors", "soldiers"] if self.state == 0: return str(names[1], names[2]) if self.state == 1: return str(names[2], names[3]) if self.state == 2: return str(names[3], names[4]) if self.state == 3: return str(names[4...
Read more

ruby - Prevent Custom Validation Error on Association -

-
i have app list , email models many many association. want users able add many emails lists @ once, have function in controller split emails custom textfield in new list form "emails" array. i want validation error if it's blank added custom validation on field in lists model: class list < applicationrecord has_and_belongs_to_many :emails #tried adding ", validates: false" here too, didn't work #custom attr_accessor :emails validates :emails, presence: true end it works great, except when try associate existing email list (in case user entered 1 in db), validation error. oddly, can prevent validation error when associating net new emails lists "(validation: false)" seen below, not when email exists already, if add save function , append "validation: false". part of controller in question is: emails.each |email| if email.where(email: email).blank? db_email = email.new( email: email ) db_email...
Read more