Reputation
1,015
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
6 19
Impact
~22k people reached

Feb
3
comment How to fix MySQL anonymous account security issue?
Remove the user?
Jan
20
awarded  Popular Question
Dec
21
comment Mysql trigger with group_concat
Having comma separated values in a column is not a good idea anyway. Read about normalization. Reasons can be read here.
Dec
16
accepted What could cause “lagging” in SSIS execute SQL task?
Dec
15
awarded  Benefactor
Dec
9
awarded  Promoter
Dec
9
revised What could cause “lagging” in SSIS execute SQL task?
added 24 characters in body; edited tags
Dec
3
asked What could cause “lagging” in SSIS execute SQL task?
Oct
14
comment Find Max(value) for each department using GROUP BY MYSQL
Fixed this in the answer.
Oct
14
revised Find Max(value) for each department using GROUP BY MYSQL
deleted 6 characters in body
Oct
14
answered Find Max(value) for each department using GROUP BY MYSQL
Sep
25
answered Computational power required for this query
Sep
20
comment MySQL turn rows into columns
You mean you have 1440 columns? One column per minute of the day? If yes, then I'd suggest that you better find a solution to overcome the bad database design, instead of doing crazy queries. If it's an emergency, you can build a query by querying the information_schema database.
Sep
19
answered MySQL turn rows into columns
Sep
17
comment MySQL - Number format - Separated with Comma
The manual is your friend: dev.mysql.com/doc/refman/5.0/en/…
Sep
12
comment 2 GROUP BY WITH DISTINCT , SUM , COUNT : PHP MYQL
What if the value of owgh is one time 1.5 and one time 1.4 for mid = 3 and pid = 12? Which value should be chosen to calculate with?
Sep
11
comment identify multiple gaps and islands for n columns
The query still is the same. You just have to adjust the view t_pivot. See my updated answer.
Sep
11
revised identify multiple gaps and islands for n columns
added 366 characters in body
Sep
11
comment identify multiple gaps and islands for n columns
Sorry, I don't understand what you mean exactly. Please provide sample data and desired result.
Sep
11
revised identify multiple gaps and islands for n columns
added 236 characters in body