Insert data from other tables using select query

Submit Blog |

Blogs Home |

Ads

Here is the query to insert other tables data into the existing table in sql server
insert into AdventureWorksDW2008R2.dbo.SafetyStockLevel(productID,safetystocklevel,OrderDate)
(
SELECT distinct p.ProductID, SafetyStockLevel,OrderDate
from dbo.Product p inner join
dbo.SalesOrderDetail SOD
on sod.ProductID = p.ProductID
inner join dbo.SalesOrderHeader SOH
on soh.SalesOrderID=sod.SalesOrderID
)

Cheers,

Venkatesan Prabu .J

Head, KaaShiv InfoTech.

http://www.kaashivinfotech.com/

Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech
http://kaashivinfotech.com/Ebooks.aspx

Found interesting? Add this to:

| More | Bookmark It

More Blogs from Jvprabhusanthi

More ...

About Venkatesan Jayakantham

Experience:	9 year(s)
Home page:	http://www.dotnetfunda.com
Member since:	Tuesday, May 01, 2012
Level:	Starter
Status:	[Member]
Biography:

>> Write Response - Respond to this post and get points

More Blogs
	Writing multi dimensional MDX queries in SSAS Errors in the metadata manager + SSAS error SSIS Error during Project Loading Invalid Object name issue in SQL Server String to color in c# Issue with Datetime in SQL Server and C# code System.IO.Path.Combine to merge file path Handle the DataError event in datagridview Pictorial Representation of SQL Server Submit Blog \| More ...