Hi,
I'm using SQL server and I'm trying to create a script to update my table if row exists, else insert into that table.
Let's call the table I want to add rows into SALES and my other PROJECT
Will always be a one-one relationship.
If a new project comes in, I want to create a SQL statement that checks if that project exists, if it does it should update a few columns of my sales table, but if it does...
SQLrookie01
Last Activity: Feb 18 '21, 10:24 AM
Joined: Feb 17 '21
Location:
-
SQLrookie01 started a topic Update if row exists otherwise add row from another table if equal to statusin SQL ServerUpdate if row exists otherwise add row from another table if equal to status
No activity results to display