I am trying to insert into a table but its giving me an error message and I dont know how to deal with it.
the columns in the destination are as per attached
word is a string containing one wordof nvarchar(50)
MyDateTime is the date and time
the primary key is made up of the word and datetime.
Msg 241, Level 16, State 1, Line 3
Conversion failed when converting date and/or time from character string.
insert into TblCurrentWords (Word_ID, Word, MyDateTimeCol)
select Word + GETDATE() AS CurrentDateTime, word, GETDATE() AS MyDateTimeCol
where word is not null and PATINDEX('%[0-9]%',Word)=0
group by word
order by word