Questions about sql-server-2017
Read more about sql-server-2017
python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
TSQL - Get value between dates in data warehouse dimension
I have the beginnngs of a data warehouse, that contains (among other tables)
date table with 200 years worth of dates to join with, so no need to
build a "dynamic" date table
dbo.Dim_Items ...
Kulstad
Votes: 0
Answers: 1
Why does a merge into a temporal table with a nonclustered index in the history table throw an error
I get the following error when I try to merge under a few conditions. Is someone able to explain why? Seems like it's a problem with SQL Server itself, but I wanted to post it here to confirm.
Attemp...
CSharpFiasco
Votes: 0
Answers: 0
Json to table without explicit key names
I have a table with an VARCHAR(MAX) column which stores JSON key value pairs.
The JSON document schema is simply a different number of key value pairs, no nesting, nor arrays in there.
I wish to build...
Avi
Votes: 0
Answers: 1
Combining table column in SQL Server
I have to combine the Customer_address when they have the same address_index but different line_nbr:
CUSTOMER_NUM
CUSTOMER_CODE
CUSTOMER_ADDRSS
LINE_NBR
ADDRESS_INDEX
ADDRESS_CODE
31
GEW
3901 ...
Sbleezy
Votes: 0
Answers: 1