I want to develop an application in which user can  allocate      time schedule to their group members, the issue is suppose I have already      schedule two different time and now again want to schedule time for the same      day then how I will check that the same time schedule is not already      allocated or not   Date    Start Time  End Time    status   15-09-2017  10:05   13:10   TRUE 15-09-2017  10:00   14:00   FALSE  because 10:00-13:10 is already scheduled 15-09-2017  08:20   09:00   TRUe 15-09-2017  09:30   10:05   TRUE 15-09-2017  09:40   10:05   false  `
I have two tables, both with start time and end time fields. I need to find, for each row in the first table, all of the rows in the second table where the time intervals intersect.  For example:             &lt;-----row 1 interval-------&gt; &lt;---find this--&gt; &lt;--and this--&gt; &lt;--and this--&gt;   Please phrase your answer in the form of a SQL WHERE-clause, AND consider the case where the end time in the second table may be NULL.  Target platform is SQL Server 2005, but solutions from other platforms may be of interest also.
Suppose I installed ubuntu with the user usr1 then I added usr2. I then create a group grp1 where this 2 users are added. A folder is owned by usr1 and has group grp1. But when I login as usr2 I cannot write. The folder has permissions 755...  usr2@kmserver:/media/data/www$ groups usr1 usr1 : grp1 ... usr2@kmserver:/media/data/www$ groups usr2 usr2 : grp1 ... usr2@kmserver:/media/data$ ls -l total 20 drwx------ 2 root root 16384 2011-05-12 10:53 lost+found drwxrwxr-x 2 grp1   grp1    4096 2011-05-12 15:15 www   Whats wrong? Why do non-hydrogen atomic orbitals have the same degeneracy structure as hydrogen orbitals? Changing color and fonts of itemize If your application requires a database and it comes with built in data, what is the best way to ship that application? Should I:   Precreate the SQLite database and include it in the .apk? Include the SQL commands with the application and have it create the database and insert the data on first use?   The drawbacks I see are:   Possible SQLite version mismatches might cause problems and I currently don't know where the database should go and how to access it. It may take a really long time to create and populate the database on the device.   Any suggestions? Pointers to the documentation regarding any issues would be greatly appreciated. Recently, I found this , that allows you to generate a 3D model from a 2D image.   It works very well and you can download an OBJ file. Vertex are colored and when I import it using Blender, I can't see any Vertex color.   Using Cycle (I prefer a internal solution if it exists) according to some answers I've found on Blender Stack Exchange, I patched some nodes : Attribute -> Diffuse BDSF -> Material Output.  Unfortunately, I can't get it works, the model stills black.    When I open the OBJ file, I see that color per vertex are there :  v 43.747554 107.000000 69.000000 0.470588 0.380392 0.309804 v 43.780163 115.000000 64.500000 0.427451 0.337255 0.266667 v 43.782527 107.000000 68.500000 0.470588 0.380392 0.309804 v 43.801902 115.000000 65.000000 0.427451 0.337255 0.266667 v 43.806461 107.000000 69.500000 0.470588 0.380392 0.309804 v 43.821703 115.000000 64.000000 0.427451 0.337255 0.266667 v 43.838352 108.000000 68.500000 0.466667 0.376471 0.305882 v 43.854670 106.000000 69.000000 0.482353 0.392157 0.321569 v 43.856176 108.000000 69.000000 0.466667 0.376471 0.305882 v 43.873876 106.000000 69.500000 0.482353 0.392157 0.321569 v 43.888855 110.000000 68.000000 0.466667 0.376471 0.305882 v 43.891471 109.000000 68.000000 0.466667 0.376471 0.305882 v 43.892733 110.000000 67.500000 0.466667 0.376471 0.305882 v 43.895170 108.000000 68.000000 0.466667 0.376471 0.305882 v 43.900904 109.000000 68.500000 0.466667 0.376471 0.305882 v 43.907584 107.000000 68.000000 0.470588 0.380392 0.309804 v 43.917898 115.000000 65.500000 0.427451 0.337255 0.266667 v 43.925000 111.000000 67.500000 0.454902 0.364706 0.294118   According to some answers here, Blender import more easily the vertex color of a PLY file so I tried to convert to PLY with two different sites :   1. meshconvert .com : Give me a 3.5 Mo file  2. greentoken.de/onlineconv : Give me a 2.3 Mo file  (Of course, if you know some other sites I could try, it interest me)  I guess that color data are lost with greentoken (not sure).   When I import the 3.5 Mo PLY file in blender, I need to be in textured display mode, then I think I see my vertex color value but in black &amp; white instead of RGB, that is weird. Anyway, I can't get it work  EDIT 1 : I opened PLY files and color vertex aren't there... I need to find a better converter   EDIT 2 : I tried www.ofoct.com/3d-model-file-for-3d-printer-converter it doens't take vertex color into account. In fact, in each PLY files I converted with the various sites here, there is a common line :      comment Created by Open Asset Import Library -    (v3.2.0)   (the version varies)  EDIT 3 : In fact it seems that model converted by Green token, keep the vertex color. That is weird because that's the smallest file :   ply format ascii 1.0 comment Created by Open Asset Import Library - http://assimp.sf.net (v3.1.187496374) element vertex 29793 property float x property float y property float z property float nx property float ny property float nz element face 59582 property list uint uint vertex_index end_header 82 103 6.37528 0.40963 0.0331735 0.911648 82 102 6.57043 0.272087 0.235193 0.933088 82.6603 103 6.5 -0.14071 0.043367 0.9891 82 103.935 6.5 0.201161 -0.136681 0.969976 81.5475 103 7 0.825371 0.0489484 0.562465 83 102 6.62244 -0.248588 0.147929 0.957247 83 103 6.56417 -0.411487 -0.0867124 0.907281 81.5819 104 7 0.787841 -0.0338904 0.614946 82 105 6.63886 0.0715144 -0.131383 0.988749 83 104 6.77321 -0.431167 -0.171652 0.885794 83.6781 102 7 -0.470137 0.061235 0.880467 83.6327 103 7 -0.543939 -0.0905203 0.834228 83 105 6.96709 -0.445324 -0.163091 0.880391 84 103 7.23724 -0.520118 -0.141377 0.842313 84 104 7.47775 -0.546517 -0.195833 0.814229 84 102 7.16782 -0.416323 -0.021798 0.908955 83.3508 101 7 -0.314426 0.156435 0.936304 84 101 7.22581 -0.280388 0.0301462 0.959413 84.9009 101 7.5 -0.339848 -0.0219793 0.940223 84.6939 102 7.5 -0.435242 -0.0925323 0.895546   As you can see, nx, ny and nz correspond to RGB values.. What is a magic number, and why is it bad? What is a magic number?  Why should it be avoided?  Are there cases where it's appropriate? Is the $\sum\sin(n)/n$ convergent or divergent? Possible Duplicate:          So, in my calculus class (one I'm teaching, not taking), the sum $\sum_{n=1}^\infty \frac{\sin(n)}{n}$ has come up a few times.  Unfortunately, as someone not exactly an expert in the convergence of sums, it seems to resist the few techniques I know.  Certain none of the usual first year calculus tricks (integral test, alternating series test, ratio test, etc.) work, and the only more tricky technique, partial summation, I can think of doesn't seem to work either (one would need that $\sum_{n=1}^N\sin(n)$ is bounded, which I believe is false).  It seems like it should converge, since it switches sign quite often, but on the other hand, the harmonic series can mess with your intuition, so I don't have much trust in that.  So, I ask to you:     Does this series converge? Security importance of Key Schedule in Block Cipher Why does ltablex skip a number in captions? The below example presents two tables with an tabularx environment (taken from package ltablex) and a caption. After each tabularx-table, the table counter skips one, as if both the caption and the tabularx environment increase it, while the latter shouldn't.  \documentclass{report} \usepackage{ltablex} \begin{document}  \begin{table} \caption{Caption 1.} % "Table 1" \begin{tabularx}{\linewidth}{|c|} empty table \end{tabularx} \end{table}  \begin{table} \caption{Caption 2.} % "Table 3" \begin{tabularx}{\linewidth}{|c|} empty table \end{tabularx} \end{table}  \end{document}   My reputation doesn't allow me to upload a picture, but the captions are Table 1 and Table 3 respectively. Why use definition lists (DL,DD,DT) tags for HTML forms instead of tables? Reset Windows 10 from USB How would one go about proving that the rationals are not the countable intersection of open sets? What's the difference between anonymous methods (C# 2.0) and lambda expressions (C# 3.0)? I have the formula $x! + y! = z!$ and I'm looking for positive integers that make it true. Upon  inspection it seems that x = y = 1 and z = 2 is the only solution. The problem is how to show it.   From the definition of the factorial function we know $x! = x(x-1)(x-2)...(2)(1)$  So we can do something like this:  $$ [x(x-1)(x-2)...(2)(1)] + [y(y-1)(y-2)...(2)(1)] = [z(z-1)(z-2)...(2)(1)]$$   we can then factor all of the common terms out on the LHS.  $$ [...(2)(1)][x(x-1)(x-2)... + y(y-1)(y-2)...] = [z(z-1)(z-2)...(2)(1)]$$ and divide the common terms out of the right hand side  $$[x(x-1)(x-2)...] + [y(y-1)(y-2)...] = [z(z-1)(z-2)...]$$  I'm stuck on how to proceed and how to make a clearer argument that there is only the one solution (if indeed there is only the one solution).   If anybody can provide a hint as to how to proceed I would appreciate it. What does "rc" in .bashrc stand for? Is it "resource configuration", by any chance? Characterizing Dense Subgroups of the Reals When to use the double not (!!) operator in JavaScript HUD is not working after upgrade My HUD is not working after I upgraded from 11.04 (and or 11.10).  It prompts for command and it tries loading for 4 seconds then gives up. Is there a function whose inverse is exactly the reciprocal of the function, that is $f^{-1} = \frac{1}{f}$? Is there a function whose inverse is exactly the reciprocal of the function? That is $f^{-1} = \frac{1}{f}$.  We know that the inverse of a function is not necessarily equal to its reciprocal in general. What is the Taylor series of $$\ln \frac{1-x^2}{1+x^2}$$   ?   I started by evaluating the first derivatives but the more I go, the more complicated they are and I can't identify a pattern.