Because I have one product whose code is common for all projects which come to us, so we have to keep one database for one project.

and now we want...

There are lots of sites showing the holidays (here, for example). Are you looking for something special?

Phil, yes my ERP has the PK/FK information but D365 generates new ones when creating its records (my ones get saved into a separate field for reference). I think...

Presumably your ERP already has the relevant PK/FK information in it, so why can't you just use that? Or are you generating new keys as part of the migration?

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, 2 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, 3 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.