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)

Questions - sql-server

80 Postgres databases in Azure Data Factory to copy into

I'm using Azure Data factory, I'm using SQLServer as source and Postgres as target. Goal is to copy 30 tables from SQLServer, with transformation, to 30 tables in Postgres. Hard part is I have 80 data...
test-img

BobL

sql-server

postgresql

azure-data-factory

parameterization

Votes: 0

Answers: 1

Latest Answer

There is simple way to implement this. Essentially you need to have a single Linked Service, which reads the connection string out of KeyVault. You can then parameterize source and target as keyvault ...
test-img

Cninroh

SQL - Finding any part of a long string inside a column in a SQL table

I have a long string variable (e.g. 123456WALMARTabcdefghi 67815622 \\). I have a table with two columns, AccountNum and Account Name. Account Name contains 'Walmart' as one of the values. The Accou...
test-img

HurricaneCoffee

sql

sql-server

Votes: 0

Answers: 1

Latest Answer

DECLARE @WANTED AS VARCHAR(50) SET @WANTED = "Walmart" IF CHARINDEX(@WANTED,@yourVariable) > 0 begin SELECT AccountNum FROM table WHERE AccountName = @WANTED end else select 'Not ...
test-img

Michal Sevcik

Is it possible to calculate the total sum within partition and cumulative sum between partitions?

I am interested in calculating a descending cumulative sum based on groups, however, I want the cumulative sum to be based on the grouping. In other words, I want the total sum within a group and cumu...
test-img

nwaldo

sql

sql-server

tsql

teradata

Votes: 0

Answers: 3

Latest Answer

It's possible. No partition in the SUM OVER, just an order by group_id. select * , [CumSum] = sum(value) over(order by group_id desc) from data order by group_id desc; group_id value CumSum ...
test-img

LukStorms

Convert JSON value in SQL table to multiple columns

One of my SQL table has two columns in the below format. Column "Parameters" in JSON Format Value Parameters 999-99-9999 {"A":null,"B":"dfsnl","C&q...
test-img

NIVEA

sql

json

sql-server

Votes: 0

Answers: 1

Latest Answer

Use openjson to turn the JSON into a set of rows and columns. By default this will make a row for each key/value pair. If you want one row with named columns, use with and give it a schema and JSON qu...
test-img

Schwern

Posts

Questions

Blogs

Jobs