Community Member Profile
Dave
Member since Oct 27, 2009
- Profile: /members/4623-Dave.htm
- Comments: 1
- Points: 10
Recent Blog Comments By Dave
-
Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)
Posted on Oct 27, 2009 at 9:50 PM
Hi J.D, If you can join ECRPYHS and ECRHDHS, it should be easy to join PAYINFO as well. It looks like PAYINFO.PYNO is related to ECRPYHS.HPYNO Once you have the joined table, you can use the crosstab stored procedure below to create the cross tabbed table. You can then tell... read more »
