Substring to divide and update a field in the same syntax

Asked Aug 26 '19 at 18:03

Active Aug 26 '19 at 21:15

Viewed 21 times

sorry in advance if my question is already exists.

I'm a sql beginner and have an issue about how can i update a field with 'Select' where one field already exists in the datatable (Table1) and the another field update by the sintax.

Select
Business,
Month,
Opens
From Table2

I would like in the same syntax to be able to do the sends / opens calculation and update the field named 'Open Rate'

example

Today i have the table1 with

Month -- Send -- Opens -- Open Rate

May -- 100 -- --

The table 2 have

Opens - Month

5 -- May

My goal: update the table 1 with the table 2 with the open rate (Send/Opens):

Month -- Send -- Opens -- Open Rate

May -- 100 -- 5 -- 20

edited Aug 26 '19 at 21:15

asked Aug 26 '19 at 18:03

Joao Marano

Possible duplicate of [Insert into ... values ( SELECT ... FROM ... )](https://stackoverflow.com/questions/25969/insert-into-values-select-from) – computercarguy Aug 26 '19 at 18:09
unfortunately i can not use Insert, i need to do it with SELECT. It's a limitation of the software I use – Joao Marano Aug 26 '19 at 18:16
Can you use an `UPDATE` or `MERGE`? https://stackoverflow.com/questions/2334712/how-do-i-update-from-a-select-in-sql-server – computercarguy Aug 26 '19 at 18:18
No. Just the Select :/ – Joao Marano Aug 26 '19 at 18:22
You can't insert, update, or otherwise change a row or data in a DB with using just a `SELECT`, so it unfortunately sounds like you're SOL. What software are you using? It might be a permissions thing or maybe you need an update or an alternate to your software to make this work. – computercarguy Aug 26 '19 at 18:24
What is your expected output? Please post that as text rather than image. – Ankit Bajpai Aug 26 '19 at 19:24
My expect is the field 'Open Rate' is populated. I updated the question. – Joao Marano Aug 26 '19 at 21:12

Substring to divide and update a field in the same syntax

0 Answers0