hi,

not sure what u are looking for, but u cannot include an "order by" clause
in a view. however u can always do this
"Select * from ViewName order by ColumnName"

what do u mean print the output?

If u are using SQL Analyser the output from a query can be printed directly
or exported to a .XLS or .CSV file.

HTH,
ajax®.

----- Original Message -----
From: "Mohammed" <mrizhwaan@p...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, September 30, 2002 9:42 PM
Subject: [asp_databases] sorting and printing SQL SERVER VIEWS


> I would like to create a VIEW from three tables and i would like to sort
> the
> output by on of the fields. i am able to create the view but i dont know
> how
> to do the sorting of the data (for example, how do i specify that i want
to
> sort the output by AuthorID). And also is there any way we can print the
> output of the view??
>