in reply to
(OT) Where is T-SQL's join function?
You would be better off asking on the microsoftsqlserver Yahoo group as your question is a MS TSQL question. I recommend using an user defined function to do what you want. An example of an SQL UDF.
Jason L. Froebe
Blog, Tech Blog
A Programming Language, 1962
Programming the 1900 series in COBOL, 1974
Algorithms + Data Structures = Programs, 1976
The C Programming Language, 1978
System V - Interface definition, 1986
Z80 Assembly Language Programming, 1979
TheSOURCE User's Manual, 1979
The C Primer, 1983
Interactive Fortran 77, A Hands on Approach, 1984
Perl.1 man page, 1991
Results (346 votes),