------_=_NextPart_001_01BF8027.96882D50
Content-Type: text/plain;
charset="iso-8859-1"
How about...
UPDATE MasterAccounts SET BilledThru = maExpireDate, PaidThru = maExpireDate
-----Original Message-----
From: Gulam Chagani [mailto:gulam@catsgroup.com]
Sent: Saturday, February 26, 2000 12:33 AM
To: emerald@iea-software.com
Subject: Re: [Emerald] help with SQL query
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 -----
From: Nathan <mailto:nhaywood@whro.org> Haywood
To: 'emerald@iea-software.com' <mailto:'emerald@iea-software.com'>
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
<mailto:gulam@catsgroup.com> ]
Sent: Friday, February 25, 2000 3:32 PM
To: emerald@iea-software.com <mailto: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 <http://www.cats-net.com>
------_=_NextPart_001_01BF8027.96882D50
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
------_=_NextPart_001_01BF8027.96882D50-------Original Message-----
From: Gulam Chagani [mailto:gulam@catsgroup.com]
Sent: Saturday, February 26, 2000 12:33 AM
To: emerald@iea-software.com
Subject: Re: [Emerald] help with SQL queryThanks 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 -----From: Nathan HaywoodSent: Saturday, February 26, 2000 12:40 AMSubject: RE: [Emerald] help with SQL querySELECT 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 queryHi,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