Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2014 (Bloomington, MN) with: Hemant Khandelwal
Ben Nadel at cf.Objective() 2014 (Bloomington, MN) with: Hemant Khandelwal@khandelwalh )

Dave

Member since Oct 27, 2009

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 gridview to automa... read more »