I need to get the userID and the marketplace, where the user first bought something. The db looks like this: userID, marketplace, dateOfOrder 74526, Amazon, 2/1/2021 74526, eBay, 1/1/2021 74526, Walmart, 12/10/2021 74525, Amazon, 14/5/2021 74525, eBay, 12/4/2021 74525, Walmart,…
I was given this function CREATE FUNCTION [dbo].[GET_WEBGIS_ISSUE_NUM] () RETURNS VARCHAR(50) AS BEGIN DECLARE @v_new_num int, @v_new_issue_num varchar(50); SET @v_new_num = (SELECT COUNT(*) + 1 FROM [dbo].[WEBGIS_ISSUE] WHERE [ISSUE_NUM] LIKE CONCAT(FORMAT(GETDATE(), 'yyMM'), '%')); IF @v_new_num < 10 SET @v_new_issue_num =…
Suppose I got a csv file like this: field1 field3 0 1 1 2 The corresponding table looks like this: field1 field2 field3 null null null ... ... ... Suppose all the fields are nullable, how could I import the…
The database stores the currency exchange rate on a given day. Each day, one currency exchange value is collected and stored in the database as: ID (int, AI) VALUE DATE 1 2.5 20.01.2021 2 2.7 21.01.2021 3 2.6 22.01.2021 If…
I have a container deploying a WEB API in ASP.NET Core trying to connect to the SQL Server database. I am running Windows 10 with Docker Desktop. I can successfully connect to the Docker container with SQL Server from SQL…
I am trying to download sql back up file but getting error : "Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack" near respone.end() protected void btnDownload_Click(object sender, EventArgs…
I have two related tables, the first called postaDip (IDpostaDip, CODdip, CODposta, from) and the second called cassPosta (IDposta, Desc). I am trying to insert multiple rows into the postaDip table through a listbox that loads the table cassPosta. For…
i have code to read empty row in database, if no row in database then textbox = "0" my code : protected void CheckNota() { string vNota; using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd1 = new SqlCommand("select…
I am working on a project for user administration in ASP.NET Web App (Framework 4.8). In the code have made search box where I want to be able to search for Name,EmployeeNumber and if they are Excluded or not. I…
I have a multi-layered onion architectured asp.net application and currently fasing an issue with POSTing a new entity in a table, which has one-to-many foreign key relation with another table. Here is my parent entity: public class Feature : Entity…