DECLARE @Demoid INT = - 1;

DECLARE @Recordcount INT = 1;
DECLARE @TotalRecords INT = 0; 
DECLARE @Min BIGINT, @Max BIGINT;

SELECT @Min = 100000, @Max = 10000000;

SELECT TOP (@Max - @Min + 1) @Min - 1 + ROW NUMBER() OVER (ORDER BY t1.number) AS N 
INTO #SequenceNumbersWinthinRange 
FROM MASTER..spt_values t1 
CROSS JOIN MASTER..spt_values t2;

CREATE TABLE #TableRows AS (ID INT IDENTITY(l,1) NOT NULL, DemoId INT NOT NULL); 

INSERT INTO #TableRows (DemoId)
SELECT ID FROM demo;

SET @TotalRecords = @@rowcount; 

WHILE @TotalRecords >= @RecordCount 
BEGIN

SELECT @Demoid = DemoId FROM #TableRows WHERE ID = @RecordCount; 

UPDATE demo
SET Name =(SELECT MIN(N) FROM #SequenceNumbersWinthinRange WHERE N NOT IN (SELECT Name FROM Demo)) 
WHERE ID = @Demoid; 

SELECT @RecordCount = @RecordCount + 1, @Demoid = -1; 
END ; 

fonte: https://stackoverflow.com/questions/21425546/how-to-generate-a-range-of-numbers-between-two-numbers

O exemplo seguinte pode ser executado aqui

DECLARE @strClean as VARCHAR(1000) = 'atuastringaqui';

SELECT LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(REPLACE(@strClean, CHAR(10), CHAR(32)), CHAR(13), CHAR(32)), CHAR(160), CHAR(32)), CHAR(10), CHAR(32))))

COM Exception: The transaction manager has disabled its support for remote/network transactions.

Propriedades de segurança do DTC

Reiniciar o serviço do DTC

%SystemRoot%\system32\msdtc.exe

Exemplo para uma factura

CREATE TABLE Factura
  (
     ID INT,Numero VARCHAR(9),Montantetotal DECIMAL
  );

CREATE TABLE Facturalinha
  (
     ID INT,FacturaID INT,Descricao NVARCHAR(50),Montante DECIMAL
  );

INSERT INTO Factura
VALUES      (1,'002-00509',300.00);

INSERT INTO Facturalinha
VALUES      (1,1,'produto 01',50.00);

INSERT INTO Facturalinha
VALUES      (2,1,'produto 02',30.00);

INSERT INTO Facturalinha
VALUES      (3,1,'produto 03',20.00);

INSERT INTO Facturalinha
VALUES      (4,1,'produto descrição a definir',200.00);

INSERT INTO Factura
VALUES      (2,'003-00595',400.00);

INSERT INTO Facturalinha
VALUES      (1,2,'produto 01',70.00);

INSERT INTO Facturalinha
VALUES      (2,2,'produto 02',30.00);

INSERT INTO Facturalinha
VALUES      (3,2,'produto 03',100.00);

INSERT INTO Facturalinha
VALUES      (4,2,'produto 04',50.00);

INSERT INTO Facturalinha
VALUES      (5,2,'produto 05',150.00);

SELECT f.Numero AS "Factura número"
, ROW_NUMBER() OVER(PARTITION BY fl.FacturaID ORDER BY fl.ID ASC) AS "Linha nº"  
, fl.Descricao AS "Descrição"
, fl.Montante
, SUM(fl.Montante) OVER(PARTITION BY fl.FacturaID ORDER BY fl.ID ASC ROWS UNBOUNDED PRECEDING) AS "Montante acumulado"
, IIF(fl.ID = MAX(fl.ID) OVER (PARTITION BY fl.FacturaID), SUM(fl.Montante) OVER(PARTITION BY fl.FacturaID), 0)  AS "Montante total factura"
, f.MontanteTotal AS "Factura montante total"
FROM   Factura f
       INNER JOIN Facturalinha fl
               ON f.Id = fl.Facturaid 

O SELECT apresenta o seguinte resultado

O aumento da disponibilidade de ferramentas, tecnologia, dados e modelos está a permitir a disseminação de insights para pessoas que normalmente não teriam essa capacidade

Analistas de Dados

Cientistas de Dados

O uso de um sistema de IA sem rosto para realizar dezenas de milhares de entrevistas tem implicações realmente assustadoras para os candidatos.

Este algoritmo tentará reconhecer e medir as complexidades extremas da fala humana, linguagem corporal e expressão, que inevitavelmente terão um efeito prejudicial em candidatos não convencionais.

Como em muitos destes sistemas, a menos que o algoritmo tenha sido treinado com um conjunto de dados extremamente diversificado, há uma probabilidade muito alta de que isso possa sofrer algum tipo de distorção, resultando em candidatos de determinadas origens injustamente excluídos e discriminados

Video YouTube, ROWA Vmax Introduction

A Elevada quantidade de produtos, os espaços cada vez mais reduzidos e os custos elevados de áreas nas grandes cidades, aliados às altas necessidades de gestão dos stocks em tempo real, exigem um novo conceito de armazenamento de alta densidade e de altos níveis de controlo.

-- http://www.sqlmusings.com
USE SUSDB  -- <databasename> statement has been executed first.
GO

SET NOCOUNT ON

-- adapted from "Rebuild or reorganize indexes (with configuration)" from MSDN Books Online 
-- (http://msdn.microsoft.com/en-us/library/ms188917.aspx)
 
-- =======================================================
-- || Configuration variables:
-- || - 10 is an arbitrary decision point at which to
-- || reorganize indexes.
-- || - 30 is an arbitrary decision point at which to
-- || switch from reorganizing, to rebuilding.
-- || - 0 is the default fill factor. Set this to a
-- || a value from 1 to 99, if needed.
-- =======================================================
DECLARE @reorg_frag_thresh   float  SET @reorg_frag_thresh   = 10.0
DECLARE @rebuild_frag_thresh float  SET @rebuild_frag_thresh = 30.0
DECLARE @fill_factor         tinyint SET @fill_factor         = 80
DECLARE @report_only         bit  SET @report_only         = 0

-- added (DS) : page_count_thresh is used to check how many pages the current table uses
DECLARE @page_count_thresh  smallint SET @page_count_thresh   = 1000
 
-- Variables required for processing.
DECLARE @objectid       int
DECLARE @indexid        int
DECLARE @partitioncount bigint
DECLARE @schemaname     nvarchar(130) 
DECLARE @objectname     nvarchar(130) 
DECLARE @indexname      nvarchar(130) 
DECLARE @partitionnum   bigint
DECLARE @partitions     bigint
DECLARE @frag           float
DECLARE @page_count     int
DECLARE @command        nvarchar(4000)
DECLARE @intentions     nvarchar(4000)
DECLARE @table_var      TABLE(
                          objectid     int,
                          indexid      int,
                          partitionnum int,
                          frag         float,
        page_count   int
                        )
 
-- Conditionally select tables and indexes from the
-- sys.dm_db_index_physical_stats function and
-- convert object and index IDs to names.
INSERT INTO
    @table_var
SELECT
    [object_id]                    AS objectid,
    [index_id]                     AS indexid,
    [partition_number]             AS partitionnum,
    [avg_fragmentation_in_percent] AS frag,
 [page_count]       AS page_count
FROM
    sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'LIMITED')
WHERE
    [avg_fragmentation_in_percent] > @reorg_frag_thresh 
 AND
 page_count > @page_count_thresh
 AND
    index_id > 0
 
 
-- Declare the cursor for the list of partitions to be processed.
DECLARE partitions CURSOR FOR
    SELECT * FROM @table_var
 
-- Open the cursor.
OPEN partitions
 
-- Loop through the partitions.
WHILE (1=1) BEGIN
    FETCH NEXT
        FROM partitions
        INTO @objectid, @indexid, @partitionnum, @frag, @page_count
 
    IF @@FETCH_STATUS < 0 BREAK
 
    SELECT
        @objectname = QUOTENAME(o.[name]),
        @schemaname = QUOTENAME(s.[name])
    FROM
        sys.objects AS o WITH (NOLOCK)
        JOIN sys.schemas as s WITH (NOLOCK)
        ON s.[schema_id] = o.[schema_id]
    WHERE
        o.[object_id] = @objectid
 
    SELECT
        @indexname = QUOTENAME([name])
    FROM
        sys.indexes WITH (NOLOCK)
    WHERE
        [object_id] = @objectid AND
        [index_id] = @indexid
 
    SELECT
        @partitioncount = count (*)
    FROM
        sys.partitions WITH (NOLOCK)
    WHERE
        [object_id] = @objectid AND
        [index_id] = @indexid
 
    -- Build the required statement dynamically based on options and index stats.
    SET @intentions =
        @schemaname + N'.' +
        @objectname + N'.' +
        @indexname + N':' + CHAR(13) + CHAR(10)
    SET @intentions =
        REPLACE(SPACE(LEN(@intentions)), ' ', '=') + CHAR(13) + CHAR(10) +
        @intentions
    SET @intentions = @intentions +
        N' FRAGMENTATION: ' + CAST(@frag AS nvarchar) + N'%' + CHAR(13) + CHAR(10) +
        N' PAGE COUNT: '    + CAST(@page_count AS nvarchar) + CHAR(13) + CHAR(10)
 
    IF @frag < @rebuild_frag_thresh BEGIN
        SET @intentions = @intentions +
            N' OPERATION: REORGANIZE' + CHAR(13) + CHAR(10)
        SET @command =
            N'ALTER INDEX ' + @indexname +
            N' ON ' + @schemaname + N'.' + @objectname +
            N' REORGANIZE; ' + 
            N' UPDATE STATISTICS ' + @schemaname + N'.' + @objectname + 
            N' ' + @indexname + ';'

    END
    IF @frag >= @rebuild_frag_thresh BEGIN
        SET @intentions = @intentions +
            N' OPERATION: REBUILD' + CHAR(13) + CHAR(10)
        SET @command =
            N'ALTER INDEX ' + @indexname +
            N' ON ' + @schemaname + N'.' +     @objectname +
            N' REBUILD'
    END
    IF @partitioncount > 1 BEGIN
        SET @intentions = @intentions +
            N' PARTITION: ' + CAST(@partitionnum AS nvarchar(10)) + CHAR(13) + CHAR(10)
        SET @command = @command +
            N' PARTITION=' + CAST(@partitionnum AS nvarchar(10))
    END
    IF @frag >= @rebuild_frag_thresh AND @fill_factor > 0 AND @fill_factor < 100 BEGIN
        SET @intentions = @intentions +
            N' FILL FACTOR: ' + CAST(@fill_factor AS nvarchar) + CHAR(13) + CHAR(10)
        SET @command = @command +
            N' WITH (FILLFACTOR = ' + CAST(@fill_factor AS nvarchar) + ')'
    END
 
    -- Execute determined operation, or report intentions
    IF @report_only = 0 BEGIN
        SET @intentions = @intentions + N' EXECUTING: ' + @command
        PRINT @intentions     
        EXEC (@command)
    END ELSE BEGIN
        PRINT @intentions
    END
 PRINT @command

END
 
-- Close and deallocate the cursor.
CLOSE partitions
DEALLOCATE partitions
 
GO