Information générale
Forum:
Microsoft SQL Server
Thanks Daniel that is a good idea.
Jim
>>Darn notebooks. I hit the wrong button. anyway i would like to test in the WHERE statement if the year in track.schoolyear is = to the value in schoolyear.nschoolyear. So this year it would be equivalent to
>>WHERE track.schoolyear = 2003.
>>So to summarize
>>I would like to be able to change the value in the WHERE statement for the schoolyear.
>>
>
>You can't build a parameterized view like you can in VFP, but you can query it just like any other table. Build the view without the where clause, and supply that when you need it.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement