I wanted to manage the history of the data, so I tried to create the following view in SQL SERVER.
I don't know how to set conditions externally for columns in subqueries
If you don't give the conditional expression within the subquery, you won't get the correct search results, so I want to do this
If I set it to stored, I can set the variable, but I would like to use this result by joining other searches, so I would like to make it into a view if possible, but is it impossible?sql sql-server
You cannot specify conditions for a view.
You can set variables when stored, but I want to use this result by JOINing it in another search
As you can see, the table value function can be written in the
FROM clause and the result can be treated as a table, so
JOIN and so on.
© 2022 OneMinuteCode. All rights reserved.