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
LVL 1
SolugaAsked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.