RE: Return Subquery as text string? MSSQL

2003-08-25 Thread Bill Grover
> 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

RE: Return Subquery as text string? MSSQL

2003-08-25 Thread Bill Grover
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

RE: Return Subquery as text string? MSSQL

2003-08-22 Thread Mark W. Breneman
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

Re: Return Subquery as text string? MSSQL

2003-08-22 Thread Jochem van Dieten
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", "