> Sent: Monday, August 25, 2003 8:36 AM
> To: CF-Talk
> Subject: RE: Return Subquery as text string? MSSQL
>
>
> With MSSQL 2000 you can create UDF's. Your UDF would be the
> following, this is the only way I can think of to solve your issue.
>
> CREATE
lle, MD 20850-1299WWW:http://www.euservices.com
__
> -Original Message-
> From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 22, 2003 5:30 PM
> To: CF-Talk
> Subject: RE: Return Subquery as
lto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2003 4:12 PM
To: CF-Talk
Subject: Re: Return Subquery as text string? MSSQL
Mark W. Breneman wrote:
> Is there any way to do this in MSSQL? Normally you can not return
more
> then one value with type of subquery.
>
> Here is what I w
Mark W. Breneman wrote:
> Is there any way to do this in MSSQL? Normally you can not return more
> then one value with type of subquery.
>
> Here is what I would like to do:
> Select UserID, Name, (select orderNo from orders where OrderID=UserID)
> as Orders
> From Users
>
> Result:
>
> "1", "
4 matches
Mail list logo