I have a PowerShell script I am using to install SQL Express, then SQL Server Management Studio, and finally, to edit the Windows Firewall settings to allow remote connections to the database. For …
Tag: sql
Join and calculate between 3 queries
I have 3 sql queries as follow with different conditions and rules but giving the same output: Query1: Select CONVERT(char(10), DatePayment, 120) PaymentDate, IsNull(SUM(UnitPrice * Quantity), 0) …
Laravel collection how to return where no records and not by auth user
public function tasks(Request $request) { $user = auth::user(); $query = Task::query(); $query->with(‘User’)->with(‘task_type’); $q = $query->paginate($tasksPerPage); …
How to join two tables with same date but different time such that the closest time is chosen?
I am trying to left join a Notes table where the user would upload Notes on certain time of each day onto a Score table with a date and time. The dates need to be the same, but I need to choose match …
Missing keyword from CREATE VIEW
The question for the section is: Create a view called TITLE_UNAVAIL to show the movie titles and media_id of the media not returned yet. The view should not allow any DML operations. This is for …
Best practices when storing multimedia posts SQL DB
I have searched StackOverflow for an answer to this question, and I’ve been surprised to find very little information for what seems to be a very common task Let’s say I have an app that allows users …
Is there effective way in laravel to select records from database and set them user_id?
I have to make laravel application that use database 100k+ records. I have table with columns: numer, date, segment, user_id. I am selecting records that I need with: $datetime = new DateTime(); $…
ASynchronous Creation of Temp Tables in SQL Server
I’m currently trying to determine possible issues with creating temporary tables from a web application and how SQL Server naturally determines separate sessions. SELECT blabla, lala FROM table INTO #…
Insert from multiple tables, multiple rows
I have been trying to solve my problem but could not find the answer. Oracle db. I have table context with looks like: | contextId | customer | ———————- | 1 | John | | …
IBM DB2 NEXT VALUE FOR concern
I am wondering when using the NEXT VALUE FOR does it lock the data area in the background? I want to make sure it does not create duplicate sequence numbers.