Posted by Kimmo Laine on 08/25/05 11:36

"Kimmo Laine" <eternal.erectionN05P@Mgmail.com> wrote in message
news:QMePe.12498$cS7.3936@reader1.news.jippii.net...
> I've got to do quite complex queries, and I've come to the point where I
> see no other possibilities, than doing them with views. I'm using MS SQL
> Server on IIS 6 on Win2003 server. I can make static views in my sql
> server enterprise manager, but I'd like to be able to change them
> dynamically. Right now I can get a view from the entire time, but it would
> be great if I could insert parameters in the view, to get rows only where
> date > start date and date < end date. So I'm thinking I could use CREATE
> VIEW and DROP VIEW to be able to dynamically change the views. So I'm
> thinking something like



Answering to mysqlf: at least it seems to work as intended. Now the question
remains: is there a better way to accomplish it?

--
Welcome to Usenet! Please leave tolerance, understanding
and intelligence at the door. They aren't welcome here.
eternal piste erection miuku gmail piste com

[Back to original message]