Viewing 15 posts - 2,011 through 2,025 (of 2,883 total)
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
Quick google brought me to this page:
https://docs.microsoft.com/en-us/archive/blogs/sqltips/ordering-guarantees-in-sql-server
which states in point number 4:
INSERT queries that use SELECT with ORDER BY to populate rows guarantees how identity values are computed but not...
April 14, 2020 at 2:45 pm
Have you tried creating an alias on server B?
Where I work, we have the SQL aliases pushed out through the logon script (VBScript) to each end user machine. Putting an...
April 9, 2020 at 5:37 pm
One thing to watch out for is with your linked server, are you passing your credentials along OR using a hard-coded username and password?
If it is hard coded, that account...
April 9, 2020 at 5:34 pm
If I am looking at that execution plan correctly, the left-most operation is a cursor. Cursors will impact performance as they are row based operations. If you can remove that...
April 8, 2020 at 7:31 pm
Viewing 15 posts - 2,011 through 2,025 (of 2,883 total)