>>>>
>>>>Thank you for clarifying. Sorry that I didn't pay attention to the semicolons. I will test this approach in both VFP and SQL Server. Initially I thought I would do it using a Function (with pretty much similar code that you wrote). But view is probably better approach (although I don't yet understand why).
>>>
>>>
>>>> But view is probably better approach (although I don't yet understand why).
>>>
>>>
>>>I think it is because a view is faster.
>>>
>>>btw - I have used nvl() in case there are no invoices yet. I think the sqlserver equivalent is ISNULL()
http://msdn.microsoft.com/en-us/library/ms184325.aspx>>
>>Thank you for the NVL() and ISNULL() explanation.
>
>If you want to do it for particular Order, you have two choices. Select * from OrdersView where OrderID = @OrderId
>
>or alternatively create the above as a table values inline function, so it will be
>
>select * from dbo.OrdersInfo(@OrderID)
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham