This won't fix the issue, but your query can be written more tidily as

SELECT TOP (1) logdate
      ,runnum
    ...

• This reply was modified 3 years, 5 months ago by Phil Parkin.

I'm sure that someone here would be able to help you, if you were able to provide sample data (in consumable form, ready for cut & paste into SSMS –...

Did you replace dbo.table_name with...

Why is only one of the rows updated to include an asterisk in your example? What is special about that row?

If there was a row of data for department 0002...

1 million rows of data in a text file should load OK. Are you sure that the error you are receiving is as a result of file size and not...

You start off with a param called @StudentId, which then becomes '@@@StudentId' in your query. Why are you doing that?

Also, if your param is declared as VARCHAR(500), why are you...

In Object Explorer, right click on any table and select 'View Dependencies'

You did not respond to my previous post. Did my query work how you intended? Some feedback would have been polite.

But if it did, this version may give you what...

• This reply was modified 3 years, 5 months ago by Phil Parkin.

Not that it helps, but 18.12.1 is the current SSMS version, and the upgrade from the previous version did take longer than I expected.

If you are hoping to get this information by querying the ReportServer database, I think you are going to be disappointed. The connection string information is encrypted, with no supported...

Oops, time for more coffee.

I took "I need to update my sql script...

There is no question!

Your suggested query should use UNION ALL rather than UNION (which applies an unwanted (in this case) 'DISTINCT' to the results returned). Only 'read' access is required for this query.

However,...

M can do it, but if you have hundreds of thousands of rows of data, it will take a while.

Are you just looking for help with the necessary M syntax?