Re: [Emerald] help with SQL query

Gulam Chagani ( (no email) )
Sat, 26 Feb 2000 08:32:30 +0300

This is a multi-part message in MIME format.

------=_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">

Thanks Nathan for your =help.
 
I have one more problem. We =recently did a=20conversion of our DB to Emerald, In the new DB the expiry dates for all =the MBRs=20are correct but not all Billed thru and paid thru dates are correct. Can =someone=20help me with a SQL statement which will change all the billed thru and =paid thru=20dates to match the expiry date for that MBR.
 
I will really appreciate any =help.
 
Gulam Chagani
 
 
----- Original Message -----
From:=20 Nathan =Haywood=20
To: 'emerald@iea-software.com'
Sent: Saturday, February 26, =2000 12:40=20 AM
Subject: RE: [Emerald] help =with SQL=20 query

SELECT 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 query

Hi,
 
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
http://www.cats-net.com
=
 
------=_NextPart_000_0035_01BF8034.0587BDE0--