862 2006-05-19 6.241603 5.774208 863 2006-05-20 NA NA 864 2006-05-21 NA NA 865 2006-05-22 6.383929 5.906426 866 2006-05-23 6.782068 6.268758 867 2006-05-24 6.534616 6.013767 868 2006-05-25 6.370312 5.856366 869 2006-05-26 6.225175 5.781617 870 2006-05-27 NA NA I have a da...
Short version: How can I map two columns from table A and B if they both have a common identifier which in turn may have two values in column C Lets say: A --- 1 , 2 B --- ? , 3 C ----- 45, 2 45, 3 Using table C I know that id 2 and 3 belong to the same item ( 45 ) and thus "?" in table B should be 1. What query could do ...
I am having a problem with data not updating on the CRM at my wife's office. Scenario: User loads the app. Data from the DB populates the master view. User opens edit screen. Data is populated for the correct detail item. User changes a value (on any field). The save button becomes active with the data change. The user clicks ...
Is there a variant of lag somewhere that keeps NAs in position? I want to compute returns of price data where data could be missing. Col 1 is the price data Col 2 is the lag of price Col 3 shows p - lag(p) - the return from 99 to 104 is effectively missed, so the path length of the computed returns will differ from the true. Col 4 shows...
I have a very simple page that is displaying canned data. I experienced this problem with data from a DB so I made this simple example and still have the issue. When this page is navigated to for the first time for a session, the first column in the first row shows no data. It doesn't matter if I change the scope to request or session...
Given these tables table Channel -------------- ChannelID int IDENTITY <other irrelevant stuff> table Program -------------- ProgramID int IDENTITY ChannelID int AiringDate datetime <other irrelevant stuff> and this query SELECT C.ChannelID, t.AiringDate FROM Channel C LEFT JOIN ( SELECT distinct ChannelID FROM Pr...
I hope I am not missing something very simple here. I have done a Google search(es) and searched through stackoverflow. Here is the situation: For simplicity's sake let's say I have a table called "PeoplesDocs", in a SQL Server 2008 DB, that holds a bunch of people and all the documents that they own. So one person can have several ...
I have the following table which records a value per day. The problem is that sometimes days are missing. I want to write a SQL query that will: Return the missing days Calculate the missing value using linear interpolation So from the following source table: Date Value -------------------- 2010/01/10 10 2010/01/11 ...
I have a remote that is the same, or similar, to the rails project in my current directory. To sync the two, I do git init git remote add origin blah@blah git pull The problem is that some of the files I had in my working copy were added (ie not in the remote), so when I do git status it should show a bunch of untracked files. Ins...
I am attempting to take a screenshot of a window using C# .NET by calling Windows API. I came up with the following code: public void ScreenshotWindow(IntPtr windowHandle) { Rect Rect = new Rect(); GetWindowRect(windowHandle, out Rect); int width = Rect.right - Rect.left; int height = Rect.bottom - R...
Hello, I have cell array each containing a sequence of values as a row vector. The sequences contain some missing values represented by NaN. I would like to replace all NaNs using some sort of interpolation method, how can I can do this in MATLAB? I am also open to other suggestions on how to deal with these missing values. Consider t...