Help with a column

[NickMalloy]

I have the following query where the inner select is creating an error saying "Syntax error converting the varchar value 'January ' to a column of data type int.
How can I fix this??

Select
title,
story,
startdate,
enddate,
(select monthName from tblMonths where datepart(month, tblArticles.startdate) = tblMonths.monthNumber) as monthName,
url,
islink
from tblArticles

 

[gmmastros]

Try changing...

datepart(month, tblArticles.startdate)

To...
Month(tblArticles.startdate)



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[rac2]

What is the datatype of tblArticles.startdate?

 

[NickMalloy]

smalldatetime

I made the change like above and I am still recieving the same error

 

[NickMalloy]

Fixed it. Data was in the wrong place in tblMonths.