"aggiechick717" wrote:

> I am having some issues with RS. Basically I have a sproc that returns
> all of the data I need. I am trying to enchance the sproc to make it
> only contain a delivery system(one of my columns) that has only one
> meter( another column). Right now it is pulling every delivery system
> and meter in my database. I tried using count to count the rows and if
> there was a delivery system name repeated not to display it. Anyone
> have any ideas what to do next? Should I create another sproc maybe?
> Any help would be greatly appreciated!!
>
> Here is the code for the last select statement in my sproc if it helps:
>
>
>
> SELECT A.District
>
> , A.FieldOffice
>
> , A.DelSysID
>
> , A.DelSysCode
>
> , A.DelSysName
>
> , A.ZoneID
>
> , HZ.HdrName
>
> , A.GasMeterHID
>
> , HG.HdrName as MeterName
>
> , A.MeterCode
>
> , A.MeterType
>
> , A.MeterAttr
>
> FROM #MetersInDelSys A (TABLOCKX)
>
> INNER JOIN CHK..fbMasHdr HZ (NOLOCK) ON HZ.HdrHID=A.ZoneID
>
> INNER JOIN CHK..fbMasHdr HG (NOLOCK) ON
> HG.HdrHID=A.GasMeterHID
>
> INNER JOIN (SELECT DelSysID
>
> , count(*) as num
>
> FROM #MetersInDelSys
>
> GROUP BY DelSysID
>
> HAVING count(*) = 1) G1 ON
> G1.DelSysID=A.DelSysID
>
>
> order by a.district
>