I am on a quest to rescue the name Gary from extinction.
I’d like to start an online communitt of Garys where we can meet up to discuss our efforts to keep the name alive. I’m having trouble finding the ideal forum and in actually being able to reach out to Garys across the globe to get them to join. Any suggestions?
Thanks
Tag: Join
Deal – Join Finalmente Global and get 50 BMF | Proxies-free
Earnings Disclaimer: All the posts published herein are merely based on individual views, and they do not expressly or by implications represent those of Proxies-free or its owner. It is hereby made clear that Proxies-free does not endorse, support, adopt or vouch any views, programs and/or business opportunities posted herein. Proxies-free also does not give and/or offer any investment advice to any members and/or it’s readers. All members and readers are advised to independently consult their own consultants, lawyers and/or families before making any investment and/or business decisions. This forum is merely a place for general discussions. It is hereby agreed by all members and/or readers that Proxies-free is in no way responsible and/or liable for any damages and/or losses suffered by anyone of you.
sql server – Select the first row returned from the join query based on a condition
I have 2 tables PRODUCT and MANUFACTURER
Table1: PRODUCT, Columns: PRODUCT_ID,PRODUCT_NAME
Table2: MANUFACTURER, Columns: PRODUCT_ID,MANF_ID,ITEM_NO,DEFAULT_MANF
I have to select the default manufacture of a product from the MANUFACTURER table. If no default manufacture is available, i will select a manufacturer by the ITEM_NO from the MANUFACTURER table.
I have written query for this as below:
SELECT p.PRODUCT_ID, p.PRODUCT_NAME, m.MANF_ID, m.ITEM_NO, m.DEFAULT_MANF
FROM PRODUCT p
INNER JOIN MANUFACTURER m on p.PRODUCT_ID = m.PRODUCT_ID
WHERE p.PRODUCT_ID = 'PROD001'
AND m.MANF_ID = (SELECT TOP 1 MANF_ID FROM MANUFACTURER man WHERE man.PRODUCT_ID = p.PRODUCT_ID and coalesce(man.DEFAULT_MANF, 'N') = 'Y' ORDER BY man.DEFAULT_MANF, man.MANF_ID )
This query works as expected in SQL Server, but on Oracle it wont work as I am using ‘TOP’ in the query.
Is there any way I can modify the query to work in both SQL Server and Oracle?
sql server – Need help with JOIN I should be using as values are in columns are changing to find difference in tables
how can i compare text info using joins here as parentid & id of node will be the identifying factor for difference and also the text ?
columns are
RID ConfigFileID ID(xml child node) ParentID(xml parent node) Path Text
My query showing wrong results . Ideally should show 2 rows for which text is missing or addition:
select * from XML_table a
left join xml_table b
on a.id= b.id
where a.ConfigFileInfoID = 55187765 and b.ConfigFileInfoID = 55205283
and a.id = b.id
and a.text != b.text
and a.parentid ! = b.parentid
and a.path ! = b.path
(data in xml table is just english text for which i need to find difference)
RID ConfigID ID parentId Path
Blockquote
RID ConfigID ID parentid Path Text
333570 55187765 36 28 configuration/system.web/customErrors NULL
347804 55205283 36 0 configuration/system.serviceModel NULL
My final query should display the difference this way ..the path is different and ID & parent ID should be different to identify that there is a difference. RID & Config ID will keep changing anyway .The path is almost the same but changes in the final file.the key is to know what changed in path and I need to find difference in text too( here null but sometimes there are different texts)
photo editing – Underwater: Edit and Join separated layers smoothly
As I really enjoy underwater photography, I am wondering how does one end up with a final image like the one I share below:
Unedited on the left, desired effect on the right:
Source: https://www.instagram.com/p/CApGLcCHStN/
This edit seems to complex for Lightroom as it doesn’t have a Channel Mixer so I presume the photographer used Photoshop or GIMP. There one can copy a blue/green channel and convert it to red.
In this case, it seems that the photographer is using two separate layers and adds the people separately, so that he can get a darker background.
Assuming that to get an image like the one shown above the photographer is not only using a pure picture and color grading, but editing multiple layers of underwater images and join them smoothly, how does one edit and join edited layers, from underwater images, in a subtle way?
Deal – Join my team and get 75 BMF | Proxies-free
Earnings Disclaimer: All the posts published herein are merely based on individual views, and they do not expressly or by implications represent those of Proxies-free or its owner. It is hereby made clear that Proxies-free does not endorse, support, adopt or vouch any views, programs and/or business opportunities posted herein. Proxies-free also does not give and/or offer any investment advice to any members and/or it’s readers. All members and readers are advised to independently consult their own consultants, lawyers and/or families before making any investment and/or business decisions. This forum is merely a place for general discussions. It is hereby agreed by all members and/or readers that Proxies-free is in no way responsible and/or liable for any damages and/or losses suffered by anyone of you.
postgresql – How to update data with a trigger function and a join
I have two relations :
CREATE TABLE relation_a (id_a int PRIMARY KEY, field_1 int);
CREATE TABLE relation_b (id_b int PRIMARY KEY,fk_a int REFERENCES relation_a(id_a), field_1 int);
INSERT INTO relation_a VALUES (1,100), (2,101), (3,102);
INSERT INTO relation_b VALUES (1,1), (2,2), (3,3)
I want to create a trigger which always set :
SET b.field_1 = a.field_1 FROM relation_a a, relation_b b WHERE b.fk_a = a.id_a
I tried something like this :
CREATE OR REPLACE FUNCTION function1() RETURNS trigger AS
$$
BEGIN
UPDATE relation_b as b
SET field_1 = a.field_1
FROM relation_a a
WHERE a.id_a = new.fk_a;
END
$$
LANGUAGE PLPGSQL;
CREATE TRIGGER trigger1
AFTER INSERT OR UPDATE
ON relation_b
FOR EACH ROW EXECUTE PROCEDURE function1();
If i try to insert or update data in relation_b, i got a very long error message i can’t understand :
Can someone explain me the right way ? Thanks a lot
malware – Can a computer/MacBook be compromised/infected/hacker simply be requesting/attempt to join a network?
I was finishing a clean installation of macOS Catalina on my MacBook, and I was asked to select a wifi network. I misclicked on a wifi network with a name that’s very similar to mine and was asked to enter the password, obviously I cancelled it and selected my own network instead.
My question is: Can the act of requesting to join that network put my MacBook at risk? I am especially concern since I was still in the middle of finalizing my macOS Catalina’s setup, I wonder if A. Does Clicking on the wifi network itself and being asked to type in your password gives any information about my system that put it at risk ? B. Can the request itself cause my MacBook to get any virus that may be plaguing the devices on that network? Or if the person who owns the network is malicious, can they compromise my computer that way?
I am considering reinstalling my MacOS again just for safe measure…
amazon web services – Ansible Join two variables
I have two variable definition files as follows
vars.yml
aws_common_tags:
Project: "{{ project_name }}"
Application: "{{ application_name }}"
Region: "{{ aws_region }}"
Ansible: "Yes"
instance.yml
ec2_instance_tags:
environment_name: dev
Now in task.yml I am trying to create aws ec2 instance with all tags but its not working.
ec2:
key_name: "{{ keypair_name }}"
instance_type: "{{ ec2_instance_type }}"
instance_tags: "{{ aws_common_tags + ec2_instance_tags }}"
We are getting the following error:
"tags": {
"Ansible": "Yes",
"Application": "webserver",
"Project": "document_upload",
"Region": "us-west-2"
},
fatal: (localhost): FAILED! => {
"msg": "Unexpected templating type error occurred on ({{ aws_common_tags + ec2_instance_tags }}): unsupported operand type(s) for +: 'dict' and 'dict'" }
Thanks
¿Como simular un join en Firebase entre dos documentos en Angular?
Tengo dos documentos en firebase, uno es usuarios y el otro son publicaciones, entonces en el documento de usuarios están todos los datos de un usuario y en publicaciones sus datos pero con el uid de quien lo publicó, pero no se como simular un join entre dos documentos, ya que quiero hacer un apartado donde se muestren todas las publicaciones y quien las publicó pero no se como hacer para que a partir del uid de publicaciones poder traerme la información de usuarios tal como nombre, correo etc.
Adjunto imagenes
Aqui es donde no me imagino como realizarlo
Y esto es como quisiera que se mostrara, la información de la publicación y el nombre de usuario
