Hi guys i have a table with shifts history along with emp ids
im using this code to retrieve a list of employees and their total shifts by specifying the range to count from:
SELECT ope_id, count(ope_id)
FROM operator_shift
WHERE ope_shift_date >=to_date( '01-MAR-10','dd-mon-yy') and ope_shift_date
<= to_date('31-MAR-10','dd-mon-yy')
GROUP BY OPE_ID
which gives
OPE_ID COUNT(OPE_ID)
1 14
2 7
3 6
4 6
5 2
6 5
7 2
8 1
9 2
10 4
10 rows selected.
NOW how do i choose the employee with the highest no of shifts under the specified range date, please this is really important
I am using Subversion with some files that are managed by another application. I would like to rename the files, but the rename must be done from within the application so that it correctly updates its own metadata. This means that I cannot simply use SVN's rename command — the application's metadata will become inconsistent.
So how can I can I tell SVN that the files in the working copy have been renamed by this application, so that it preserves history in the same way as per the rename command?
I'm currently writing an app in C# using using Visual Studio. As such, VS2010 created a Solution directory with my project directories inside.
So my Hierarchy is like this:
Solution
.git
project1
project2
What I'd like to do is make it like this:
Solution
Project 1
.git
Project 2
As of right now the files in the solution are tracked, except for the project 2 (so stuff like project.sln for example).
Is there a way I can do this without rewriting the history?
Thanks in advance.
I'm surprised by the number of general education classes computer science students must complete to get their bachelors. For example, I must take:
three English classes
two history classes
public speaking
economics
biology
I hardly think these general education requirements are unique to the university I attend. My question is (for those of you who have degrees), in what ways have these general education requirements improved your career as a programmer?
We all know how to use <ctrl>-R to reverse search through history, but did you know you can use <ctrl>-S to forward search if you set stty stop ""? Also, have you ever tried running bind -p to see all of your keyboard shortcuts listed? There are over 455 on Mac OS X by default.
What is your single most favorite obscure trick, keyboard shortcut or shopt configuration using bash?
Reading online about this topic is confusing. Is there a way to cut around the history, politics and technicalities to answer the question: Which standard should I refer to when I write code to generate feeds?
I want to use UTF-8 encoding, which may affect the choice. Otherwise I'm most interested in compatibility with a decent range of readers.
How long will a browser remember a "a:visited" link? Assuming the method isn't uniform across browsers - an answer for any individual browser (or as many as you know) would be helpful.
Also, under which type of memory is it stored? "Web History"? Cache?
If I drag and drop tracked .cs files to new folders in VS2008 with VisualSVN what message should I see when I commit the .cs file? I see added (+) shouldn't I see a "move"?
I'm asking because I'm getting ready to do a major refactoring (including moving lots of files) and I don't want to lose my version history on these files.
Note: I'm very new to Subversion, TortoiseSVN, and VisualSVN.
My company unwittingly switched from cvs to subversion and now we're all wishing we had cvs back.
I know there's tools to migrate history and changes from cvs to svn and there's no equivalent to do the reverse.
Any suggestions or ideas on how to do this?
I'm really interested if someone knows a programming language that uses an image like Smalltalk...
I think that is one of the greatest ides in the history of computer science.. I can not find other language besides Smalltalk that is base on an image.
I'm customizing work item templates in TFS 2008 through the PowerTools and I'm wondering is it possible to hide a field (or it's value) for certain users?
For example, let's say I open TFS to my clients so they can submit feature requests. I'd like them to see the work item created, to see the history, changes etc. but I'd like to keep some of the field private and for our internal use.
Is it possible?
I'm working with big blobs of JSON. These blobs change slightly over time and a revision history is kept. I'd really like to be able to do a visual diff on them, but my problem is they're being stored without any formatting at all - everything is on one line, so that makes it a little hard to see what changed.
Is there a good way to programatically format them ala http://jsonformat.com/ or http://jsonformatter.curiousconcept.com/?
I made the mistake of creating a Subversion repository without the usual trunk, branches, and tags directories. That is, the root directory of the project maps to the root directory of the repository. Now I want to create a feature branch, but there's no good place to put it. What I'd like to do is move / to /trunk, preserving its properties and history. Am I out of luck?
is it possible to in-place replace the entire html document?
i tried jQuery("html").html("....")
but style information does not survive.
i'm trying to avoid using data uri because i do not want the generated document to be stored in the browsers history
Im using updatepanel in my screen..
i have 2 pages
when i click submit button in page1 then it ill be redirect to page2 ....in page2 i have one back button..i wrote click event onclick="history.go(-1)"
when i click back it just redirect to page 1 but records already showned in page1 not displayed .how can i sove this problem?
cai i use any scriptmanager?
Let's take for example a single file committed in CVS with the following history.
test.cpp
rev 1.1
rev 1.2
rev 1.3
How do I revert to rev 1.2 discarding the changes in 1.3 and then continue to make modification from that point on?
I'm trying to run down when a particular bug was created, but wading through the history is pretty time consuming. Is anyone familiar with a command line method to get a list of revisions where a line or range of lines changed?
svn and vault evangelists: I know, right....but you can't always pick the environment....
I have several separate SVN repositories locally on my machine and I use only the TortoiseSVN client functionality without an SVN server backend.
Now I want to merge these repositories while keeping the revision history of individual files. Is that possible with with TortoiseSVN alone or even SVN?
I'm getting a problem here when i try to logout, the session is destroy but i still can go inside to that page and view details without login first by using browser mozilla Back button or history cache! How can i solve that? Anybody help me please...
code for logout is
If I publish my project now, with added license information, will the license still apply to the project if one goes back a few commits in the history to a state where I hadn't yet added any license information?
[Relevant answer][1]
[1]: http://stackoverflow.com/questions/2468566/correctly-applying-an-open-source-license/2468663#2468663 Relevant answer
This suggests that unless there is some license information available, no rights are granted. Is that true in this case too? Or will the license I added in the last commit also apply to older commits?
In my setup I have a central Hg repo to which I'm pushing my local changes. Say in my local clone I have a series of local commits and then I want to push the changes to the central repo. How can I push only the final state without including all of the "small" local commits that I made?
I want this because sometimes I dont want to pollute the central repo's history with all of the small local commits that I made.
We use Visual Studio 2008, with visual source safe v8. Lately, I seem to be getting a lot more crashes than usual, mainly when viewing history (comparing, etc.).
I have taken a screencapture of the series of dialog boxes that will always appear, leading up to the crash:
http://img529.imageshack.us/img529/1360/msvscrash.jpg
Does anyone know what could be causing this? Thanks.
I tried something like, below in popup-window, but not working...
any correction at line 3, please suggest.
function closePopup() {
window.opener.history.go(0);
$(opener.document).ready(function(){
window.opener.some_function(some_variable);
self.close();
});
}