Timeline for How to change values on specific days for report generated from mysql
Current License: CC BY-SA 3.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 3, 2013 at 20:50 | history | tweeted | twitter.com/#!/StackDBAs/status/363763743089782784 | ||
| Aug 2, 2013 at 12:17 | answer | added | Taryn | timeline score: 6 | |
| Aug 2, 2013 at 12:04 | history | reopened | JNK | ||
| Aug 2, 2013 at 12:02 | history | edited | Taryn | CC BY-SA 3.0 |
edited title
|
| Aug 2, 2013 at 11:42 | history | edited | Taryn | CC BY-SA 3.0 |
edited title
|
| Aug 2, 2013 at 11:16 | history | edited | Taryn | CC BY-SA 3.0 |
moved code from SQL Fiddle to question
|
| Aug 2, 2013 at 10:43 | comment | added | Narendar_CH | Is my Post Unclear? | |
| Aug 1, 2013 at 11:45 | review | Reopen votes | |||
| Aug 1, 2013 at 16:46 | |||||
| Aug 1, 2013 at 11:26 | history | edited | Narendar_CH | CC BY-SA 3.0 |
I have modified my question to be clear.
|
| Aug 1, 2013 at 7:09 | comment | added | Narendar_CH | this is modified code sqlfiddle.com/#!2/62b91/14 pl look into this | |
| Aug 1, 2013 at 5:10 | comment | added | Narendar_CH | In my post we are generating a result that shows attendance report for 1 month/between the 2 dates as 1 2 3 4 5 --- 31 with status as A/L/P. in the result we are getting Day names with day as MON-1,TUE-2 -----. So now I want to show where ever the Name SUN Occurs I want to Highlight or set status as 'Sun' and also i have a holidays table. By pulling the holidays Dates into this report and show their status in the report as 'H'. Simply in the report, for suppose THU-15 is holiday if we generate report for 2013-08-01 to 2013-08-31, so i want to show 'H' on THU-15. | |
| Aug 1, 2013 at 4:58 | comment | added | Narendar_CH | Thank you @bluefeet for your response.And sorry for my unclear post. | |
| Jul 31, 2013 at 22:46 | history | closed |
Paul White♦ StanleyJohns RolandoMySQLDBA Mark Storey-Smith András Váczi |
Needs details or clarity | |
| Jul 31, 2013 at 16:04 | review | Close votes | |||
| Jul 31, 2013 at 22:46 | |||||
| Jul 31, 2013 at 14:28 | comment | added | Taryn | What do you mean by you want to highlight Sundays? What is the desired result of the query? My suggestion would be to write the query without the dynamic sql first, then convert it so you can get the logic correct. | |
| Jul 31, 2013 at 7:41 | history | asked | Narendar_CH | CC BY-SA 3.0 |