My web app architecture for user access separated in two ways:- Manager Table (column: privilege) Employee Table (column: privilege, permission) Where Manager is a Super-Admin account which will be used to subscribe our service based on package type(eg: basic, silver, gold). For Employee, this acc will be cre…
Get data based on condition in oracle sql
My table loads(Unique) Value T123 11 T234 9.5 T456 15 T678 35 T345 3.7 Want I want count(values<=10) …
SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint “FK_Register_Event”
I have three tables in SQL server; Event table: CREATE TABLE [dbo].[Event] ( [EventName] VARCHAR(25) NOT NULL, [Description] VARCHAR(60) NULL, [Location] VARCHAR(20) NULL, […
C# DatagridView fill with class SingleResponsibility
Hi StackOverflow members, I decided to build a library project to improve myself. I created a class to code Book Operations but i couldn’t find out how to fill datagrid via class method. When i text …
How to count multiple columns in SQL (Oracle) with criteria?
I’m working on SMS-Gateway that holds multiple charged SMS-services with different numbers, each SMS sent to the customer has 4 status as below (forwarded, delivered, expired,delivery failed) Now I have the below first_table for the charging-system with the below details (TABLE-A) and below (TABLE-B) wh…
SQL Query to find top 5 cumulative tweets
How to find the top 5 months with the highest number of cumulative tweets and sort it according to the number of tweets of each month. Table twitter structure is like this: Token type Month …
How to reproduce the behavior of SQL NVARCHAR in Python when generating a SHA-512 hash?
I have the following SQL query SELECT CONVERT(VARCHAR(254), HASHBYTES(‘SHA2_512’, CONVERT(NVARCHAR(24), ‘2020-05-27 00:00:00.000’, 127)), 2) that generates the hash value …
multidimensional “WHERE IN” condition?
As is well-known, we can simplify as follows: Is there a similar shortcut possible for “multidimensional” conditions as in the following: in a form resembling something like this ? I would be willing to count anything as a simplification that uses O(n) characters where the factor is significantly …
How to update “row number” column values 1..N after rows are DELETED?
I have this table: When I make a delete of a box in this table, I need to make an increment of all the following rows. For example: if I delete BoxNo ‘4’ then the rows which are after the last row of BoxNo ‘4’ (5,6,7,..etc) have to make an increment by 1 and be like (4,5,6,…etc.)…
Pivot some row values to a columns
I am trying to pivot some row values to a column, below is what I am trying to achieve. My Current Schema: This is what I am trying to achieve: but it skips rows when name and lan have similar values, in this case it skips the row with the name value vsp. Answer this fixes my problem.