error code 1241 using MySQL
| SQL |
https://codedump.io/share/LsDfe3KjaXmC
|
SELECT c.Staff_no, c.Start_datetime, c.End_datetime, s.First_name, s.Profession, s.Department, s.Gender
FROM duty_roster_1501003f c, staff_1501003f s...
3 years ago
How can I fix Error code 1241 in MySQL
| SQL |
https://codedump.io/share/Ju6w51SO4ZMF
|
SELECT c.Staff_no, c.Start_datetime, c.End_datetime, s.First_name, s.Profession, s.Department, s.Gender
FROM duty_roster_1501003f c, staff_1501003f s...
3 years ago
SQL Server - merge two XML using only .modify()
| SQL |
https://codedump.io/share/OJoMkmxL8Cp
|
Suppose we have:
CREATE TABLE #Users(id INT PRIMARY KEY, name VARCHAR(100), suggestions XML);
INSERT INTO #Users(id, name, suggestions)
SELECT 1, 'B...
3 years ago
Distinct, order in 1 query
| SQL |
https://codedump.io/share/dsmIAzJPBxvG
|
I have a downloads table that records each time a user downloads a file. I want to write a query that returns the most recent x downloads, but show a ...
3 years ago
SQL Case Statement Syntax?
| SQL |
https://codedump.io/share/H3OgwAUiccGR
|
What is the complete and correct syntax for the SQL Case statement?
3 years ago
Agent job that emails from custom email table
| SQL |
https://codedump.io/share/2flmDQW5f0w
|
I used to have triggers in my database that used cursors / sp_send_dbmail to email when certain columns were updated. I was told this was not best pr...
3 years ago
forum posts display loading slowly
| SQL |
https://codedump.io/share/rQ44YPjWoVDC
|
I am new to php coding and am coding a website (with forums) to learn.
Currently I have one dynamic page that handles all the forum aspects from disp...
3 years ago
Use (or not) of junction tables
| SQL |
https://codedump.io/share/88AuSi4iNHQQ
|
I'm in the process of developping a small project for school, and I'm unsure on a design choice.
Here is what I am trying to achieve :
I have a tabl...
3 years ago
Mysql multiple Inner Joins not working
| SQL |
https://codedump.io/share/n8f5C9jXQJbk
|
I have following query that is working fine in TSQL
SELECT
shoppingcart_1.price, shoppingcart_1.stid, course.isbn,
book.BookTitle, cour...
3 years ago
PHP Weird output
| SQL |
https://codedump.io/share/xh6SKriRh8Wt
|
<html>
<head><title> Inpatient Search </title><head>
<body>
<h1> Inpatient Search </h1>
<?php
$w...
3 years ago
Handling DBNull and null in ASP.NET
| SQL |
https://codedump.io/share/bnOlmaW341J0
|
What is the best way of rewriting these (erroneous) lines?
bool? result = dr["result"] == DBNull.Value ? null : Convert.ToInt32(dr["result"]);
....
3 years ago
How to sort an alphanumeric column in MYSQL?
| SQL |
https://codedump.io/share/8AajOw0xnqBW
|
I have a column with values like below after ordering by it's column name (equipment_no) in ASC and was wondering how to sort it properly as shown in ...
3 years ago
Parallelism in PL/SQL
| SQL |
https://codedump.io/share/WtUplpWKZQQn
|
how can i run one query in pl-sql- in parallel?
i need all the flow...
3 years ago
How to get row count using ResultSet in Java?
| SQL |
https://codedump.io/share/b3FdxzwBClbc
|
I'm trying to create a simple method that receives a ResultSet as a parameter and returns an int that contains the row count of the ResultSet. Is this...
3 years ago
Subtract two SUM GROUP BY fields
| SQL |
https://codedump.io/share/uawQUOc1OwDo
|
I have two tables itemOrders and itemUsage.
itemOrders has two fields: item_number and qty_ordered
itemUsage has two fields: item_number and qty_used...
3 years ago