Viewing 15 posts - 2,041 through 2,055 (of 2,917 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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 17, 2020 at 2:50 pm
What about if you break that out into IF statements instead?
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 14, 2020 at 7:52 pm
Viewing 15 posts - 2,041 through 2,055 (of 2,917 total)