SQL Manipulation with a VB Net Variable
Hello, Does anyone know an effective way to alter the amount column of a table using a SQL script? Use case: the client is bringing in what they call "Production Downtime" to the system, which show...
Forum Discussion
Thanks for your response, Rob.
Here is a snippet of my query and what it returns. There is more to it (needs to return a different query based on parameter selections), but similar queries are being ran regardless of their selections.
I am running a union on the time, so I get Current Period and Prior Year (Same period) so they can compare on a graph.
I do believe adding in another column where the ratio is applied would be the best approach, but it is a matter of getting it into this business rule. I will try to apply what you have provided me with, thank you. Let me know if you have any further suggestions.
Since you mentioned SQL is not your strong suit, before going further I would strongly suggest you have a look at this article and understand how to pass parameters/variables into your SQL the right way. It is less error prone and less of a security risk: https://community.onestreamsoftware.com/t5/Community-Blog/SELECT-Like-a-Boss-With-Query-Parameters/ba-p/22426
- Daniel