I wrote a view like that
SELECT TA.pk, y, z
FROM TA LEFT OUTER JOIN
(
SELECT TB.fk, y FROM TB LEFT OUTER JOIN TC ON TB.FkC = TC.PkC
WHERE date is null OR date > @paramDate
) AS T1 ON TA.pk = T1.fk
I want to pass a value to @paramDate parameter from my code.
here I do not want WHERE clause to attached at the bottom line.
it's position important to me.
I could not find anything that allow me to do that in the documentation.
Is it posibble or what you advise me to do