Solved

select/update query in same statement

Posted on 2015-01-13
5
87 Views
Last Modified: 2015-01-19
Can anyone help me please,

I have a query where i do the select below, and now i need another query to update the same select fields based on the joining SO_Number...

1st query...

SELECT
      pd.[Material]
      ,pd.[Description]
      ,pd.[Serialised]
      ,pd.[ProductNo]
      ,pd.[PartNo]
  FROM [PartDetail]  pd
  left JOIN [DataLink] ON [DataLink].Material = pd.Material
  WHERE SO_Number='0002424291'

2nd query...(this is what i need to update everything above) so i would be supplying the query with params that match the fields in pd.


Thanks
0
Comment
Question by:razza_b
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 66

Expert Comment

by:Jim Horn
ID: 40547385
Give us a data mockup of what you're trying to pull off here.
0
 
LVL 1

Author Comment

by:razza_b
ID: 40547570
ok so i have 2 tables and one has these fields...

partdetail table (these fields need to be updated based on the SO_Number on table [DataLink])
 -----------------------
[Material]
[Description]
[Serialised]
[ProductNo]
[PartNo]

DataLink table
--------------------
SO_Number

so when i do the select query i bring that back to my app and i change the values and then want to update that same data back again.
hope this helps.
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40548491
Just prefix your existing statement with

UPDATE tabletoupdate
SET fieldname = newvalue

so it continues

SELECT ...

You can test it with starting

BEGIN TRAN

and end with

Select * from updatedtable
ROLLBACK TRAN
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40548840
You want to retrieve data, change some values and update the data, right?
If so, you need to tell us which programming language are you using so we can help you better.
0
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40557433
Why Grade C?
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question