[thelist] Data Shaping and Count
Joshua Olson
joshua at waetech.com
Mon May 9 10:36:13 CDT 2005
> -----Original Message-----
> From: Michele Foster (WizarDev)
> Sent: Monday, May 09, 2005 11:17 AM
>
> I have this query ....
>
> strShapeSQL = "SHAPE... (complex query here...)"
>
> Which gives me,
>
> JobTitle1 (PositionEn)
> Applicant1 (FirstName, LastName)
> Applicant2
> Applicant3
>
> JobTitle2
> Applicant1
> Applicant2
> etc.
Michele,
Before we delve into a solution for your other problem... is there a real
need here for data shaping? Have you tried to tackle this with normal SQL
and some creative output looping?
<><><><><><><><><><>
Joshua L. Olson
WAE Tech Inc.
http://www.waetech.com/
Phone: 706.210.0168
Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/
More information about the thelist
mailing list