I have to ask - why are you not deploying to a catalog?  That would solve all of your questions and issues.

If you must deploy to the file system, then...

Jeffrey Williams - to answer your questions its a query which is getting pulled into tableau and the tableau analysts i work with asked for it to be corrected...

The question not asked is why do you want to do this?  What application is going to consume this data - is it for a report, exporting to Excel, exporting...

Nothing wrong with using xp_cmdshell - except security. And no, I don't mean running xp_cmdshell safely - I mean the context of the user running it. Since this...

My answer would be, what's wrong with an Agent Step that uses xp_CmdShell to do this?  It's easily scheduled, etc, etc.

But, shifting gears a bit, doing this from ANYWHERE...

As I stated on the other forum - why not use the appropriate subsystem in SQL Server Agent to run the commands directly?  Why is it necessary to use a...

Have you looked at this: https://learn.microsoft.com/en-us/sql/database-engine/install-windows/prepare-for-upgrade-by-running-data-migration-assistant?view=sql-server-ver16

Thanks. I agree with you. But this is read only copy used for reporting. We are looking for other ways to improve performance by adding more memory but also...

Thank you for the feedback - if converting to a stored procedure then you want to determine what parameter(s) to pass to the procedure.  It would depend on the usage...

There are several ways to approach this - one way is to have separate scripts and you just pick the one you want.  So one will be current month to...

I am not sure I understand your question - I think you are asking if you wanted to get the data for the day prior to the last day of...

• This reply was modified 3 years ago by Jeffrey Williams.

Since the query is already filtered by year/month and specific days - there is no reason to include them in the results.  If you do want to include them, then...

I was trying to follow this - and it seems to have gone in different directions.  It seems you want to define the DAY for the end of the month...

It might be a better option - if using TRY/CATCH - to THROW the error instead of using RAISERROR.

Another way to visualize this:

  WITH racesIn2009
    AS (
SELECT *
  FROM dbo.races
 WHERE race_year = 2009
      ...