I have a problem I am a project worker vb.net 2015 with sql After I cleared the project and tried the project at the client An error appears when the reports are shown by the crystal Report whereas mserver = server mdb = the name of the database muser = username sql mpass = sql password They are retrieved fro…
How to retrieve single record for a column based on SQL Server CASE statement
I am trying to write a SQL Server CASE statement to retrieve a student’s category based on the following condition. If the category column from the student_category table has both values ‘X’ and ‘Y’ for a student_id value from the student table, then only display the record where…
I have the following XML and i need to store it in a sql table [closed]
i need the tags ServerName, DBName, UserName, RoleName. I can not access to these tags, because the first part of the xml is creating me troubles <Objs Version="1.1.0.1" xmlns="http://schemas….
How can I translate this SQL code to R script using dplyr?
I’m currently working on a project and I want to summarize a column from a joined table twice. SQL code is this: …and the result is this: Database tables are as shown here: I hope that I have provided all the information needed. Question: How can I have the same result in R by only using dplyr lib…
How to set parameters to show data from a period of time in SQL?
I created a SQL stored procedure: CREATE PROCEDURE [stored procedure name] ( @Location [varchar](255), @start_date datetime, @end_date datetime ) AS BEGIN SELECT id, location, name, …
Can you do a regex in the select statement on SQL Server?
I can see you can do like in the where clause, but can you do a regex in a select statement? I have rows with something like following: /sites/xxxx-588-xxxxxxxx/Delte dokumenter/xxxx/xxxx/xxx/file….
Concatenation, rounding, and dealing with nulls
I have the following table: x y 1 1 1 0 1 null 0 1 0 0 0 null null 1 null 0 null null And I want to produce the following column: z 11 10 1null …
Select a value from Table 2 that depends on another value from Table 1 (Oracle SQL)
I’m trying to do some DB during the lockdown and would appreciate some help, since I have been doing this for 5 hours without luck. Got a PDF from a book and sadly, the solutions part isn’t readable. …
MySQL (Laravel Eloquent) – Get record when two columns have two or more values at the same time
I have this database that I got from this post that manages products and its variants: The problem is, that I don’t know how would I get the SKU at the moment that a user selects the options of the product he wants: Let’s suppose that the user selects the product with ID 1 and the options size-sma…
SQL Query get most recent activiy per account (efficient query)
I use MS SQL Server 2016 and try to query the MS Dynamics 2016 on-premise DB efficiently. You don’t need special knowledge about Dynamics to answer my problem because it’s rather an SQL but a CRM …