RE: OT - MS SQL help

2002-09-12 Thread S . Isaac Dealey
> http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=2 > 56 > &forumid=6&refresh=0 > Dan > -Original Message- > From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 12, 2002 12:13 PM > To: CF-Talk > Subject:

Re: OT - MS SQL help

2002-09-12 Thread S . Isaac Dealey
You could do it in SQL Server with a stored procedure and a cursor, although all things considered, it's probably faster and easier to do it in cf... I've thought about or wanted to do this myself on a number of occasions, but never been able to find a way to do it that wasn't way more effort than

RE: OT - MS SQL help

2002-09-12 Thread Dan Haley
September 12, 2002 12:13 PM To: CF-Talk Subject: OT - MS SQL help Is it possible to join two tables, and have a list of keys returned from one of the tables as a column of a recordset? tblOnePK| name 1 | threeFriends tableTwoPK |

OT - MS SQL help

2002-09-12 Thread Smith, Matthew P -CONT(DYN)
Is it possible to join two tables, and have a list of keys returned from one of the tables as a column of a recordset? tblOnePK| name 1 | threeFriends tableTwoPK | tblOneFK 1 | 1 2 | 1 3 |