Easy. Use PARSENAME():

SELECT base_object_name
      ,CONCAT(QUOTENAME(PARSENAME(base_object_name, 3)), '.', QUOTENAME(PARSENAME(base_object_name, 2)))
FROM sys.synonyms;

• This reply was modified 4 years, 1 months ago by Phil Parkin.

Sounds like you need to add a loop to your C# code. Which part of the process are you having trouble with?

When you say that you get half the rows, have you verified that it is the first 50% of the rows in the file? Or perhaps it is skipping rows?

Another...

• This reply was modified 4 years, 1 months ago by Phil Parkin.

Hi

Thanks for the replies

I can run the package from a catalog on the server so I think the path is correct I the package for the server.

There does sound...

This sounds like something SSIS would be good for.

You can avoid that error by modifying your SELECT:

SELECT TOP (100) PERCENT ...

Upgraded from an Access 2010 ADP database, linked my tables, but I can't connect to the server when the main module is loaded.  Can't figure out the change in...

Probably, but how can we write a solution for you if you don't provide DDL, sample data etc?

Phil:

Happy to comply, but I'm not sure I know how to do those things.  I will try to figure it out.

Other sites have controls for these things, which I...

• This reply was modified 4 years, 1 months ago by Phil Parkin.

You've been here long enough to know about

a) Putting T-SQL code in a code block and

b) Providing data in a consumable format (which can be pasted into SSMS)

What results do you get when you run that?

• This reply was modified 4 years, 1 months ago by Phil Parkin.

I don't have time for a full answer, but the ACE driver is a separate install.

Take a look here: https://www.microsoft.com/en-us/download/details.aspx?id=54920

+1, me too.

Sounds like you will be interested in the Query Store.

Please take a look here: https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15

Here are some further ideas and suggestions for you:

1. Rather than using DEFAULT NULL, just define the column as NULLable.
2. There's no need for all those double quotes.
3. It's generally...