Posted by David Portas on 01/07/07 08:38

John Rivers wrote:
> create from dbo.fromExample
> as
> from dbo.Customers c
> join dbo.Invoices i
> on c.CustomerID = i.CustomerID
>
> now you can use it as follows:
>
> select c.CustomerID, i.InvoiceNo
> from dbo.fromExample
>
> I find I reuse FROM clauses alot
>
> and reusing a "base query" requires writing a very large and cumbersome
> select clause

Use a CTE
or a view
or a derived table

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

• Next in forum: Re: Link Server doesn't work except through query analyzer: MSSQL freezing / timing out
• Prev in forum: Re: How to stop query in QA from continuing
• Thread view: Re: Idea: new database object that defines a FROM clause

[Reply to this message]