Reputation
4,355
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 14 34
Newest
 Suffrage
Impact
~166k people reached

Jan
29
reviewed Reviewed Unstructured to Structured Data
Jan
29
reviewed Close Get no. of trips in SQL Server
Jan
29
reviewed Reviewed Get no. of trips in SQL Server
Jan
29
reviewed Reopen Understanding a PostgreSQL join
Jan
29
comment How to use SET operation in CASE clause in SQL?
It seems like in each case when the divisor is zero, the OP is happy to store NULL. With this in mind, you could avoid the extra checks for 0 in your CASEs if you used this trick to avoid division by zero: A / NULLIF(B, 0). It would give you NULL for every attempt to divide by zero and the NULL would fail every condition in the CASE (giving NULL as the result of the CASE, of course). In fact, that would eliminate the need for any explicit checks for zero in your script.
Jan
29
reviewed Close I have created a zip file using 7z for backup but its taking time to open
Jan
29
comment I have created a zip file using 7z for backup but its taking time to open
Which files exactly are you compressing with 7z and where/how exactly are you opening the compressed file?
Jan
29
reviewed Close Connection error
Jan
29
reviewed Reviewed Mysql server keeps stopping unexpectedly on centos
Jan
29
reviewed Reviewed Which one is best for sql?
Jan
29
reviewed Reviewed SQL query review
Jan
29
reviewed Close SQL query review
Jan
28
awarded  Suffrage
Jan
28
comment Compare strings from two tables SQL Server 2014
True, or you could move it to the beginning, for instance: [-+*/()]
Jan
28
comment Compare strings from two tables SQL Server 2014
@JosepBacardit: An alternative could be to specify all possible delimiters on both sides of the parameter name: … LIKE N'%[+-*/()]'+p.ParameterName+N'[+-*/()]%'. And to account for the names exactly at the beginning and exactly at the end of the source string, just make sure they are delimited on both sides: '+' + B.DataSourceAddress + '+' LIKE ….
Jan
28
comment mysql trigger on a federated table
For the future, when you ask a question that gets no response and you want to address it at a different community, you can flag it for migration, no need to cross-post.
Jan
28
revised Count values of a column
added another option
Jan
28
comment ID duplicates where none should exist in postgresql
If you love your picture dearly, please keep it by all means. But please also repost all the relevant information as text in your question. Beside what's in the picture, it would also be helpful to know the exact definition of the stack_exchange.posts.id column.
Jan
28
revised Record inheritance in mySQL
formatting, tagging
Jan
28
comment SQL Server 2008 Triggers and Merge Replication
Just for the record, FOR INSERT = AFTER INSERT in Transact-SQL.