I have 2 tables, Employee, and Transaction
Transaction
tID
cID
carID
eID
tDate
PickupDate
ReturnDate
Amount_Due
Employee
eID
fName
lName
Job
Manager
Hired
I need to calculate the commission (2.5%) and display that along wit…
I have a flutter app that can create topics and start discussion on that like a WhatsApp group , but without real time update. How can I upload images to the topic like in WhatsApp media ? I want only users have access to that topic A shou…
I am not sure what is the most efficient way to do this, should I be using openrowset to read file to a single varchar(max) column (in the table) and cross appy OPENJSON (something like below), or is there a more efficient way?
SELECT * FR…
I have a short question about a good solution to solve the following problem:
I use angular material date picker to select a date on an application. This date then will be stored in the database. During this process it will be converted to…
I am trying to convert the 10 digit unix timestamp value to proper yyyy-mm-dd hh:mm:ss format using the code in Microsoft SQL server
Update data
set Time_final= dateadd(S,[unix_date], ‘1970-01-01 00:00:00.0’)
from data
But I am not getti…
Is there another way of doing this like a loop or something?
Case
When Date >= ‘4/11/2021’ and Date < ‘4/18/2021’ then ‘WK5’
When Date >= ‘4/4/2021’ and Date < ‘4/11/2021’ then ‘WK4’
When Date >= ‘3/28/2021’ and Date < ‘4…
I am struggling with a mysterious problem:
I have a query in production that dropped his performance dramatically, taking from a few second to two minutes.
By analyzing the execution plan, I found that it inexplicably no longer uses a non-…
I have two strings:
‘one two three’
and
‘two one three’
While they are not the same if I compare them directly the values that they contain separately are the same and this is what it is important for me. So my answer to the comparison wil…
I have a stored procedure that checks if a record exist and if true then should update else it should insert. But for some weird reason the update does not work and it inserts a record. As a result I have now accumulated duplicate records …
I’m new in SQL. I’m trying to insert data into a SQL table. If I insert for the first time it works but if I try to do a new insert I get the error
Violation of UNIQUE KEY constraint.
The unique key constraint is on (uc, start_date). The…
I need your help for this query
The table has the structure
CREATE TABLE produccion
(FECHAEMISION VARCHAR(8),
ALMACEN VARCHAR(10),
ARTICULO VARCHAR(30),
CANTIDAD INT,
DIA INT,
NOMBREDIA VARCHAR(10)
);
And the data is
INSERT INTO…
I have a SQL file which creates a database which I need for my WPF project. However, the only way I know how to build a database is from scratch, but my code actually has the SQL commands which drop the database and then recreate it with t…
declare @delimiter nvarchar(2) = char(10);
declare @objectName sysname = ‘dbo.table_1;
———————————————————————————————–
with CTE as (
select
0 as line_number
, @obje…
I have a stored procedure that can get the number of records in a table, in which the @tableName is the parameter of the stored procedure. Let’s call this proc "FastCount" (I learned this from Brent Ozar’s article)
SELECT OBJECT…
I’m trying to update a table with column aliases using a subselect. The problem is that when I add an inner join, the script breaks:
This update works, but there’s no inner join with the subselect:
declare @erase table
(
id varchar(10),
to…
Please see the below SQL query:
SELECT
SUB_D.[ISO YEAR & WEEK],
SUB_D.[STARTDATE],
SUB_D.[ENDDATE],
SUB_D.[WEEK_NUMBER],
DATEADD (WEEK, SUB_D.[WEEK_NUMBER], SUB_D.[ENDDATE]) AS MATURITYDATE,
(
SELECT
(
…
DECLARE @json NVARCHAR(1000)
SELECT @json = N'{
"Data":
[ {
"OU": "CN",
"SUBCON": 0,
"BRANCH": "tes",
"DEPARTMENT": "SEWING",
"ISSUEDATE": &quo…
Getting the below error when trying to backup databases:
I am able to connect to the shared location on the same server, and I can ping the backup server successfully.
Does anyone know why the backups would be failing.
The Backup job runs…
I have a table in SQL Server that contains a list of all ID migrations overtime. An individual’s ID can change overtime, and this table helps us understand when the change occurs, and what the ID changes from/to. What I’d ultimately like i…
Background Information:
In Python, I might write something like this if I want to apply the same logic to different values in a list.
database_list = ["db_1", "db_2", "db_3"]
for x in range(0,len(database_lis…