Reputation
3,037
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
12 30
Newest
 Custodian
Impact
~117k people reached

Aug
19
revised FastReport / Report Query Help - How do i convert a integer value into a string?
formatting, grammar
Aug
19
revised Sql parent Child Query not working
improved formatting, added tags
Aug
19
answered Sql parent Child Query not working
Aug
19
comment How to deduplicate SELECT statements in relational division?
I think it should be possible to avoid the union as well by introducing a join to (VALUES ('campaign_one', '1'), ('campaign_two', '2')) AS p3 (value, filter) ON p1.value = p3.value. Naturally, the WHERE would include both campaigns and the filter column would be pulled from p3. Not sure if this change would have significant implications for performance. (My gut feeling is it wouldn't, but I'm no expert.)
Aug
19
reviewed Approve What are the arguments against or for putting application logic in the database layer?
Aug
19
comment Query to group by column and count number of days based on dates
So you are looking for the number of days in the range that is defined by the minimum date in a group and the maximum day in a group, regardless of the number of (other) dates that are actually present in the table, correct? Please clarify that in your question, because without such a clarification people could be taking your TUNDUMA -> 4 days output as the actual result for your sample data, which doesn't make sense.
Aug
19
revised Find the identity of the client firing a query in SQL Server without using triggers?
expanded the CDC abbreviation, linked to the feature's manual
Aug
19
awarded  Strunk & White
Aug
19
reviewed Reject and Edit Query to get result in Excel file
Aug
19
revised Query to get result in Excel file
improved formatting, rephrased for clarity
Aug
19
revised Update all table's columns with another table's colums
added 27 characters in body
Aug
19
comment How to insert (file) data into a PostgreSQL bytea column?
@miracle173: Thanks, I guess my decision was just too hasty or superficial (or both). I'll be more careful next time. By the way, I don't get notifications when you address me as Andriy_M. The underscore is not in my username so the system doesn't find me. Andriy or AndriyM will work just fine. (Personally I'm fine with your version, it's just to make our communication more productive.)
Aug
19
comment How to insert (file) data into a PostgreSQL bytea column?
@miracle173: Because I got the impression that some of the suggested tags were irrelevant (well, just one actually, blob). If that was a mistake, I sincerely apologise.
Aug
19
reviewed Reviewed Mysql error “#1030 - Got error -1 from storage engine” when doing insert/update queries
Aug
19
revised Mysql error “#1030 - Got error -1 from storage engine” when doing insert/update queries
improved formatting, removed "thanks"
Aug
19
reviewed No Action Needed See SQL Server Reporting Services Reports without logging in?
Aug
19
reviewed Reject How to insert (file) data into a PostgreSQL bytea column?
Aug
19
revised Optimizing query using a WHILE statement
minor fixes to sooth my OCD
Aug
19
comment Optimizing query using a WHILE statement
Exactly, why 2x? What are we helping that guy with?
Aug
18
revised Cannot find one or more components. Please reinstall the application
deleted 12 characters in body; edited tags; edited title