r937 - DevShed Author Bio

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

Join Date: February 25th, 2003

Last Activity: Today 04:28 PM

Recent Visitors

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

This page has had 13,592 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 How can I update this query so not only I get unique ip, I also get unique email in MySQL Help

because nothing suggested that you wanted only the emails!!! using SELECT * and GROUP BY ip suggested that you wanted all the other columns as...

see more

October 17th, 2017, 06:16 AM
13 replies | 286 view(s)
r937 replied to a thread How can I update this query so not only I get unique ip, I also get unique email in MySQL Help

well, that's just the thing... if you do it when it's correct to do it, then it isn't a gotcha, because all values of non-aggregated columns are...

see more

October 16th, 2017, 10:32 AM
13 replies | 286 view(s)
r937 replied to a thread How can I update this query so not only I get unique ip, I also get unique email in MySQL Help

i agree, it seems wrong... there's way too much else going on in the grouping for example, suppose there are multiple emails for a given IP......

see more

October 16th, 2017, 09:37 AM
13 replies | 286 view(s)
r937 replied to a thread How can I update this query so not only I get unique ip, I also get unique email in MySQL Help

i'm sorry, i don't speak php, perhaps someone else

see more

October 16th, 2017, 07:21 AM
13 replies | 286 view(s)
r937 replied to a thread How can I update this query so not only I get unique ip, I also get unique email in MySQL Help

but SELECT * with GROUP BY does make sense... in MySQL actually the rationale for it is quite reasonable, the only problem is, so few actual...

see more

October 16th, 2017, 04:33 AM
13 replies | 286 view(s)
r937 replied to a thread Storing medical ailments in a database Databases in MySQL Help

no, a row for each one in an Ailments table

see more

October 8th, 2017, 04:38 AM
3 replies | 258 view(s)
r937 replied to a thread Help with query in MS SQL Development

also, why are you joining Players pl to Players y? also, the IS NOT NULL check here is redundant -- WHERE DateRedeemed is not null AND...

see more

October 6th, 2017, 12:56 PM
4 replies | 289 view(s)
r937 replied to a thread Help with query in MS SQL Development

the first thing to do when analyzing any GROUP BY query that seems to be returning duplicates, is to remove the GROUP BY, make sure the PK from every...

see more

October 6th, 2017, 12:51 PM
4 replies | 289 view(s)
r937 replied to a thread Select from 3 rows, 2 tables into one result in MySQL Help

SELECT articles.id , trans1.value AS title , trans2.value AS description FROM articles INNER JOIN translations AS trans1 ON...

see more

October 2nd, 2017, 11:46 AM
2 replies | 210 view(s)
r937 replied to a thread SQL Inner Joins Help again in MySQL Help

look at your data i think your query is fine no results means some join fields don't contain what you think is there

see more

October 2nd, 2017, 07:38 AM
5 replies | 253 view(s)
r937 replied to a thread SQL Inner Joins Help again in MySQL Help

so what was wrong with your original query again?

see more

October 2nd, 2017, 03:53 AM
5 replies | 253 view(s)
r937 replied to a thread SQL Inner Joins Help again in MySQL Help

" should " what does this actually return? SELECT COUNT(*) FROM tblEmployee_Horse WHERE Employee_ID = 18

see more

September 29th, 2017, 04:25 PM
5 replies | 253 view(s)
r937 replied to a thread Request years that exist in MySQL Help

your human analogy doesn't work... SQL is not row-at-a-time, it is table-at-a-time remember, there is no "first"

see more

September 27th, 2017, 03:21 AM
5 replies | 251 view(s)
r937 replied to a thread Request years that exist in MySQL Help

no... it will return unique values... there is no "first" would who? um, recognized? processed? dude, what happened when you tested it? ™

see more

September 26th, 2017, 05:55 PM
5 replies | 251 view(s)
r937 replied to a thread Request years that exist in MySQL Help

also SELECT DISTINCT YEAR(`date`) FROM `invoice` it would be interesting to compare the EXPLAINs for these two approaches

see more

September 26th, 2017, 11:52 AM
5 replies | 251 view(s)

No More Results

Latest Reputation Given

Thread / Date

User / Points

Comment

Thread / Date

 Is this table designed properly to store millions of records?
September 13th, 201707:59 AM

User / Points
You gave 0 to
requinix

Comment
masterful
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

Latest Reputation Received 424681 point(s) total

Thread / Date

User / Points

Comment

Thread / Date

 Unknown column error
September 15th, 201703:54 PM

User / Points
You recieved 0 from
pwpx2

Comment
No Comment Made
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

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

 Is this table designed properly to store millions of records?

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

Latest Reputation Received 424681 point(s) total

Thread / Date User / Points Comment

Thread / Date

 Unknown column error

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

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

Thread / Date

User / Points

Comment

Thread / Date

User / Points

Comment