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)
I have a database backup from a client. This database has a SP that I am trying to execute. I am getting the following message: Msg 7202, Level 11, State 2, Pr
For example: SELECT DATEADD(month, 2, '2017/08/25') AS DateAdd; I think it would be more sense to define argument as a specificed data type s
i am accessing my website from another computer in same network. before when i was using localhost on same pc website was working fine when i chnaged that to IP
Using SQL Server 2016 and latest SSMS, I'm trying to take a csv string and split it and then insert into table-value parameter variable and I'm getting error sq
I have a fake table: CREATE TABLE #FAKEAddress ( AddressLin01 varchar(100)) INSERT INTO #FAKEAddress VALUES ('123 FAKE ROAD'), ('79 59th ROAD'), ('7890 COUNTY
I have a narrow table containing unique key and source data Unique_Key System 1 IT 1 ACCOUNTS 1 PAYROLL 2 IT 2 PAYROLL 3 IT 4 HR 5 PAYROLL I want to be able t
elasticsearch-spark