I am curious is anyone has a fairly straightforward way of zipping subscription contents? This could be Excel content that is to be either sent via e-mail of delivered via filesystem. A checkbox to zip the contents would be very handy.
All, I am trying to find all the zipcodes in the radius of 5 miles. I have the lat lon for the originating zip code. I have looked at the haversine formual but that requires two lat lon's for it to work, I only have one of each. Any help would be greatlyappreciated.Gary Abbott...
Hi Every body,I had transfered the data of a table in a text file and the file size is 2GB.Now i want to compress or zip it through sql sever.Do anybody have any idea about this.any help will appreciated...
Do any one know who to zip the files. Here is the deal... I am sending tab delimited files from one folder and i want to zip the file once the files are send and then delete those files as i would have backup in the format of zip file. Do any one know regarding the aforesaid.. ie. folder X ...
Hey, i need some help with my query structure.. I have my zip code database, and then a listings table, with a zip code in one of the columns. I want to return all that data from both frields where the zip code radius results are. here's my stored procedure:*removed*Any ideas?...
Hi there,i am making a spellChecker as well as Microsoft is provided, i have done all most except one point.that is zig zek line under wrong spell.in word whever we type a wrong spell a red zig-zeg line comes under the word that is what still i am not able to complete it.any one who has some ...
am using a line chart to display series of results over time - data is got from and AnalysisServices cube.problem is that sometimes there is no value for the result - and the chart doesnt display that as zeroe.g. with the following dataweek 1 10 itemsweek 2 12 itemsweek 3 14 items week 4 8 ...
We have a float (length = 8) field in the table. We want to store values outot 4 decimal places. In some cases, where a value ended in 0 or 00, theplaces are probably truncated (e.g., 38.9560 = 38.956 or 38.6500 = 38.65). Iwould like for us to see the field value out to 4 places. In other wordsw...
Should the checkpoint file stick around, when a package is cancelled from management studio? Infact, that's exactly what it does, even if there are no restart points(FailPackageOnFailure=false on all containers). The net effect, isthat a cancelled package will restart at the point of failure, ...
One of my apps impliments log shipping. It does not use any of the log shipping stuff in SQL Server, so every 15 minutes it issues a BACKUP LOG statement. It all works :)Every so often, maybe once every two days, I get a zero length log. No error. When the next log is backed up it ships across f...
XMLA Browser version 1.1 is now available. The name has been changed to"Report Portal" because it now does little bit more than OLAP. You candownload it from http://www.reportportal.com/. Thehttp://www.xmlabrowser.com/ will point to the same site.The "Report Portal" now supports the following fe...
I currently use N2 to format my field to 2 dec places. However it also formats whole numbers to 2 decimal places. Is there a way to format non-whole numbers to 2 dec places and leave whole numbers as is? cheers...
I provide for complete creation of a database in SQL Express from a script.When the moon is in the seventh house and Jupiter lies in Mars, it workswonderfully.HOWEVER, if I have used any external tool to look at the db such as the IDEor the SQL Manager Express, then I suspect but do not know tha...