Re: From clause with parenthese - Posted once but server error
From: Steve Kass (skass_at_drew.edu)
Date: 08/10/04
- Next message: Carl Henthorn: "RE: Optimizer doing tablescan instead of using index"
- Previous message: Carl Henthorn: "RE: From clause with parenthese - Posted once but server error"
- In reply to: Kalvin: "From clause with parenthese - Posted once but server error"
- Next in thread: Kalvin: "Re: From clause with parenthese - Posted once but server error"
- Reply: Kalvin: "Re: From clause with parenthese - Posted once but server error"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 10 Aug 2004 13:23:29 -0400
Kalvin,
It looks like CoDConfig is a table-valued user-defined function with
parameters. You should be able to find the definition of this function
through Query Analyzer's object browser or with sp_helptext.
Steve Kass
Drew University
Kalvin wrote:
>Could someone please explain what this is doing? I can't find any
>documentation on this, but am working on a procedure written by
>someone else.
>
>SELECT dconfig.JobRouteJob
> , dconfig.JobrouteSuffix
> , dconfig.JobrouteOperNum
> , dconfig.FeatureDisplayQty
> , dconfig.FeatureDisplayUM
> , dconfig.FeatureDisplayDesc
> , dconfig.FeatureDisplayStr
> FROM dbo.CoDConfig (
> @CoNum
> , @CoLine
> , @CoRelease
> , @Item
> , @CoitemShipSite
> , @CoOrderDate
> , @CoitemFeatStr ) as dconfig
>
>This is run in a stored proc. The table dbo.CoDConfig does not
>currently exist in the database. It's not created anywhere in this
>procedure. It is possible that it is created outside of this
>procedure but I don't know. I have never seen a from clause with
>parentheses around a list of variables. What is the purpose and use
>of this syntax.
>
>Thank you very much.
>
>Kalvin
>
>
- Next message: Carl Henthorn: "RE: Optimizer doing tablescan instead of using index"
- Previous message: Carl Henthorn: "RE: From clause with parenthese - Posted once but server error"
- In reply to: Kalvin: "From clause with parenthese - Posted once but server error"
- Next in thread: Kalvin: "Re: From clause with parenthese - Posted once but server error"
- Reply: Kalvin: "Re: From clause with parenthese - Posted once but server error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
