select convert(decimal(9,2),100*(convert(decimal(15,4),24698891))/convert(decimal(15,4),39552506)) Percentage

I like to think of it as...

Emph mine...

ANSI-89 style may have been a standard back in the day, but has long been supplemented. In fact it returns incomplete sets. There used to be a page...

SELECT LEFT(SCHID, x.Pos - 1) [Id],
       REPLACE(SUBSTRING(SCHID, x.Pos + 1, 8000),',','|') [AdditionalIds]
  FROM #X1
 CROSS APPLY(VALUES (CHARINDEX(',', SCHID))) x(Pos)

I think it actually increases fragmentation, because records are typically added in increasing date order rather than decreasing date order.  It improves efficiency, because the index is organised in...

I also notice that you...

I've created some test code, not realistic, but the CTE with SELECT TOP(1) is over ten times faster, though has more logical reads.

set statistics io, time off
set...

Hi Michael, The indexes recommended by SQL Server are not always the best, the index you would need to try is:

CREATE NONCLUSTERED INDEX [IX98_SampleData3]
ON [dbo].[SampleData2] (ACC,[Name],[Ref],[DATE]) INCLUDE...

It also requires two scans of the table and is approximately twice as expensive as a result.  It will always perform...

SELECT [id],
       Stuff((SELECT ',' + [VALUE]
               ...

You could be missing some curly brackets from column form_line1.

Try running this to see if there are any invalid values in column form_line1

select f.form_line1
from s1for_formula f
where f.form_line1...

If you are doing that many databases, wouldn't you be better off generating a script to create them? Then you'd just need one click to create them all.

If you press the left-arrow it goes back to the Databases node.

Here's a method that doesn't use ROW_NUMBER()

;WITH CTE AS
(
    SELECT DISTINCT SD2.Name,
           SD2.ref
 ...

In my experience, the size of the backup is reduced to about 1/6 that of a non-compressed backup.

It does, of course, depend on the contents of your database. If you...