I made a code allowing me to GET data from an API and insert it into a database. But I encounter a problem my api contains about 20 million data and to insert e
After adding SID to the TRANSACTIONS table, I need to update SID column in TRANSACTIONS based off STORE_NBR in the STORES table. Basically, I want to update the
Environment: Windows 2016 Server Standard PowerShell 5 Has Internet connection Running PowerShell as administrator JFrog is something new we're implementing but
A data file is imported to a SQL Server table. One of the columns in data file is of text data type with values in this column to be integers only. The correspo
I have to add a leading 0 in a column called houses, where it is a unique list of 3 digits, but I wanted have to add a leading 0 to it -->
A data file is imported to a SQL Server table. One of the columns in data file is of text data type with values in this column to be integers only. The correspo
I have following table: Id HieararchyId Name 1 / MHz 2 /1/ Finance 3 /1/ IT 4 /1/3/ Software Development 5 /1/3/ QA 6 /1/2/ Accountant and I want to get data
I have following table: Id HieararchyId Name 1 / MHz 2 /1/ Finance 3 /1/ IT 4 /1/3/ Software Development 5 /1/3/ QA 6 /1/2/ Accountant and I want to get data
Using the SalesOrderHeader and SalesTerritory tables, write a query to calculate the number of transactions and total monthly amount per territory for each of
i have a table called "main" which has 4 columns, ID, name, DateID and Sign. i want to create a query that will delete entries in this table if there is the sa
From a stock transaction table I've created following sorted view table to be ready for FIFO: rowN date_ stockCode sign_ amount unitPrice 1 '2022-01-20' ABC in
Multi select option list image I Use a multi select option list and create a save button. write a query like that is INSERT and UPDATE same action occur on sing
Create function getallWeekDayorWeekends ( @givenDate as date, @choice as int ) RETURNS Table as BEGIN if(@choice = 1) return (SELECT cast(DATEADD(DA
I am running a mcr.microsoft.com/mssql/server docker container for local development that works perfectly on one machine. But on my laptop the container is some
How primary key in one table connect to another table with the same primary key? I am trying to make it like this, which those two primary key in the table of C
I want to count the employees, by state and UF, but when I run my code it counts by department: CREATE PROCEDURE SP_DATA_MART_CARGA AS IF NOT EXISTS(SELECT *
I want to set local variables or pass parameters from Excel to SQL. I've found similar questions, but all referred to old versions of Excel and/or the answers s
I'm having issue in saving a PDF file in SQL Server database using stored procedure in Golang. Below is the code. tsql := fmt.Sprintf("DECLARE @tmp varbinary(ma
I'm trying to connect my local database with online database. I've followed the full procedure but Database Sync Group is showing a log error of following type
Please check my query and let me know what to do to get the proper result as expected - query: With ChemReq (AmdCode, ItemCode, itemcode1, D1K,D2K,D3K,D1,D2,D3)