... creating new database and porting it's table structures ...

Why would you even consider this, when you have BACKUP/RESTORE as the obvious alternative?

Does this 'system' already have its own database? What is the reason for this migration and why are you considering throwing away the existing database?

As the data in the 'system'...

OK, no idea what's going on here. Stored procedures get executed, not pulled.

If your application worked fine on one server but not the second, I'd suspect either a configuration error...

Please explain what you mean by "... unable to pull into application ...".

Which application? What do you mean by "pull"?

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

What is the purpose of this CLR and how does it relate to SQL Server?

If you know the folder path in advance, you can simply remove it to get the file name:

DECLARE @BackupFilePath VARCHAR(300) = 'E:\Backup\Server1\Database1\Database1_131983519013.bak';

SELECT
    @BackupFilePath
, ...

Bolting them all together at the end sounds clean enough to me – also makes it easier to maintain when things change (adding or removing files, changing file order etc)

I don't know the answer.

But keeping the compatibility level unchanged does not imply that the CHECKDB process will also be unchanged. Perhaps the checks have become more thorough and therefore...

Is this the sort of thing you are after?

--Set up test data
DROP TABLE IF EXISTS #CatTable;

CREATE TABLE #CatTable (Id INT, Category INT, CategoryDate DATE);

INSERT #CatTable (Id, Category,...

I've decided to get back to using week, which treats week 1 of 2021 as a week with one working day only, like it should be

So are you stating that the...

How to put this information in a single row showing id,firstname,lastname, address1,postcode1,address2,postcode2,email1,email2,First Family(flag), Second family(x)? If there is no second address it should show just one address.

What do First Family(flag)...

Are you talking about modifying the existing data, or adding new rows of data, to achieve this? Out of interest, can you explain why you would want to do this?

Either...

OK, try this (I used a temp table, so you need to rename #vehicles accordingly)

SELECT
    model
,   engine_size
,   MN.model_cnt
,  ...

I'm not familiar with Query Builder. Can it use temp tables or subqueries?

I can probably help. But you need to help explain, in English, how your desired results are to be obtained.

In your sample data, for example, the FIESTA has multiple engine...