------=_NextPart_000_0035_01BF8034.0587BDE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks Nathan for your help.
I have one more problem. We recently did a conversion of our DB to =
Emerald, In the new DB the expiry dates for all the MBRs are correct but =
not all Billed thru and paid thru dates are correct. Can someone help me =
with a SQL statement which will change all the billed thru and paid thru =
dates to match the expiry date for that MBR.
I will really appreciate any help.
Gulam Chagani
----- Original Message -----=20
From: Nathan Haywood=20
To: 'emerald@iea-software.com'=20
Sent: Saturday, February 26, 2000 12:40 AM
Subject: RE: [Emerald] help with SQL query
SELECT CustomerID FROM SubAccounts GROUP BY CustomerID HAVING =
COUNT(AccountID) > 1
-----Original Message-----
From: Gulam Chagani [mailto:gulam@catsgroup.com]
Sent: Friday, February 25, 2000 3:32 PM
To: emerald@iea-software.com
Subject: [Emerald] help with SQL query
Hi,
Can someone help me formulate a query to get all MBRs which have =
more than 1 service associated with it.
Help much appreciated.
Gulam Chagani
http://www.cats-net.com
------=_NextPart_000_0035_01BF8034.0587BDE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
------=_NextPart_000_0035_01BF8034.0587BDE0------- Original Message -----From:=20 Nathan =Haywood=20Sent: Saturday, February 26, =2000 12:40=20 AMSubject: RE: [Emerald] help =with SQL=20 querySELECT CustomerID FROM =SubAccounts GROUP=20 BY CustomerID HAVING COUNT(AccountID) > =1-----Original Message-----
From: Gulam Chagani =[mailto:gulam@catsgroup.com]
Sent:=20 Friday, February 25, 2000 3:32 PM
To: emerald@iea-software.com
=Subject:=20 [Emerald] help with SQL queryHi,Can someone help me formulate a =query to get=20 all MBRs which have more than 1 service associated with =it.Help much appreciated.Gulam Chagani=