• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 415
  • Last Modified:

SQL Insert with Select

Hi,

I have the code below

 
INSERT INTO tbl_M05_OnlineCoursePagesPublished
			(PublishedOnlineCourseId, OnlineCoursePageID,  OnlineCoursePublishedPageName, 
			 OnlineCoursePublishedPageContent, OnlineCoursePageRusReq, OnlineCoursePublishedPageDescription) 
			VALUES (@PublishedOnlineCourseReturnID, (SELECT ContentId, ContentName, HTMLContent, ContentRus, ContentDescription FROM #tblTempContent))

Open in new window


But I keep getting the errors below.....

Msg 116, Level 16, State 1, Line 42
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
Msg 109, Level 15, State 1, Line 39
There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

Would be grateful for any help.

Thanks
0
Soluga
Asked:
Soluga
  • 3
  • 2
1 Solution
 
EyalCommented:
INSERT INTO tbl_M05_OnlineCoursePagesPublished
                  (PublishedOnlineCourseId, OnlineCoursePageID,  OnlineCoursePublishedPageName,
                   OnlineCoursePublishedPageContent, OnlineCoursePageRusReq, OnlineCoursePublishedPageDescription)
SELECT @PublishedOnlineCourseReturnID, ContentId, ContentName, HTMLContent, ContentRus, ContentDescription FROM #tblTempContent)
0
 
EyalCommented:
INSERT INTO tbl_M05_OnlineCoursePagesPublished
                  (PublishedOnlineCourseId, OnlineCoursePageID,  OnlineCoursePublishedPageName,
                   OnlineCoursePublishedPageContent, OnlineCoursePageRusReq, OnlineCoursePublishedPageDescription)
SELECT @PublishedOnlineCourseReturnID, ContentId, ContentName, HTMLContent, ContentRus, ContentDescription FROM #tblTempContent
0
 
SolugaAuthor Commented:
@PublishedOnlineCourseReturnID is not in #tblTempContent, it is declared and then set a value.
0
 
EyalCommented:
I know, it will work
0
 
SolugaAuthor Commented:
Well flipping eck!

That's great.

Cheers
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now