Reputation
773
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 15
Newest
 Yearling
Impact
~10k people reached

May
12
answered SQL SSIS syntax question
Apr
3
awarded  Yearling
Feb
5
comment Query gives correct answer on second run
Well, like I said, I can only guess. Come up with the requirements, maybe sample data and desired result and we can help. But not with this little information.
Feb
4
reviewed No Action Needed Sleeping queries blocking rebuild index and update statistics job in Always on
Feb
4
reviewed No Action Needed Large query with subquery runs indefinitely after mysql update
Feb
4
comment Query gives correct answer on second run
@user57391 Edited my answer.
Feb
4
revised Query gives correct answer on second run
added 711 characters in body
Feb
3
answered Query gives correct answer on second run
Feb
2
comment Selecting, ranking and applying a point score based on rank
? It's right in the post. The history is under the link "edited Jan 27 at 11:30" What is not working?
Jan
27
comment MySQL : How to know if Trigger was fired
Write something in a temporary table if you wish.
Jan
27
comment MySQL : How to know if Trigger was fired
When the trigger was created successfully, you can safely assume that it's fired when the appropriate DML statement is executed.
Jan
27
comment Selecting, ranking and applying a point score based on rank
@Dannymh Updated my answer. Please have a try.
Jan
27
revised Selecting, ranking and applying a point score based on rank
added 985 characters in body
Jan
26
revised Selecting, ranking and applying a point score based on rank
added 1178 characters in body
Jan
26
answered Selecting, ranking and applying a point score based on rank
Dec
30
comment Remove duplicate terms from column
No, there's no simple query. Databases are not meant to do such work. Read in the value, process it with the programming language of your choice, update the table afterwards. But really, you don't need your table design this way and you don't want to have it this way. This problem is just the beginning, you will run into much more and worse trouble with this design. Again, read about normalization, ask here if you have trouble coming up with a good design (show what you tried)...
Dec
29
comment Remove duplicate terms from column
Don't store comma separated values in one column and you won't have that problem. You think I'm joking or this is a dumb comment? No, it's common practice. Read about normalization.
Dec
23
comment Sorting by two columns conditionally
@Bhargava When it solves your problem you should accept the answer by clicking the check to the left of the answer. This way others also know, that the issue is solved.
Dec
22
answered Sorting by two columns conditionally
Dec
16
awarded  Enthusiast