r937 - DevShed Author Bio

r937 
SQL Consultant
Devshed Supreme Being (6500+ posts)
              

Join Date: February 25th, 2003

Last Activity: Yesterday 05:06 PM

Recent Visitors

The last 10 visitor(s) to this page were:

This page has had 13,148 visits

About Me

r937's Activity

Reputation

Basic Information

Signature

rudy.ca | @rudydotca
Buy my SitePoint book: Simply SQL

Contact

Statistics

Posts

General Information

Older Activity
r937 replied to a thread Inner Join Group By Query in MySQL Help

and your conclusion based on this is,,, ?

see more

August 14th, 2017, 05:34 PM
7 replies | 249 view(s)
r937 replied to a thread Inner Join Group By Query in MySQL Help

expected as in, you checked the numbers **by hand** and came up with the same answer or expected as in, the query ran and the results look like...

see more

August 12th, 2017, 05:07 PM
7 replies | 249 view(s)
r937 replied to a thread Inner Join Group By Query in MySQL Help

what happened when you tested it? ™

see more

August 12th, 2017, 04:24 PM
7 replies | 249 view(s)
r937 replied to a thread Query works but creating VIEW it crash in MySQL Help

that's because you used COUNT try MAX, like this -- SELECT post_id , MAX( CASE WHEN meta_key = '_regular_price' THEN...

see more

August 9th, 2017, 03:30 AM
12 replies | 409 view(s)
r937 replied to a thread Query works but creating VIEW it crash in MySQL Help

ding ding ding we have a winner! :thumbs: :thumbs: :thumbs: but only for inner joins... :)

see more

August 7th, 2017, 04:46 PM
12 replies | 409 view(s)
r937 replied to a thread Query Help in MySQL Help

what is the datatype of completed_stamp?

see more

August 4th, 2017, 09:00 AM
4 replies | 243 view(s)
r937 replied to a thread How come HUGE systems like ontraport allow multiple records with same email address? in MySQL Help

i made that up to illustrate a point ;o)

see more

July 29th, 2017, 08:57 AM
4 replies | 241 view(s)
r937 replied to a thread How come HUGE systems like ontraport allow multiple records with same email address? in MySQL Help

no it isn't :) person email --------------------- ------------------ English Breakfast Tea forums@devshed.com requinix ...

see more

July 28th, 2017, 06:52 PM
4 replies | 241 view(s)
r937 replied to a thread Displaying query if date has a value or is null in MySQL Help

like kicken says, make the optional joins LEFT OUTER looking more closely at your query, it seems you aren't using any contractor info, so why...

see more

July 25th, 2017, 04:36 AM
10 replies | 806 view(s)
r937 replied to a thread Displaying query if date has a value or is null in MySQL Help

another possibility is that jobs without a start date don't have a contractor or driller yet when you use inner joins like you did, jobs that...

see more

July 24th, 2017, 02:56 PM
10 replies | 806 view(s)
r937 replied to a thread Displaying query if date has a value or is null in MySQL Help

yeah, but i just don't believe that try running your query outside of php -- i'm guessing it's your display logic that's at fault

see more

July 24th, 2017, 02:53 PM
10 replies | 806 view(s)
r937 replied to a thread Displaying query if date has a value or is null in MySQL Help

your query as posted does exactly that

see more

July 24th, 2017, 07:23 AM
10 replies | 806 view(s)
r937 replied to a thread mother of all querys in MySQL Help

1. if you specify job.job_status_id = '2' then you don't really need to join to job_status at all, assuming 2 corresponds to 'Complete' 2. if you...

see more

July 22nd, 2017, 10:09 AM
4 replies | 385 view(s)

No More Results

Latest Reputation Given

Thread / Date

User / Points

Comment

Thread / Date

 Join on part of text col
July 21st, 201710:18 AM

User / Points
You gave 0 to
requinix

Comment
No Comment Made
Thread / Date

 Security Update: Password Expiry Dates
April 26th, 201609:28 AM

User / Points
You gave 1 to
SimonJM

Comment
No Comment Made
Thread / Date

 stupid dates!
March 8th, 201603:26 PM

User / Points
You gave 4287 to
Frank Grimes

Comment
No Comment Made
Thread / Date

 2 tables almost identical but one throws an error
January 30th, 201606:28 AM

User / Points
You gave 4286 to
requinix

Comment
No Comment Made
Thread / Date

 Question about MySQL
November 9th, 201504:48 PM

User / Points
You gave 4286 to
element121

Comment
No Comment Made
Thread / Date

 a big mysql table issue
May 7th, 201501:43 PM

User / Points
You gave 0 to
MrFujin

Comment
love you too <3
Thread / Date

 closest join
July 24th, 201402:14 PM

User / Points
You gave 3937 to
MrFujin

Comment
3000 bonus points for xaprb link
Thread / Date

 Query help
August 24th, 201303:09 AM

User / Points
You gave 0 to
Jacques1

Comment
i would have expected some kind of suggestion for a new data model and not just the usual diatribe/rant about what's wrong with the current one
Thread / Date

 Display 2 queries in the same table?
November 6th, 201207:56 PM

User / Points
You gave 937 to
regany

Comment
thanks for taking the time to give examples! very helpful for new developers
Thread / Date

 Update first X rows?
August 21st, 201209:29 PM

User / Points
You gave 937 to
airforcemook

Comment
what dan said

Latest Reputation Received 424681 point(s) total

Thread / Date

User / Points

Comment

Thread / Date

 Query works but creating VIEW it crash
August 9th, 201703:40 AM

User / Points
You recieved 0 from
smaa

Comment
No Comment Made
Thread / Date

 LEFT JOIN tables
April 8th, 201705:14 PM

User / Points
You recieved 0 from
pwpx2

Comment
No Comment Made
Thread / Date

 MYSQL Query Help
January 23rd, 201707:14 AM

User / Points
You recieved 0 from
fabzster

Comment
Many thanks this is exactly what I was looking for
Thread / Date

 Hex Conversion wrong result
January 4th, 201702:15 PM

User / Points
You recieved 0 from
pwpx2

Comment
great help.
Thread / Date

 Access violation
December 19th, 201610:39 AM

User / Points
You recieved 0 from
requinix

Comment
...huh
Thread / Date

 Query table with two foreign keys linked to 2 additional tables
November 4th, 201603:05 PM

User / Points
You recieved 0 from
xerces1024

Comment
No Comment Made
Thread / Date

 How do you assign a single table to different columns after joining?
October 27th, 201604:28 PM

User / Points
You recieved 0 from
Varsh

Comment
No Comment Made
Thread / Date

 select 0 for the day that do not have a value
September 20th, 201602:38 AM

User / Points
You recieved 0 from
jojoba

Comment
No Comment Made
Thread / Date

 wrong result from subquery in WHERE EXISTS
September 7th, 201605:37 AM

User / Points
You recieved 0 from
jojoba

Comment
why does it show 0 in my rep power :-s. anyway, thanks
Thread / Date

 receive second SELECT of UNION ALL as different column names
August 30th, 201603:58 PM

User / Points
You recieved 10 from
Will-O-The-Wisp

Comment
Thanks for helping!

Dev Shed Forums

r937  SQL Consultant Devshed Supreme Being (6500+ posts)                Twitter

Recent Visitors

Basic Information

Signature

Contact

Statistics

Posts

General Information

Latest Reputation Given

Thread / Date User / Points Comment

Thread / Date

 Join on part of text col

User / Points

Comment

Thread / Date

 Security Update: Password Expiry Dates

User / Points

Comment

Thread / Date

 stupid dates!

User / Points

Comment

Thread / Date

 2 tables almost identical but one throws an error

User / Points

Comment

Thread / Date

 Question about MySQL

User / Points

Comment

Thread / Date

 a big mysql table issue

User / Points

Comment

Thread / Date

 closest join

User / Points

Comment

Thread / Date

 Query help

User / Points

Comment

Thread / Date

 Display 2 queries in the same table?

User / Points

Comment

Thread / Date

 Update first X rows?

User / Points

Comment

Latest Reputation Received 424681 point(s) total

Thread / Date User / Points Comment

Thread / Date

 Query works but creating VIEW it crash

User / Points

Comment

Thread / Date

 LEFT JOIN tables

User / Points

Comment

Thread / Date

 MYSQL Query Help

User / Points

Comment

Thread / Date

 Hex Conversion wrong result

User / Points

Comment

Thread / Date

 Access violation

User / Points

Comment

Thread / Date

 Query table with two foreign keys linked to 2 additional tables

User / Points

Comment

Thread / Date

 How do you assign a single table to different columns after joining?

User / Points

r937 
SQL Consultant
Devshed Supreme Being (6500+ posts)
              

Thread / Date

User / Points

Comment

Thread / Date

User / Points

Comment