Comments by Chris Slinko

Chris Slinko 28-Sep-20 10:25am View

I exported the table to excel and I copied the name saledate_mmddyyyy and that seemed to work. Now I get the error message Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.VISION_SALEHIST'. When I double click on the error it highlights the UPDATE VISION_SALEHIST.

Chris Slinko 25-Aug-20 13:32pm View

Thanks I just tryed it an it did work this is the error message that I got. "Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string."

I just want to copy and past. Copy the data from salesdate_mmddyyyy and paste it into the column named SALEDATE. I guess I didn't get the right sytax for the query to work.

Chris Slinko 20-Aug-20 15:21pm View

I'm not sure what you mean by "checking for SALEDATE not null, but the converted string equivalent be". I'm new to sql with no formal training. I was copying coding that I though might work. I did try the 2 query and I got an error message "Msg 156, Level 15, State 1, Line 3Incorrect syntax near the keyword 'FROM'." when I clicked on it refered to the line "FROM VISION_SALEHIST4".

Comments by Chris Slinko (Top 3 by date)