I have 2 tables, one main table and one audit table. create sequence dbo.users_seq; create table dbo.users ( id bigint primary key default(next value for dbo.
I am looking to perform a query that will calculate the product revenue percentage difference from 2019 to 2020 for each state. Can anyone lead me in the right
We have worked with Oracle for a number of years and we now need to develop a new application using SQL Server in AWS for the first time. What surprised us, is
I have created a ValueObject called Discount as below: public class Discount:ValueObject { public int Value { get; } public DiscountUnit Unit
I am new to databases and SQL and I am stuck with this problem. Any help would be apriciated. Thank you in advance. I have the following schema: The problem is
I have read a lot of posts about SQL Server, C# and read out of the databases. I have two topics I would found a solution for: I read an registration template w
In My DB i have type cast the values varchar to decimal(18,2) and in my api i gave decimal datatype of output parameter then the error is getting. select max(ca
I am trying to figure out where my query is failing on a where clause, I hope some of the local experts could point it out and explain why. Also I would like to
I am using the spark dataframe reader to pull data from an SQL server database, do some minor changes like column renaming, data type casting and saving the dat
I have the following table that is comparing two similar tables: Source Part Info 1 Info 2 ... Info 12 Description Color Table 1 Wheel Circle ... Long Distanc
Employee_table Id FirstName LastName Division 1 John Smith A 2 Emily Jones B 3 John Smith B 4 John Snow A 5 John Smith C I want to move all duplicate names fr
I am trying to use the odbc driver to transfer data from a sql 2014 table to a snowflake table using SSIS. Both tables have an identical structure. I have a MD
Is there a way to "ping" an SQL Server instance via System.Data.SqlClient to see if it's online and ready to accept queries? The simple code below can be used t
Since Day X (which is inconveniently just outside my DB recovery plan), I have been experiencing a significant performance degredation on an o
I have some comboboxes and textboxes as search filter. Is it possible to keep some filters empty and get search result against selected / entered text? If someo
When I use the CONVERT(VARCHAR(200), Field) to extract the first 200 characters of a varchar(max) field, SQL show me a warning on the select operator on the exe
I have a table in SQL SERVER as below with many columns like below | D401 | D402 | |----------------------------
I have 2 tables with entries as: Transition table: From_Status_Id To_Status_Id PU_Id 5 1 868 5
I have data like this Id Revision_Id A_Id A_Name A_Info ================================================ 1 0 111 A1 A
I have a table like this I would like to select the Itemid that occurs more than once with a different Rate with group by Masterid The output should be somethi