The case tag has no wiki summary.
0
votes
1answer
26 views
Foreign key with multiple references
I have the following three tables in mysql database named "THE_COLLEGE"
mysql> desc students;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | ...
1
vote
2answers
49 views
Oracle Case when problem
I Have a table like fallowing
work_id group effort
----------- ----- --------
1 A 10
1 B 5
2 A 7
2 ...
1
vote
2answers
203 views
Way to update many (>3000) records with unique data, using a character limited web form
Okay, as you can probably tell from the last part of the title, this is a non-ideal situation.
I'm using a piece of industry-specific web-interface software that I guarantee no one has ever heard of, ...
3
votes
2answers
3k views
CASE ORDER BY with multiple columns, and different sort options
I am attempting to use a T-SQL CASE ORDER BY in a stored procedure where I am passed @OrderBy parameter as a TINYINT.
@Orderby = 1 Then Date column should be ASC
@Orderby = 2 Then Date column ...
1
vote
1answer
116 views
Is my case statement broken by the use of outer apply?
I'm struggling with a case statement not working. Simple enough I need to supply a value of 0 where the question marks are. I have several other case statements which handle separate columns, but this ...
