> 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:
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
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 |
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 |
4 matches
Mail list logo