why is this giving me an error,can anyone help.

Question

INSERT INTO [dbo].[FinalReportSource] (
[Row Id]
,[order id]
,[Order Date]
,[Date]
,[Ship Mode]
,[customer Id]
,[Customer Name]
,[Gender]
,[MaritalStatus]
,[Age]
,[Numberofchildren]
,[Segment]
,[Country]
,[City]
,[State]
,[Postal Code]
,[Region]
,[EmployeeID]
,[Person]
,[Type]
,[Weekly]
,[product Id]
,[Category]
,[SubCategory]
,[ProductName]
,[sales]
,[Quantity]
,[Discount]
)
SELECT [Row Id]
,od.[order id]
,od.[Order Date]
,od.[Date] AS ShipDate
,od.[Ship Mode]
,od.[customer Id]
,cd.[Customer Name]
,pd.[Gender]
,pd.[MaritalStatus]
,pd.[Age]
,pd.[Numberofchildren]
,cd.[Segment]
,cd.[Country]
,cd.[City]
,cd.[State]
,cd.[Postal Code]
,od.[Region]
,wd.[EmployeeID]
,wd.[Person]
,wd.[Type]
,wd.[Weekly]
,dp.[ProductID]
,dp.[Category]
,dp.[SubCategory]
,dp.[ProductName]
,od.[sales]
,od.[Quantity]
,od.[Discount]
SELECT TOP 1 *
FROM [dbo].[weeklyorghierarchydestination] AS WD
JOIN [dbo].[CustomerDestination] AS cd ON wd.Region = cd.[Region]
JOIN [dbo].[PersonalInfoDestination] AS Pd ON cd.[Customer ID] = Pd.[CustomerID]
JOIN [dbo].[orderdetailsDestinations] AS Od ON pd.[CustomerID] = Od.[customer Id]
JOIN [dbo].[Dimproduct] AS Dp ON od.[product Id] = Dp.ProductID

hi i am trying to insert into table finalreportsource from different tables using joins but keep getting this error for all the cols
The multi-part identifier "" could not be bound.
can anyone help please,how can I fix the error

Answer 1

Hi @Laura Ijewere ,

Actually you used two SELECTs in one statement which would cause 'The multi-part identifier "" could not be bound.' error.

Please have a try with below query and let us know if any more error is reported.

INSERT INTO [dbo].[FinalReportSource] (  
[Row Id]  
,[order id]  
,[Order Date]  
,[Date]  
,[Ship Mode]  
,[customer Id]  
,[Customer Name]  
,[Gender]  
,[MaritalStatus]  
,[Age]  
,[Numberofchildren]  
,[Segment]  
,[Country]  
,[City]  
,[State]  
,[Postal Code]  
,[Region]  
,[EmployeeID]  
,[Person]  
,[Type]  
,[Weekly]  
,[product Id]  
,[Category]  
,[SubCategory]  
,[ProductName]  
,[sales]  
,[Quantity]  
,[Discount]  
)  
SELECT top 1 [Row Id]  
,od.[order id]  
,od.[Order Date]  
,od.[Date] AS ShipDate  
,od.[Ship Mode]  
,od.[customer Id]  
,cd.[Customer Name]  
,pd.[Gender]  
,pd.[MaritalStatus]  
,pd.[Age]  
,pd.[Numberofchildren]  
,cd.[Segment]  
,cd.[Country]  
,cd.[City]  
,cd.[State]  
,cd.[Postal Code]  
,od.[Region]  
,wd.[EmployeeID]  
,wd.[Person]  
,wd.[Type]  
,wd.[Weekly]  
,dp.[ProductID]  
,dp.[Category]  
,dp.[SubCategory]  
,dp.[ProductName]  
,od.[sales]  
,od.[Quantity]  
,od.[Discount]  
FROM [dbo].[weeklyorghierarchydestination] AS WD  
JOIN [dbo].[CustomerDestination] AS cd ON wd.Region = cd.[Region]  
JOIN [dbo].[PersonalInfoDestination] AS Pd ON cd.[Customer ID] = Pd.[CustomerID]  
JOIN [dbo].[orderdetailsDestinations] AS Od ON pd.[CustomerID] = Od.[customer Id]  
JOIN [dbo].[Dimproduct] AS Dp ON od.[product Id] = Dp.ProductID  

Best regards
Melissa

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Remove SELECT TOP 1 * and try again.

Answer 3

Does the SELECT work aloe, without the INSERT? If not, please post the exact error message.

Answer 4

So the problem isn't with the insert, it is with the select? And you don't get the error messages that you posted initially?

If the select return 0 rows, then troubleshoot that. 0 rows doesn't produce that error you posted initially, ie when used in an insert.

Answer 5

Hi @Laura Ijewere ,

Please check whether there is any output after running below query:

SELECT top 1 [Row Id]  
 ,od.[order id]  
 ,od.[Order Date]  
 ,od.[Date] AS ShipDate  
 ,od.[Ship Mode]  
 ,od.[customer Id]  
 ,cd.[Customer Name]  
 ,pd.[Gender]  
 ,pd.[MaritalStatus]  
 ,pd.[Age]  
 ,pd.[Numberofchildren]  
 ,cd.[Segment]  
 ,cd.[Country]  
 ,cd.[City]  
 ,cd.[State]  
 ,cd.[Postal Code]  
 ,od.[Region]  
 ,wd.[EmployeeID]  
 ,wd.[Person]  
 ,wd.[Type]  
 ,wd.[Weekly]  
 ,dp.[ProductID]  
 ,dp.[Category]  
 ,dp.[SubCategory]  
 ,dp.[ProductName]  
 ,od.[sales]  
 ,od.[Quantity]  
 ,od.[Discount]  
 FROM [dbo].[weeklyorghierarchydestination] AS WD  
 JOIN [dbo].[CustomerDestination] AS cd ON wd.Region = cd.[Region]  
 JOIN [dbo].[PersonalInfoDestination] AS Pd ON cd.[Customer ID] = Pd.[CustomerID]  
 JOIN [dbo].[orderdetailsDestinations] AS Od ON pd.[CustomerID] = Od.[customer Id]  
 JOIN [dbo].[Dimproduct] AS Dp ON od.[product Id] = Dp.ProductID  

If there is no output, then you need to check the cause. Any data issue? Multiple tables join issue? Any other issue?

Please provide the error message if possible and we could check further.

In your situation , it could be better for you to you post CREATE TABLE statements for your tables together with INSERT statements with sample data, enough to illustrate all angles of the problem. We also need to see the expected result of the sample.

Best regards
Melissa

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.