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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.