Error - View Single Post - SQL Query when inserting data from one database to another.

**Anilrgowda** · 22-Oct-2007, 12:38 AM

INSERT INTO DataSocial_DW.dbo.DimReason(ReasonNameTemp,ReasonName)
SELECT Distinct Reason as ReasonNameTemp, isnull(Reason,'Not Supplied') as ReasonName
FROM [SalesForce].[dbo].[Case]
ORDER BY isnull(Reason,'Not Supplied')

22-Oct-2007, 12:38 AM	#2 (permalink)
Anilrgowda Administrator Posts: 18,715 Join Date: Jan 2006 Rep Power: 10 IM:	Re: SQL Query when inserting data from one database to another. INSERT INTO DataSocial_DW.dbo.DimReason(ReasonNameTemp,ReasonName) SELECT Distinct Reason as ReasonNameTemp, isnull(Reason,'Not Supplied') as ReasonName FROM [SalesForce].[dbo].[Case] ORDER BY isnull(Reason,'Not Supplied') ------------------