Advanced Search

Return to Snippet

Revision: 50226
at August 16, 2011 12:59 by lostumbrellas
Initial Code 
update asset_class_allocations
set to_date = '2011-07-01'
from asset_allocation aa 
join options o on aa.option_uid = o.uid
join product p on o.product_uid = p.uid
where p.product_id in (817,617)
and asset_class_allocations.to_date = '2011-06-30'
and asset_class_allocations.allocation_uid = aa.uid;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
SQL Update With Join

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
update

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL