Viewing 15 posts - 1,981 through 1,995 (of 2,857 total)
Could it be a problem not with the valid dates, but with the NULLS?
As a quick test for that you could make 2 files, one that has a value in...
April 17, 2020 at 2:54 pm
Just my 2 cents, but devs shouldn't be running queries against live, espeically if they are going to take down live by doing so.
April 17, 2020 at 2:50 pm
What about if you break that out into IF statements instead?
April 17, 2020 at 2:19 pm
Could you post some sample code?
My expectation is that you are going to need a case statement in there, but would like some sample data to work with and would...
April 17, 2020 at 2:14 pm
Gotta love how Windows does that... different OS versions can have different font files even though they have the same name.
If you do try swapping fonts around, make sure to...
April 16, 2020 at 9:56 pm
PDF working makes sense as that is rendered entirely server side.
Excel though should work too. If you do find some bandwidth to investigate, my guess here is that the font...
April 16, 2020 at 9:43 pm
could you not put a WHERE clause where your category description is not RTF TOTAL?
Don't think you can do that with a group by; I think it will need to...
April 16, 2020 at 9:07 pm
If your two databases are on the same instance, and depending on server setup, you should be able to do that with a trigger.
If they are on different instances, a...
April 16, 2020 at 4:38 pm
So, SSIS is a tool that would need to be installed on the server and you'd build things up for it. Service broker is a series of scripts you would...
April 16, 2020 at 3:27 pm
UNION will be your friend there as long as the tables have the same number of columns OR you can add fake data into the missing columns.
In your example, I'm...
April 16, 2020 at 2:26 pm
Service broker could handle that. Pop a trigger on each table that fires off an XML message to the backup database of what changed and a stored procedure on the...
April 16, 2020 at 2:23 pm
Do you have those fonts installed on the server side?
The fonts need to exist on both client (for rendering the report and viewing online) and on the server (for generating...
April 15, 2020 at 10:02 pm
SELECT CAST(ROUND(COLUMN_A*100.0/(CASE WHEN COLUMN_B = 0 THEN -1 ELSE COLUMN_B END),2) as decimal(5,2)) as "Percentage"
You lost the ROUND() function's length parameter in that version
Good catch. That's what I get...
April 14, 2020 at 9:24 pm
So, if I understand correctly, if it is going to divide by 0, then you want it to return 0 instead. Then none of the solutions I provided will help...
April 14, 2020 at 9:17 pm
My expectation is that COLUMN_B has 0 values. So you need to exclude those or do something with them such as setting them to 1. how you handle it depends...
April 14, 2020 at 7:52 pm
Viewing 15 posts - 1,981 through 1,995 (of 2,857 total)