Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005
Hello,
I have three table names like inventory, inventory_temp and purchase
 
 create table inventory(id int,productid int,quantity decimal(18,4), disptchtype int)
 
   create table inventory_temp(id int,productid int,quantity decimal(18,4), disptchtype int ,loaded_qnty decimal(18,4))
 
 create table purchase (id int,productid int,loaded_qnty decimal(18,4))
 
insert into inventory values(1,1,1000,1)
insert into inventory values(2,3,2000,1)
insert into inventory values(1,3,3000,2)
insert into inventory values(2,4,4000,2)
 
insert into purchase values(1,1,1200)
insert into purchase values(2,3,2300)
 
insert into inventory_temp(id,productid
quantity,dispatchtype)
select id,productid, quantity,dispatchtype from inventory  
where dispatchtype=1
 
now i want to show table inventory_temp like
 
id-----productid-------quantity------dispatchtype-------loaded_qnty
1---------1-------------1000------------1-----------------1200
2---------3-------------2000------------1-----------------2300
 
but i dont want to use join i want to update my inventory_temp table
how can i do pleas help
Posted 19-Apr-13 20:31pm
Edited 20-Apr-13 0:01am
v4
Comments
gvprabu at 20-Apr-13 4:31am
   
Your Question is not clear... Give some more explanation about your problem.
srishti_ at 20-Apr-13 5:02am
   
This is solution
 
UPDATE inventory_temp
SET loaded_qnty = po.loaded_qnty
FROM purchase as po
WHERE
inventory_temp.id = po.id
Maciej Los at 20-Apr-13 7:01am
   
but i dont want to use join i want to update my inventory_temp table
Why?
Bernhard Hiller at 22-Apr-13 2:46am
   
Instead of a "temporary table", you should better use a View.
srishti_ at 22-Apr-13 2:58am
   
how to use view for this output pleasesend code........

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web04 | 2.8.150129.1 | Last Updated 20 Apr 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100