Running queries on queries

28 Jul 2005 7:16 PM

A.B.

If I am using SQL Server 2000 and running queries on queries. I have made
views within the EM and built up to the final query that way. Is that the
best way to do it or not. Can I do it by creating a procedure, would that be
better.

28 Jul 2005 7:24 PM

Jens Süßmeyer

Please look here, already answered few days ago:

http://groups.google.de/group/microsoft.public.sqlserver.newusers/browse_frm/thread/5df4687c0a67ee18/9b179cc856cb5b3a?lnk=st&q=%22Jens+S%C3%BC%C3%9Fmeyer%22+views&rnum=5&hl=de#9b179cc856cb5b3a

procedure are for more logic you can´t represent in a view.

HTH, Jens Suessmeyer.

Show quote

"A.B." <A***@discussions.microsoft.com> wrote in message
news:D0695BA7-F88B-476F-AB7C-15463BF8A94F@microsoft.com...
> If I am using SQL Server 2000 and running queries on queries. I have made
> views within the EM and built up to the final query that way. Is that the
> best way to do it or not. Can I do it by creating a procedure, would that
> be
> better.