I figured out the problem:

SELECT *, convert(datetime, convert(char(26), ''' + @RECORD_ADD_DT + ''', 121) , 121) AS TIME_STAMP
FROM #TEMP_TABLE'

The "" were in the wrong spot.

The time stamp...

thank you everyone.  I am getting error when I update the dynamic sql.  see below.  Any idea on what is wrong?

Good answer, makes complete sense, thanks for taking the time to write it out.

There are a couple of points I'd like to mention, however.

First is that SFTP is completely...

Taking a step back for a moment ...

It seems that you are running an SSIS package which calls a proc which runs BULK INSERT – a rather convoluted design....

• This reply was modified 2 years, 6 months ago by water490.

I am getting this error.  How do I fix it?

(573 rows affected)
Msg 468, Level 16, State 9, Line 14
Cannot resolve the collation conflict between "Latin1_General_CI_AS"...

• This reply was modified 2 years, 6 months ago by water490.

drop table if exists #trades;
go
create table #trades(
  underlying_symbol         varchar(10) not null,
  trade_date    ...

Thank you both.  The query works now.

thank you for this.

I am a rookie so excuse the ignorance.  I need to re-calculate the index after a certain calculation is done.   I thought that using the script...

for some reason the spacing for some of the lines are messed up.  the words are missing spaces between them.  hopefully this isn't an issue for anyone

If I do that then I get an...

Intellisense telling you it thinks there is an error isn't the same as having an error.

so do you GET an error when you execute the code?

does the index not...

You cannot do INCLUDEs on Clustered Indexes, period.  The reason why is that the Clustered Index IS the table and it already includes all the data.

I posted a link...

• This reply was modified 2 years, 6 months ago by water490.

Hi everyone

I had a bit of time to work on my side project.  I am getting "Cannot specify included columns for a clustered index" error.

Here is my script:

This reply was modified 2 years, 6 months ago by water490.