Implicit conversion from data type datetime to decimal error

[Jeff07]

I am trying to copy a row from table fprecerttemp to fprecert using the code below but receive the error in the title above. For reference all the date fields are datetime2(7)

Any ideas.


Command1.CommandText = "INSERT INTO fprecert " &
"SELECT * FROM fprecerttemp " &
"WHERE FACCT = " & "'" & FAcct & "'"

Try
Command1.ExecuteNonQuery()
Catch SqlExceptionErr As SqlException
MessageBox.Show(SqlExceptionErr.Message)
IsError = True
End Try




ISV using VB.net and SQL Server

Continue reading...