Search Results

Search found 23226 results on 930 pages for 'date format'.

Page 480/930 | < Previous Page | 476 477 478 479 480 481 482 483 484 485 486 487  | Next Page >

• Count of products NOT sold...per store, per day over the past month

  - by user1893510

  I'm struggling with an interview question. 3 dimension tables (Product, Store and Date) and 1 fact table (Sales). The question asks for a T-SQL solution that will return the count of products not sold, per store, per day over the past month. At this point, my answer is futile but I've spent significant time trying to back into a solution, to no avail, and would like to close the loop. Any guidance is greatly appreciated.

  Read the article

• What is better for PHP developer - Unicode or UTF-8?

  - by Ole Jak

  What is better for PHP developer - Unicode or UTF-8? I am going to create international CMS. So I am going to have clients all over the werld. They will speak all posible languages. What encoding format is better for browser recognition and for DB data storing?

  Read the article

• LINQ how to add an order by to this statement?

  - by JL

  I have the following LINQ that I would like to also order by file creation date, how is this done? taskFiles = taskDirectory.GetFiles(Id + "*.xml") .Where(fi => !fi.Name.EndsWith("_update.xml", StringComparison.CurrentCultureIgnoreCase)) .ToArray();

  Read the article

• how to identify a file is a text file or other using c#.net

  - by bjh Hans

  I need to access a file as text file and want to process it later. But before I fetch it how I can identify a file that I am taking is a text file only. If file is in another format my whole code interpret wrongly. I want to access and process only text file. Currently i am using: StreamReader objReader = new StreamReader(filePath); How can I do so in C# .NET?

  Read the article

• selecting rows with unidentical values appearing in two different columns in R

  - by bazon

  Hi, I need to create a new data frame that excludes dams that appear in "dam1" and "dam2" columns on the same fosdate (fostering date). I tried df <- df[df$dam1!=dam2,] but could not work. dam1 and dam2 are dam or mother id's. my df: fosdate dam1 dam2 8/09/2009 2Z523 2Z523 30/10/2009 1W509 5C080 30/10/2009 1W509 5C640 30/10/2009 1W509 1W509 1/10/2009 1W311 63927 The new data frame that I need to get is: dfnew: fosdate dam1 dam2 30/10/2009 1W509 5C080 30/10/2009 1W509 5C640 1/10/2009 1W311 63927 Thanks, Bazon

  Read the article

• spatial indexing mysql

  - by shaiju

  i have to integrate spatial indexing in mysql .i got an example i almost done it.in that example INSERT INTO address VALUES('Foobar street 12', GeomFromText('POINT(2671 2500)')); inplace of 2671 and 2500 i have to insert latitude and longitude in below format 35.177 ,-77.11. How is it possibe .Please help me

  Read the article

• filtering and though a sharepoint list items with powershell

  - by naijacoder

  I have tried below but not getting any result back Not sure if i'm doing this well. Can i filter in the foreach or in my if statement Thanks in advance [DateTime] $CreatedDate = $item["Created"] $convertedCreatedDate = $CreatedDate.ToString("yyyy-MM-dd") $today = (Get-Date).AddDays(-1).ToString("yyyy-MM-dd") foreach ($item in $list.items | where {$convertedCreatedDate -eq $today}) { if ($list.items | where {$convertedCreatedDate -eq $today}) { Write-Host $item["Created"] } Write-Host $item["Created"] }

  Read the article

• sql query not executing

  - by sarah

  Hi, Not able to execute a query ,i need to check if end date is greater than today in the following query Getting an error invalid query select * from table1 where user in ('a') and END_DATE >'2010-05-22' getting an error liter string does not match

  Read the article

• Duration between two dates in Groovy

  - by UltraVi01

  Is there a way in Groovy to get the duration between two Date objects? The duration format I'm looking for would be something like: 2 days, 10 hours, 30 minutes... Thanks

  Read the article

• How can I email someone a git repository?

  - by Zubair

  I have tried: git archive HEAD --format=zip > archive.zip :and then I email archive.zip and at the other end they unzip archive.zip into a folder. But when they try any git commands they find out that this does not produce a valid git repository

  Read the article

• How do you read a cell's value from an OpenOffice Calc .ods file with python?

  - by user329257

  I have been able to read an excel cell value with xlrd using column and row numbers as inputs. Now I need to access the same cell values in some spreadsheets that were saved in .ods format. So for example, how would I read the value stored in cell E10 from a .ods file from python?

  Read the article

• How to remove the port number from a url string

  - by Brono The Vibrator

  I have the following code snippet: string tmp = String.Format("javascript:window.open('{0}');", url); ClientScript.RegisterClientScriptBlock(this.GetType(), "NewWindow", tmp); the url generated by this code include the port number and I think that is happening becasue port 80 is used by the website and in this code I am trying to load a page from a virtual directory of the website. Any ideas on how to supress the port number in the url string generated by this code?

  Read the article

• Detect if HTTP request is from browser / Flex asynchronous request?

  - by Andree

  Hi there! When Flex application make an asynchronus HTTP request, does it add a special header to the request, like some JavaScript framework does? Something that indicates whether this request is an AJAX call/not. I just want my server side code to return different response format, depending on whether the request is made from browser/flex. Regards, Andree.

  Read the article

• How can I parse through a texutre in DirectX? (IDirect3DTexture9*)

  - by meds

  I've been trying to figure out how to parse textures in directx for two reasons: to write my own texture format and to manipulate data in existing IDirect3DTexture9 type textures. I've been looking at the IDirect3DTexture9::LockRect() function but I'm unsure how it works, are the void* pBits I get out of it in D3DLOCKED_RECT the data in the texture? Does that mean I can read it in by converting it to D3DXCOLOR or something? Really not sure where to go, any help would be appreciated!

  Read the article

• calendar.getInstance() or calendar.clone()

  - by Pangea

  I need to make a copy of a given date 100s of times (I cannot pass-by-reference). I am wondering which of the below two are better options newTime=Calendar.getInstance().setTime(originalDate); OR newTime=originalDate.clone(); Performance is of main conern here. thx.

  Read the article

• Powershell in CruiseControl.net to backup existing folder before deploying new version of the code

  - by Rihan Meij

  Hi I would like to zip a bunch of files (.exe and .dll) before I overwrite them with the new build. Is there a simple way to zip files without using some sort of dll? Just creating a folder with the build number / date time stamp will also work great. How do I pass parameters from the cruise control build process into my Powershell script that will do the work then? Is this a sustainable way to do things? Thanks

  Read the article

• Memory Size Allocation on GPU - opengl texture loading question

  - by beyondsleepytime

  I'm loading pixels from an image which is 32 w by 32 height. The format I'm loading them in is ARGB via java. When I bind this to the video card, I can expect that the video card might use somewhere around 32*32*4 bytes, or 4K. Similarly, 1024 w, 1024 h would be 1024*1024*4 = 4MB. Is my understanding correct? Now I understand where all the memory goes!

  Read the article

• what does 'legend' mean in sql?

  - by every_answer_gets_a_point

  im doing some practice sql problems one of the questions is: Prepare a shipping statement for customer 'C001' it should show the date, the legend 'Delivery' and the total value of the products shipped on each day. 'delivery' is not a table nor is it a column in any table. what does legend mean??

  Read the article

• Convert historic dates from utc to local time

  - by Espo

  I have an sql table with data like this: | theDate (datetime) | theValue (int) | ---------------------------------------- | 2010-05-17 02:21:10 | 5 | | 2009-03-12 04:11:35 | 23 | | 2010-02-19 18:16:53 | 52 | | 2008-07-07 22:54:11 | 30 | The dates are stored in UTC format in a datetime column, how can I convert them to local time (Norway)? Remember that the UTC-offset is not the same all year because of winter/summer-time.

  Read the article

• Mod_rewrite - How to tell Google to dynamically delete pages from their index after 7 days

  - by Sattvic

  Search engines like to crawl and index webpages or URLs, but what if your webpages/URLs have expired content and you do not want them to be indexed after so many days? Can you put an expiration in the URL and have mod_rewrite 301 redirect pages after a given expiration date? Or maybe a cron job to add a 301 redirect header to all expired pages?

  Read the article

• whats the best way to join an array into a readable list

  - by Ross

  I've got an array listing days of the week: days = ['Monday', 'Tuesday', 'Wednesday'] Whats the easiest / best way to output it in a human readable format: Monday, Tuesday and Wednesday The best I have is a rather ugly: ', '.join(days[:-2]+['']) + ' and '.join(days[-2:])

  Read the article

• How to concatenate all commit messages from subversion into one text file with no metadata?

  - by user144182

  I would like to take all the commit messages in my subversion log and just concatenate them into one text file. Each commit message has this format: - r1 message - r1 message - r1 message What I would like is something like: - r1 message - r1 message - r2 message - r2 message - r3 message [...] - r1000 message Update I thought the above was clear, but what I don't want in the log is this type of info: r2130 | user| 2010-03-19 10:36:13 -0400 (Fri, 19 Mar 2010) | 1 line No meta data, I simply want the commit messages.

  Read the article

• jQuery to store data for sessions

  - by Ted

  I am trying to use jQuery AJAX. What my requirement is, i wish to load user names from DB in dataset, convert it to JSON format and store it in memory or using jQuery data for use while a user is browsing my site, i.e for a session. This way I can use autocomplete or my own code to display data to user. Can anyone help me design such a scenario?

  Read the article

• Testing + production server and syncing MySQL data

  - by Matthew

  I have a web application running on LAMP with a testing server and a production server. Is there a standard practice for keeping the data on the testing server in sync with the production server? The data on the testing server gets out of date pretty quick and I feel like there must be an easier way than just dumping the production server and copying it onto the testing server every so often. It's not important that the data is in total sync, just that the testing server represents the production enviornment as accurately as possible.

  Read the article

• How and what benefit i can take from included Sizzle.js along with jquery 1.4.2?

  - by metal-gear-solid

  latest jquery 1.4.2 downloaded from jquery.com comes with Sizzle.js also. How and what benefit i can take from included Sizzle.js? /*! * jQuery JavaScript Library v1.4.2 * http://jquery.com/ * * Copyright 2010, John Resig * Dual licensed under the MIT or GPL Version 2 licenses. * http://jquery.org/license * * Includes Sizzle.js * http://sizzlejs.com/ * Copyright 2010, The Dojo Foundation * Released under the MIT, BSD, and GPL Licenses. * * Date: Sat Feb 13 22:33:48 2010 -0500 */

  Read the article

< Previous Page | 476 477 478 479 480 481 482 483 484 485 486 487  | Next Page >