Posted By: Anonymous I have this table: ————————————— | Id | worker | workStation | amount ————————————— | 1 | John | Suspension | 5 | 2 | John | Wheels | 8 | 3 | Peter | Wheels | 1 | 4 | Peter | Engines | 2 ————————————— And I need a query …
Posted By: Anonymous I have two table which I would like to union. I need to keep only the duplicates from one of the two tables. I tried to find it, but could not find it anywhere. Hope somebody can help. For example: Table_1: ID Product Amount 1 A 10 2 B 10 3 C …
Posted By: Anonymous I’m using SQL Server. I need help to remove a range of rows from Table1 using input values and matching Ids from Table2. Table1 RowId SetId 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 1 1 2 2 2 3 2 4 2 …
Posted By: Anonymous I trying to filter my event table, to do some statistics, and the objective is to exclude events from one object that already has an Event active when that event occur. For example: ObjectId 4 triggered the Event 1, but during the execution of this event it also triggered the Event 2. …
Posted By: Anonymous I have the following example dataset: ID Value Row index (for reference purposes only, does not need to exist in final output) a 4 1 a 7 2 a 12 3 a 12 4 a 13 5 b 1 6 b 2 7 b 3 8 b 4 9 b 5 10 …
Posted By: Anonymous I would know if there’s a way to disable auto-logging using Serilog. I installed it and the sink to handle logging using MSSqlServer. appsettings.json: { "Serilog": { "Using": [ "Serilog.Sinks.MSSqlServer" ], "MinimumLevel": "Information", "WriteTo": [ { "Name": "MSSqlServer", "Args": { "connectionString": "Server=tcp:{ServerAddress};Initial Catalog={DBName};Persist Security Info=False;User ID={Username};Password={Password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;", "sinkOptionsSection": { "tableName": "App_Logs", "autoCreateSqlTable": …
Posted By: Anonymous Hello I am new to Database, How can I share the Database ,its tables along with inserted data that I created using Diagrams. Is there any way I can copy the whole SQL code send it to my project members so they can run it or Is there any other way to …
Posted By: Anonymous I have been struggling with this for hours without any result :(. I have a select string command which finds various strings in the files $sasnrs = @(Select-String -Pattern "SASI.{11}" -path $Temp1 | Select-Object -ExpandProperty Matches) $sassuppcars = @(Select-String -Pattern "TMB………….." -path $Temp1 | select-object -expandproperty Matches) $sasprices = @(Select-String -Pattern ‘[1-2]?.?d{3},d{2}’ …
Posted By: Anonymous Hey, I am trying to update some columns in my table in SQL Server 2014 and I wrote some code on the trigger and to consequently insert the new values into a new table, using the following code procedure: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO — ============================================= — Atrin Noori …
Posted By: Anonymous I’m trying to pivot a SQL Server table whilst also grouping by the date column. This is my example data: date ref count 07/06/21 ref1 20 08/06/21 ref1 2 09/06/21 ref1 15 07/06/21 ref2 54 08/06/21 ref2 23 And how the result needs to be: ref 07/06/21 08/06/21 09/06/21 ref1 20 2 …
Posted By: Anonymous I cannot connect to SQL Server from Visual Studio because the server name contains characters that Visual Studio will not accept. The backslash is causing the problem. I can connect using Microsoft SQL Server Management Studio. I tried installing a second instance of SQL Server on my pc but I cannot give …
Posted By: Anonymous I have got myself in a right pickle with this one and clearly cannot see the wood for the trees! I have a set of values currently returned like this: Based on the value in ContractNumber and ContractSubNumber, for each row with a .1 value I need to retrieve the Fee of …
Posted By: Anonymous I’ve have a table which contains XML data with several nodes in one of the columns. Something similar to the below. <SendWorkOrders xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" creationDateTime="2021-06-05T10:16:09.713+12:00" requestCorrelationId="63cbec24c87a1bfa88999ef373e" xmlns="http://mycompany.co.nz/customerservices/servicepartner/workorder"> <WORKORDERSET> <WORKORDER action="Replace"> <WONUM>123456</WONUM> <DESCRIPTION>My work order</DESCRIPTION> </WORKORDER> </WORKORDERSET> </SendWorkOrders> I want to change the format to something like below in order to use XQUERY …
Posted By: Anonymous I have monthly budget need to distribute to per day Datasource Month Budget Jan 31 Feb 56 I want to smoothen out to Date Budget 01-Jan 1 02-Jan 1 … … 01-Feb 2 02-Feb 2 … … How can I do this? Solution Assuming the month is really a date on the …
Posted By: Anonymous Peculiar issue: I have a table of 140.588 rows and 246,313 MB which looks like this: CREATE TABLE [dbo].[DMA_assessment]( [InstanceName] [varchar](128) NULL, [DatabaseName] [varchar](128) NULL, [SizeMB] [varchar](30) NULL, [ImpactedObjectName] [varchar](128) NULL, [ImpactDetail] [varchar](max) NULL, [AssessmentName] [varchar](128) NULL, [AssessmentNumber] [int] NULL, [SourceCompatibilityLevel] [varchar](15) NULL, [TargetCompatibilityLevel] [varchar](15) NULL, [TargetSQLServerEdition] [varchar](15) NULL, [Category] [varchar](50) NULL, …
Posted By: Anonymous I’m bulk inserting a JSON file into a SQL db once a day. I’m trying to parse the object into 5 different tables, and in doing so, I’m trying to use the SCOPE_IDENTITY() feature to include an ID column that will allow be to join the tables afterwards. However, I’m only getting …
Posted By: Anonymous I am inserting data into SQL Server using C#, with code as shown here, but the name field can be empty. string name; string sqlcommand = "Insert into users values (‘"+name+"’)" I can’t change the code right now, but can change database. So I want the name column to have a default …
Posted By: Anonymous I want to execute the following T-SQL dynamic statement: CREATE PROCEDURE MergeTable @TableName NVARCHAR(max) AS BEGIN DECLARE @MergeStatement NVARCHAR(max) SET @MergeStatement = ‘SELECT Query FROM dbo.QueryMergeDWH WHERE SourceTableName = ‘ + @TableName EXEC sp_executesql @MergeStatement END EXEC MergeTable @TableName = ‘SGPREINVOICE’ However, this gives me the following error: Msg 207, Level 16, …
Posted By: Anonymous I want to modify this column and it doesn’t work in T-SQL: create table logininfo ( ID int primary key , modepasse varchar(10) not null, ) I want to change ID‘s datatype to varchar(20). When I use this command: alter table logininfo alter column ID varchar(10) it doesn’t work. Please help me …
Posted By: Anonymous I have a plan table looking like this : I wanted an SQL that would give me a select for each artikelnr, date, and jahr_kw (calendar week) where if an entry is null, it would take the previous date’s entry. This was given to be this: select distinct artikelnr , datum , …
Posted By: Anonymous I’ve got a unique problem. I’m querying a replicated database table cost_plan_breakdown, and the replication is known to have some duplicates due to issues with deleting records. I’m not the Admin so I’m trying to sidestep these duplicates as efficiently as possible. The table looks like this: sys_id sys_created_on cost_plan breakdown_start_date axr123 …
Posted By: Anonymous I need the following query to return 0 if there is no match: CREATE TABLE #Operations ( Discriminator varchar(40) ); INSERT INTO #Operations VALUES (‘HistoricoCarga’), (‘HistoricoDescarga’) ; SELECT o.Discriminator, CASE WHEN COUNT(*) IS NULL THEN 0 ELSE COUNT(*) END AS Total FROM HistoricosOperacion ho RIGHT JOIN #Operations o ON ho.Discriminator = o.Discriminator …
Posted By: Anonymous Need to get the total count of patients for a given date where all FilledBy value is 0 My Script CREATE TABLE [dbo].[da.CheckListActivity]( [Id] [int] IDENTITY(1,1) NOT NULL, [PatientId] [int] NULL, [ChecklistId] [int] NULL, [FilledBy] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[da.Patient]( [Id] [int] IDENTITY(1,1) NOT NULL, [PatientId] [int] NULL, …
Posted By: Anonymous I’ve got a table: FieldName ValueChar ValueNum ValueBool SubmissionID Color Red NULL NULL 1 CrayonNumber NULL 38 NULL 1 IsToxic NULL NULL TRUE 1 CrayonCreatorName Bob NULL NULL 1 Color Blue NULL NULL 2 CrayonNumber NULL 17 NULL 2 IsToxic NULL NULL FALSE 2 I’d like to create a view that when …
Posted By: Anonymous I have the following T-SQL script that copies the value of an old column into a new one, then drops the old column. See here: –step 1: create new column IF NOT EXISTS(SELECT 1 from sys.columns WHERE Name = N’UserColumn2′ AND Object_ID = Object_ID(N’Account’)) BEGIN ALTER TABLE Account ADD UserColumn2 int null …
Posted By: Anonymous In SQL Server, the following code gives me the date of Sunday last week from whatever date it is today: DECLARE @dt date = GETDATE(); SELECT dateadd(week,datediff(week,6,@dt),6); I need to declare a variable from the date given and make that variable an integer. I have tried things like: DECLARE @last_sunday INT; SELECT …
Posted By: Anonymous I have a stored procedure with a parameter DateTime on ADF, and now I need to convert my parameter as a .JSON file that stored at Blob Storage. My question is, is it possible to use JSON file on Azure Blob Storage ? Because on Azure Data Factory I seen there were …
Posted By: Anonymous The title only explains my first attempt, I couldn’t think how to word the issue/my need exactly. I have table job: CREATE TABLE [dbo].[job] ( [jobId] INT IDENTITY(1,1) PRIMARY KEY, [contractId] INT NOT NULL, [districtId] INT NULL, [address] NVARCHAR (255) NULL ); I’m trying to create a function where all of the …
Posted By: Anonymous I have a sql table which field are qustionid, question, answer, message-type . i am generate dynamic label text through c#. how to compare message-type field value on c# if else condition. my code is- using (SqlConnection con = new SqlConnection(cs)) { string spName = @"dbo.[spUserResponseTest]"; SqlCommand cmd = new SqlCommand(spName, con); …
Posted By: Anonymous Iam trying to find the definition of system stored procedure sp_getapplock (). Can anyone help with this ? Solution Requires membership in the public role. sp_helptext sp_getapplock create procedure sys.sp_getapplock — 1999/04/14 00:00 @Resource nvarchar (255) = NULL, — Resource to lock @LockMode varchar (32), — Lock mode @LockOwner varchar (32) = …
