You need to physically move the files from the old drive to the new drive. SQL will not do this for you.

So when you have done the ALTER ......

Hi.  Is someone able to help me with this?  Thank you

..

• This reply was modified 9 months, 3 weeks ago by water490.
• This reply was modified 9 months, 3 weeks ago by water490.
• This reply was modified 9 months, 3 weeks ago by water490.

SELECT T1.UNIT,
       T1.DATE,
       CASE WHEN COUNT(T1.PRICE) OVER (PARTITION BY T1.UNIT ORDER BY T1.DATE ROWS...

  It works.  Thank you so...

1. I hope you are not using floats for prices! 2. Do you really use reserved names for columns? 3. Are you really writing new code with the depreciated...

Hi

Is anyone able to help me with this?

Thank you

Thank you for the prompt reply.

Thank you both!

I actually run the SSIS package within VS so I can monitor it for any issues so I am watching those black screens pop up.

I added a clustered index on the two fields.  The run time for my SSIS package went UP by about 30 minutes vs having no index on the table.  That...

If the symbol and trade_date form a unique pair in the entire table, make that combination the Clustered Primary Key.  Leave this clustered index on the table at all...

Not quite the same result but has all the info:

SELECT *
  FROM #STOCKS1 AS T1 
  FULL JOIN #STOCKS2 AS T2 
  ...

Maybe?:

SELECT SYMBOL1, SYMBOL2
FROM (
    SELECT SYMBOL1, ROW_NUMBER() OVER(ORDER BY SYMBOL1) AS row_num_1
    FROM #STOCKS1 S1
    WHERE NOT...

I made a bit of progress.  The format doesn't quite match the desired outcome.  What can I do to fix it so it does match the desired outcome?

            
November 14, 2024 at 5:57 am
            
#4481479