Hello all, I am in need of an SQL query that would list the following:
For all plans named "Unlimited" with a next bill date in excess of x number of days ahead, list lastname, firstname. We have had occasion of people switching plans from a yearly account to a monthly account and missing the bill date of 12 months to 1 month. We are running SQL 2000, and Rodopi 5.3. Thanks so much! Dan Walker [EMAIL PROTECTED] HTTP://www.Stateline-ISP.com 815-248-3023 --------------------- To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body. Please also visit the Rodopi FAQ at http://www.rodopi-faq.com ---------------------
