eobiki10 (12/10/2013)
Hi All,Please I need help with this. I am having an error when I try to run a report that contains this code. The error is this "the Select list for the insert statement contains more items than the insert list. The number of select values must match the number of INSERT columns. Incorrect syntax near ','. " I have tried to have E.empl_uno IN (@employee) in the code but still the error persits. Any help will be appreciated.
INSERT INTO [BO_CUSTOM].[dbo].[Property_Coorindators]
([Employee_Uno]
,[Employee_Name]
,[Offc_Code]
,[Email]
Select @employee, employee_name, @Offc, EMAIL
from BO_live3.dbo.HBM_persnl E
where E.empl_uno = @employee
You are missing the closing parenthesis after the column list.
INSERT INTO [BO_CUSTOM].[dbo].[Property_Coorindators]
([Employee_Uno]
,[Employee_Name]
,[Offc_Code]
,[Email])
Select @employee, employee_name, @Offc, EMAIL
from BO_live3.dbo.HBM_persnl E
where E.empl_uno = @employee
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/