...

He hasn't quite figured out how to tell us when he needs to go potty, so all we can do is get him seated on it until he goes....

Thanks Rod.

At the risk of turning this...

We had a cruise booked.  Then came a hard lock-down, so our cruise was cancelled.

We are confined to our homes - Only allowed to go out to purchase groceries or...

CREATE TABLE [dbo].[A]([DatabaseName] [nvarchar](1000) NULL, [DBSize] [nvarchar](1000) NULL) 
insert into A values (DatabaseA , 580960.00 MB)
insert into A values(DatabaseB, 23523.00 GB)
insert into A values(DatabaseC,234.00 KB)

Table values:

DatabaseA   580960.00...

You are going to have to check the joins.  Without knowing your tables and data, I have attempted to change the joins, so that I can add the OUTER APPLY...

Please see the code below.

Which tables contain the fields countryCode and site_id ?

  FROM    dbo.
        ,...

Help us out by providing the source table name for each field in the WHERE clause

So, what is the name of the view?

Do you really have a table or view name dbo?

The structure of yor SQL does not make sense to me.  Is this for SQL Server, or some other flavour of SQL?

You could keep the function, but change it to an inline TVF, like this

CREATE FUNCTION dbo.Stringmultitypes ( @id int )
RETURNS table
AS
  RETURN SELECT Types = CAST(STUFF((
...

If the source and destination tables are the same structure, you can swap out the partitions

Are you truly still using SQL 7 or SQL 2000?

Is there a way to specify a column name for the IN section of code to keep it dynamic? Otherwise, every time there is a new value in the...

SELECT
acc
, COUNT(*) AS numOfAcc
, COUNT(DISTINCT token) AS numOfTokenPerAcc
FROM 
dbo.Test1
GROUP BY acc

Based on your sample data, this returns the same result.

WITH cteData AS (
  SELECT      t.tid, t.b, t.E, seq.st, seq.nd
  FROM...