Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SO_20171230_SqlServer
CREATE TABLE #Vendas ( VendaID INT IDENTITY(1, 1), EmpresaID INT, ProdutoID INT, Quantidade INT, DataVenda DATE, --Nova coluna com ID de venda por empresa EmpresaVendaID INT, ); --Carregar alguns registos na tabela INSERT INTO #Vendas(EmpresaID, ProdutoID, Quantidade, DataVenda)VALUES (1, 1, 2, '2017-01-01'), (1, 2, 2, '2017-02-01'), (1, 2, 3, '2017-03-01'), (1, 1, 5, '2017-04-01'), (2, 1, 5, '2017-01-01'), (2, 1, 4, '2017-02-01'); SELECT * FROM #Vendas; UPDATE Vd SET EmpresaVendaID = Seq.Sequencia FROM #Vendas Vd INNER JOIN ( SELECT VendaID, ROW_NUMBER() OVER (PARTITION BY EmpresaID ORDER BY VendaID) Sequencia FROM #Vendas ) Seq ON Seq.VendaID = Vd.VendaID ; SELECT * FROM #Vendas;
run
|
edit
|
history
|
help
0
Rank group by
test
SQL Test
SCHOOL-BUILD
aa
n sei o nome (30.10)
ms sql - update/insert - date concatenation
BRYAN_BD1
Add JSON"Valuetypes to XML Nodes using SQL
SQL HW 1 Appline