Posted by Stu on 01/07/07 02:02

Not trying to be too snarky, but have you considered using a view?


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

• Next in forum: How to stop query in QA from continuing
• Prev in forum: Idea: new database object that defines a FROM clause
• Thread view: Re: Idea: new database object that defines a FROM clause

[Reply to this message]