Recent content by bnye

All - I have a database GeoData on Sql Server 2000 Standard. The database does not want get started. In the log I see the following: Starting up database 'GeoData'. Starting up database 'GeoData'. Starting up database 'GeoData'. Starting up database 'GeoData'. Starting up database 'GeoData'...

Hello All, I have a JFrame that contains a JSplitPane. In that JSplitPane I have a new class that extends JPanel ("SortedPortfolioPanel") in the leftComponent and a new class that extends JPanel ("FilterMarketPanel") in the rightComponent. In JPanel...

Terry and bperry, Thank you both for the responses. I like both ideas, but chose to go with Terry's in order to keep the date object provided by SQL. It is working great! I am not sure how liberal useres are supposed to be with "Most helpful" marks so I will only designate one...

Terry and bperry, Thanks for your resposnses. That did not seem to return any values, although I know values exist. Is there another route that I should look into. Thanks, bnye

All, I am new to SQL, and would like to select records where the date corresponds to todays date - 1 month. I have heard of ADD_MONTH in other platforms, but that doesn't help me out in this SQL 2000 case. The statement that works for todays year - 1 year is: SELECT SUM(premium) FROM...