Viewing 15 posts - 31 through 45 (of 152 total)
Thank you everyone!
October 26, 2017 at 2:16 pm
Current output:
i_ticket_id,c_grand_total,c_payment_total,dt_close_time
215670,0.00,0.00,2017-10-23 22:03:24.553
215644,133.28,133.28,2017-10-23 22:19:57.710
215671,42.61,42.61,2017-10-23 22:27:04.323
215673,45.42,45.42,2017-10-23 22:27:38.307
215672,0.00,0.00,2017-10-23 22:31:52.507
215666,68.83,68.83,2017-10-23 23:00:19.120
215610,412.96,412.96,2017-10-23 23:01:17.790
I really want to get good at posting in the correct format....
October 24, 2017 at 4:08 pm
Ok, ill be better with my posts from here on out. Just takes a long time to add some small data for a little fix, IMO. Maybe I am not...
October 24, 2017 at 12:00 pm
Without...
October 24, 2017 at 11:54 am
This works, but its at the end and thats not as sexy as I would like it to be. BUT the output to my csv file is formatted perfectly....
October 23, 2017 at 4:23 pm
SELECT '$' + CONVERT(VARCHAR(10), CAST([ie].[Amount] AS MONEY)),
Name = CASE WHEN GROUPING([ie].[Amount]) = 0 THEN [ie].[Amount] ELSE 'Total' END,
Value = SUM([ie].[Amount])
FROM...
October 17, 2017 at 10:14 pm
October 17, 2017 at 4:33 pm
October 17, 2017 at 4:31 pm
October 16, 2017 at 1:45 pm
October 16, 2017 at 1:10 pm
Viewing 15 posts - 31 through 45 (of 152 total)