If this was 2017, I'd use STRING_AGG() to do this, but as we're in a 2016 forum, FOR XML PATH will have to do:

SELECT p.ContainerID
  ...

Not much consolation, but it's always been like that: VS comes out first, followed, often many months later, by the SS*S development toolset.

I suggest you revert to VS2019 for now,...

I am not seeing a Power BI forum on this group. Is there one and I'm just missing it?

One of our Devs has a question. He's trying to get...

SELECT base_object_name
      ,DBName = PARSENAME(base_object_name, 3)
      ,SchemaName = PARSENAME(base_object_name, 2)
      ,ObjectName =...

Sure. Something like this (untested) should do it:

            for (int i = 1; i <= 632;...

Please explain why it's "not really the solution".

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, 2 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, 2 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, 2 months ago by Phil Parkin.