Reputation
2,589
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
10 28
Newest
 Good Answer
Impact
~108k people reached

Jul
28
answered How to improve perfomance or Query Execution Time in MySQL?
Jul
28
revised Why is it bad practice to install SQL Server to the root of a drive
corrected spelling and punctuation, replaced an irrelevant tag
Jul
27
comment Drop and Create Script not working
@MandM: You can have warnings and other nice things when you are doing this through a graphical user interface by clicking buttons, checkboxes etc. The tool that implements that interface typically does the necessary checking for you under the cover, shows you the warnings and asks for confirmation. The engine itself is not designed to have that level of interactivity. You just run a command and it either succeeds or fails.
Jul
27
awarded  Custodian
Jul
27
reviewed Edit MySQL Workbench cloud alternatives
Jul
27
revised MySQL Workbench cloud alternatives
grammar
Jul
27
comment Query to store the current date and time in a specific time range
It's unclear what you are asking. What specifically should the query do?
Jul
27
revised Query to store the current date and time in a specific time range
added 207 characters in body; edited title
Jul
26
answered How to JOIN each row ON NOT IN ( SELECT … )?
Jul
25
revised SQL redundant databases both sets being modified independently yet staying concurrent
edited tags
Jul
24
awarded  Enlightened
Jul
24
comment Best way to write SQL Query that checks a column for non-NULL value or NULL
Thanks for the edit, @PaulWhite!
Jul
24
awarded  sql
Jul
23
revised Cannot connect to SQL Server database regardless of connection string
formatting, typo
Jul
23
comment Best way to write SQL Query that checks a column for non-NULL value or NULL
@MisterMagoo: Thanks. I remember seeing this technique in Paul White's answers, I just didn't bother looking for them. Happily, I've also been reminded that he has dedicated a blog article specifically to this method. Please see my update.
Jul
23
revised Best way to write SQL Query that checks a column for non-NULL value or NULL
added a reference
Jul
23
awarded  Nice Answer
Jul
23
answered Best way to write SQL Query that checks a column for non-NULL value or NULL
Jul
23
comment Concatenate columns uniquely on the same table in MS ACCESS
@user71111: If you still want to suppress the rows where all NEWxx values are empty, then remove the WHERE clause and add this HAVING clause instead (after GROUP BY, of course, according to the syntax): HAVING max(iif([D] like "IA1" .. rest of code)) IS NOT NULL OR max(iif([D] like "IA2" .. rest of code)) IS NOT NULL OR max(iif([D] like "IA3" .. rest of code)) IS NOT NULL. (Not sure, maybe you'll need to enclose separate predicates in parentheses.) Yes, it'll be much more messy now. But if it's fine to have those empty data lines, then you can just remove the WHERE without adding anything.
Jul
23
answered Concatenate columns uniquely on the same table in MS ACCESS