I have created a report that gives totals for the year by quarter. however I want to use not the calender quarter but the fiscal quarter, how can I do that?
I got a free zip code file from the US gov. It is from the 1990 cencus. I want to offer a search on my site quite abit wider than most zipcodes, say 30 miles from the zip. All the searches would be in the US, and the file has the longitude and latitude for each zipcode. This looks like it sh...
I have a table in my MySQL database which contains two (relevant) columns. the two columns (we'll call them foo and bar) both consist of non-unique integers.I want to select all distinct values of "foo" which contain each of several values for "bar". For example:foo bar----12 3...
i have been having the same problem and trying to connect over a week now. i have been to like 30 websites maybe a 100 but to no advail the situation look grim. if you got the answer could you please meial it to me thanks rodrick....
Database & Application Miscellaneous New questions
I want to create a database of office locations that can be searched based on zip codes. Does anyone know where I can get zip code and/or longitude/latitude data, and how to process it....
Will anyone ever get tired of tracking down the proper form the date portion of an SQL string should take. Well I've got one now that is part of the Insert and don't have a whole lot to go on. The File that is being written to is called xxxx.dbf. It will open in VisualFoxPro but I was...
I was very possitive with Cyber Titan, until last Tuesday, when all websites hosted by Cyber Titan went down. Today it's Saturday and all websites are not working...I should also mention that CyberTitan has not replied to any of our emails, faxes and phonecalls!...
Hi;This is probably an easy one, but I've been hunting for the answer for anhour and thought I would just send it in and see if anyone knows.I want to use xp_sendmail to send the results of a query to someoneone.I can send mail using xp_sendmail when in the master database, but when Iget out to...
Does anyone have an example of how to use xp_sendmail with the @attachmentparameter? Can you specify the path to the file? If not where does it defaultto?Cheers...
Hi,when I call xp_logerror in SqlServer, the event is logged and can be seenvia the event viewer (as expected). The source of the event is set as SqlServer(and category as Server), again as expected. However, I don't want to blameSQLServer for this problem.Q. Is there some way that I can change...
Hi,After finding out, i can't create extended store procedures with VB 6 i went down the road of creating my own EXE that will get executed with SQL servers xp_cmdShell.Problem:Once the small exe had been created i had tried running it from sql server query analyser and nothing happened. I then...
We are working with a database group and the DBA will not give us right tothe xp_cmdshell in the master database. We wanted to use this command toexport data from Visual Basic based on certain criteria. I heard there isa way to use a object in VB call DMO but I can't find any information, can...
I am trying to run xp_cmdshell from a within a stored procedure which will take in 2 arguments...EXEC @li_return = xp_cmdshell @ls_cmd @ls_cmd2where my arguments are defined as follows:SELECT @ls_cmd = "echo To: " +@ls_address +"\\r\\nSubject: Commissions...
Database & Application Miscellaneous Related Categories