Intervals Part 1 - Definitions and Terms

  • drew.allen

    SSC Guru

    Points: 76588

    Comments posted to this topic are about the item Intervals Part 1 - Definitions and Terms

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • gary.strange-sqlconsumer

    SSCommitted

    Points: 1782

    I appreciate this work is six years old. But the diagram is not good.

    I'd take this down and re-publish once the diagram is re-worked. Otherwise you're  better off just re-publishing James F Allen's work.

  • Jeff Moden

    SSC Guru

    Points: 994661

    With respect to the "Desired Month" interval in the following diagram (don't confuse with line # 3 or 6), what are lines 4 and 5 referred to as?
    data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAVUAAADmCAYAAABlJRZBAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAABm7SURBVHhe7d29dqpMF8DxnfdaNEVWroBcQTzNqdKmwzI2p7NM9zSk1C5tqjTRK4hXkGURvBffGT5kQPlQtgbj/7cWz3MUhWGQnZkBNldrQwAAKv6X/B8XYvVyJ3cvq+RVB82HcnV1J0cv4upF7q6GMk9eNtX5+sOPI6gCgCKCKhqYy/DqyrQg3Wn/Vl4j9xNZrz/lqZe8Bs4MQRWN+bO1CXjxNPOnMigEVts1Lg26UXfbDcpuF38lL3fuvGLAjoP6cO5+bnuIoHL9hXUMP5K3AWUEVRzkfhJK4E3lOYlsNqD1R7cyS4JuGHzJ4O7FhDLLBMX+SG6doJxvjfbk6TN5f+Yn722bDh5FXu3n7LqTNxPV67dDtX0ZSSBhMv/vciSLZB6giaCKA/Xk+lZksQzNv1fy8bYQL/gn9/FM6f15EG+xFDtXpC83JghOn7Mgdwh/lgZiG4TdoFy3/rm8T833x0/mm7H7f4EU4jKggqAKBaEsTbNvMepn3W/TMl3Il3xHUTRpib6KPKbzh5ojsjXrX32bf3ly048/DRwTQRUHWsn3l4gXRaq4JeoFYdyF30yFE069J/mM3p+JPx0oXprUcP3ACRBUcZBojHLhyziKWj358+CZluLj7utLV3OZ73j/9lor4tWsv/dHHryFjP5LW8fxGC9jqjgGgioamw6SrrWZBl/2pM8kG8N8+pQwEBn1s89kZ+i/5Tn3/kC+TKtykn5ZQfX67fBD3DqO33+Xv+bDjKniGLhN9cLYs+SP8iqf9IsPQv2hDi1VAFBESxUAFJ22pVq8q8a5OLs1NxFHsh7Vq3a0NE0Ysm/Cj4bbb7uvvy8hSHrHVfLyiFrX30EJY06wfRw/att/wqC6kpfHkYh72ctndjF2a/0b8eRWohPKvWvzrwu7LvHStx/tcPyobX/DoKrxlzK+QLv8MhqFdXg3UloP0V+irJW8f2tDqbVwzIQhVdt/NHG95HsdyXuqTR2l+j+KZHvdqawXdrT9r1A/P3r87KjDXS3Sczh+7JhqvdnaNx/1Z8nLEmHg2fHZZPLNt6J314GXvleYkgXO/B3zzFS3vsZmvlmetw7C5HWyPd7mje3ti7Zln/KFwdrLzXfXV6yDtG5c+c/4gV1e/nO763c/dhnZdmuI6y63vba+PbOefAVV1EFW/7m6blz/1d/XtLv+ir+f+HX2uf33v+f7zv5vWz8tHf34ibe9/He5f/0d6/hpQi2oxgXOChq99gKzqam6ZdSv4zBJZRcXHP1Qtn+0KfdHEasq3x5lz603E/3wnPqKf4iF+qys32bs9/SDqr8OnOXOfHMAzsyPelMh2wdNfnvi+osOhk3FFOu0vv6rv69jd/0V11Xym7MO2v9Ntu8421u6LarHz/bvo9QPHz9NKI2p1iW0+EnxsIP/t3CleTSGkt6b3lbbhCF1CT+6XL+xa1MeGf0n89WLPH89yB+3H7X6kLeFJw9/sj5b72ksvkzl3ekOmgPOuSEgrtN9tP2+mvl/MjLbG/wr/OZKNUv48jPbd4rjpydPYz/L3bD3CexuHT9KQbUuocZv1zJhSG3CjzOo3+hW0Kk8P76JiZ6bH3ckXJqyJicBfrHNHWcDkdk+434kfEnGSpMT2OOl9G09Ng2uHTt+lIJqlxNaJK1It0lk1Rzood0L+7rohCFJa2Nxm+QDcKi2arrLtiRNv9Jsa5Zn9vyd8PhJ2QBr63HxJh8q1Xja40cpqNYktGgk3vAv9SMvPthN39wp21yGg6nTHciv216LaGYXVJSvbcKQ2oQfGvV7AlFrI8sHsJFs35tzhKxenk3o8aXYqyx3rN+HMvuHNU5C0PxMvErClzM+fuzyipW1T++mY8fPXkHVTagRTU5FVCe0aKIwrmImtZaePdhnt07Z4oQe2f3b+XXbe7vDwPwCcqrK1zZhiFl2TcKP9vX7k+z2hfLwltVdnKV/RwAudcTfhzYbWGd+dLw0K2P9/q93xPo5+vFjbLY9maIhlKa/j/r6O+Xxw22qF4aEIO2crP7sdaHPNxJq3iCDk1Dq/gPQs5KXZ9N/vr0moJ4hWqpAB9gWcH/kjKL6M1lrJpzFyRBULwzd/3aoP9Sh+w8AigiqAKCoVVC1XaHOXtYCAA1ox7GDgqothL3Oi7ElAOfOXsP6aqKZjWkawXWvoJoG0/5yHN3mRUAF8BvYwGpj2ngZ35zQJrg2CqrFYLrrUo/50L1TIZmcO66Y/7Pz63S9/D89v07Xy8/86vmp+0mcF6BNcN3rkiobXKNr6biG7mzZfciwzeGov9/NBl+bt8AmXzl0H+/V/U+byOHN88FRHAC6Ju2NP9/Emaza/NE86ERVGlzt4C6BFcA5S3sfbYNp6qCgmrLBlW4QgHOmHcdaBVUAQB73/gOAIlqqF8aOHzEOfjjqD3UIqgCgiKAKAIoIqgCgiKAKAIoIqgCgiKAKAIoIqgCgiKAKAIoIqgCgiKAKAIoIqgCgiIQqAKCIluqFISFIO9Qf6lxWUJ0Po0cm7HjeF35asm82EzupU4oPzuMPS7kOBdW5DJ2dFk93orHvbOsiWt67iJ+8p2tX2X/bD+94+ydyP4keZxFPM/GnA8X6Y/+09neW7Z8wEBn1FRsnv2v/dCSoruTlbiBfQfzQrWz6FI2nHKTP1FpP/ibvHIc/c8uu87ybbjju/tnWlxsv+aci9s/h7u+dpyf3/siD2T9f37pB77fsH8ZU0T2rD3lb+DL+NUHvtwlluRC5vWb/7NKRoNqTp7EvC9OliJr+dy/mby+64zT7ZzNu13+Th3AiTtsIlU55/GSt4gk7aKfutFTdMbXxUvqFH0dxoDyanEGduvl1NJY/HTjzftsfhhPsn/tJsvz1WJb9/Jga+6fGSY4fG1D78vYQbnXN2T8OsxO6KQzWnnjrIExeq5itfbPJ/ix5qeZYy9UXBt7a06jUo+yfjC2nHWTTobd/1Orv2NT3T7gOvGP9xs/n+GmiIy3VuQyLfxXDpSzkVhi26YJT75+5/DdaiHfTT16j2vH3z3zYl5EE8o8uf63udP+ng3zXYCAyW+uMq20uqTILnZrXm26Gchcj1305wvJ/1BH3j5XtIzuZ/eTP1M/+sn8ONZd3e+AsRvGwQjJpX/L0W/YPt6leGBu8HuX1F11OdFrUH+pwSRUAKKKlCgCKaKleGNt9/V23Z54W9Yc6BFUAUERQBQBFBFUAUERQBQBFBFUAUERQBQBFBFUAUERQBQBFBFUAUERQBQBFBFUAUERCFQBQREsVABQRVC/GXIZuVnUzkW3pAKsXuTN1V3x6CZAiqHbGdtC7uroT3bjnyyx94qaZ9LLX7yr7qYP2KepvJS+PI1kkr/R0of6ghaDaCdmz1NOAF0+fck5P7fBnbtk1g3ad09Tf6uVR3h5mEnjJG8p+rv6giaB6UaYySFpBdF/3ZLr9j28P8vrEE15RjaDaCT15GvuyGPXjrt9RniJ5L5O0FTTzoydX/p7Aeuz6s93+N3l4fTJrAqoRVLvifpJ1/cbL+FHATnCYD+MWZm5yomLd/ByzLhNXZfre/PtNlp97xPCpHy98xPqLu/2vlUMJZ19/0GN+hOiiMFh74q2DMHmtzATVtR3E0zFbmxi9VlucBrX6C9eBZ+rKbF9x8tR2TgfrDwejpdoJcxkWWi0SLmUht3J9jP7m6kWepyL+3/vkjXN3zPrrydNn0gKOpjA6UWVPKnEiCbsQVLtiOsh3DQcis/VE1MJecn1ltOz+SCQIZaIcU3PdVzudsgt77Po7gR+tP6jhNlUAUERLFQAUEVQBQBFB9cKsXu64/bEF6g91CKoAoIigCgCKCKoAoIigCgCKCKoAoIigCgCKCKoAoIigCgCKCKoAoIigCgCKCKoAoIjUfwCgiJbqhSEhSDvUH+oQVNEhcxmS+R5nrkNBtXBARdOd0Ci4ENHjXqJnoGTPg/rkkdCXYdexf3W2PYKOBNWVvNwN5CsInQes2emz8rHA+D3m/41k4c/Un5uF82Efpuge/+f6YEW6/+iAlXx/2ae7itNioZeC89SRoNqTp7Evi1E/PqAYS7swoSwX9mmi7/I3aaWEgcioPzQdQ+C8dKelej/Jmv7jpfQLwXU+TFswzuQ865351fPrdKF8XvBv80jp3tNYfPmS7+QH0IXyVfnp8p37fCv3iO4zblh19zpVe+Ki/yYPIeOqmuwlQY/y2rHxKjum3pe3h9Aplz158Sw3Hdv/3ay/c2f3dXyS8jeMqXekpWoqtfBXS8KlLORWrvntXoB0+OdxM466enmWqfcgf9j/ODPd6f5PB/muQfSHa7LpDuKXu58k46jx/u+PbmXGJVUXJdf9t9OZDgF0JKjeyyQdT91MBNRL03v6ZP9fpF3Hv5nO9I9qd1qqAPALkFAFABTRUr0wJARph/pDHYIqACgiqAKAIoIqACgiqAKAIoIqACgiqAKAIoIqACgiqAKAIoIqACgiqAKAIoIqACgioQoAKKKlCgCKCKoAoIigehHsg9UKj6q4Kj7+eddnePZ+rK7+ds2/IkXghSKoXhB/lj2qYuZPZbAJDPZppgP5CsL84yzWPMnWVV5/MXe+nXji6mUiqF6o+0kogTeVZ1pTB6H+UIagerF6cn0rsliG0b/jR0T3467rmT7F8rTc+gMyBFXE7idZ13W8lD7BdW+5RyxTdxeLoHqxVvL9JeLd9JPXDhtgw0C8xZt8EBlKbNdfbkz1TB+vjPYIqhdqPuzLaOHLODqZMpfhMH8tgIRLWcitXBMZdsrXH5AhqF4Qt3s6+AokXE/kPplnZmZdVzsNRGbufFTXn5Hr/tuJIYCLxG2qAKCIlioAKCKoAoAigioAKCKoAoAigioAKCKoAoAigioAKCKoAoAigioAKCKoAoAigioAKCKoAoAigioAKCKoAoAigioAKCKoAoAigioAKEqC6lyGV1dSfExRJp6fe1SEme6KzzyfDwufuZP4I3Xfj+fnl2ffG5r/pv8ufj+dBwDdsVdLNfe0SDN9Og89mw9NoBt8SRC6n3mVP8l8q+r71mL0mATh3dzvz/ypDLYC60pe7gi4AH6OTvd/9SLPUxv0PiUfJ3vSa/ywSU88byGj/5qFw/tJKIE3leeqKAwAJ6YSVFcfb7IQX/62evTmrYxfA/Gmg4phCFdPrm9N63YZJq+tnjx92pYsTwEF8DP2Cqq5R/BWPH539XK3+ZwbIGu/33uS18Azn6P7DuA8HT6m+vlk2oWx3p8H03n/ku8kSvaePs1nZqbtmlf2fVfv6TXq1g+G78k7ZVby/SXi3fST1wDw83TGVE0Lc+wvZNTXaGGaLnw0DDCVafLOLvNhX0YLX8a5QVxOVAH4Wbmgmuue26kwuLk13+nC309M63MmMtjMH2wFxarv5yTDAEXu9wdfgYSMnQLomCvTFV8n/wYAtKTT/QcARAiqAKCIoIrmVi9y12RMHLhgjKmiIXtlRV/eHsKt24sBZPZoqe5KapImTOmCuvLF85vdrXWIquVrJIQ5dvnrhLJciNxeE1CBSralWi9cB56svSBMXndNdflmvtjW+Nbkz5IPWDO/MN9fZ7Nnaz/6fLyeeL63TldXv/z0+8lLI/6Os46K9TcqvxEGnjPfLX8T7ra53y++70zFAlSprN861fUfqy7/zqKGwdrzAvMJQM9FjKlG19Amd3iZg2tzV9fEvci1/0/MwZXM252sZTp4FHlN5ydvGo2WX7CVEKZi/U2Wb28N7o9uxcSOaF4YfMmg8Zhn1rVPlx19P2pNp/kUtte/rtrAogb1W6es/uvKb3NEfCW3+0XZ1NJ6CZeyuL3eeWcfcKiGQdUcWGNfFqN+3HVVPkHh5gooTls5W3dSKF+v5xxcu5K12ICSZuGygaaYkWtfhXU0WH+5lXy8LcQL/m1uhohuHV4sTae9gdWHvC08efjjlOBpbILoVN61hhtabV+stP5ryt+/8ZJ1zeX9yzfvx/Wy+v7iNmeoa95SvZ9sWgHr8VL6hwavHeJcAcmyC1PjkyKty5fe4hpPg6p7ZI+izfrj8c7NHxU79UeycPIxVLItNrmV4w6XHrF+a8rfi5uqspq/y9fDP/l7Gwdb87VcIAY0HNb9twEsDExL6E0+FKJq+5Zqwd7li7uPo9vZJjDPbF/3qNyEMG3X3xfTGDMt1az7G08NW9P9m1xCHH1Hrt+68tv5ptX+YSrcnmi7/+ubGDs39X/sPyS4RA2D6lyGxdPOiq2b9i3VJuWLA086tpYXt/SyrmAc8PZTtfxt+YQwTdZftfye/HkwXdyaJyeU6v2RB28hb85foNXLs+k8t82Rm9Ko3wp15e9dm1/CVEaj2/i1CbLy9ixvcmNqNZVeoUEyHrRkAlcD8dlX+/Fs2vfs8jE1LF/hDHTuaoHcPG8dzIK1iWHJGe7ts/c7lS5/R/mKZ50r15+oKr+RP/tvp+IZ8iplZ89TDeugTJPtK9Vk3dXlj66g2Cwg+Wxugek+6tLvGueIi/8BQNFFXFIFAKdCUAUARQTVMlHykF920oKEKMDREVQvxkpeHkci7mVXJc8JA3C45pdUuS2cZDroGtKjOHb5di2fhCgAtu3VUvXd+77N1LUUcOXlywJadO93GhhzES5/x8/wI3nb4S5/5k+Te8sT82G23GjK5sXrjJ/Z5T5nqxhg8zdB7Bu08+XPvp++v73+4jPIKlVsX720/t0yFjOcVZd/Z1HtcAZDGOiYi+r+24Dy/jcNjDPxp4PNwRpdjC/2YYLx/L9Le5tnORKikBAF2KUTQVX9NtUSNqBkcSS+Qyk2l3fTjPPH2Rjj/b9Acsf9FhKikBAF2LZXUM11HRW7XSoJVYyDy7f6FnN4SrvjM999JSHKHmrKT0IUnJPDx1QVzxxrtVSPVb7dSIiihoQo+EU60f3XaqkeLEnIMfov7SvPZRi1FMuRECX5pwYSouA3MYGrgR0JQezUmUdR1JVvV0KO4mM23GX465l91MYmucaO5ZMQhYQowA4kVAEARRd1SRUAHBtBFQAUEVTRnGZClmMlrInu/CrerXUEZ5Vw56dvkb4sBFU0tCIhC9BAw6CaXq7iTsW/0rs+c4IWw0bd+o/917pq+U3qr86xy1/nTBKyRE/VbXh976/y078PbNiz//W2L4mJLnHZXL4SX+JSvETodKrXH5d1e8pfkZO/3Cl/aU66/e5lP9nlTvXLr6s/o2L9jcpv5C/J2vfSorJLmorvO1OxAJXyy/ED95K1WGX5o0vcsu/nLzcrK3uqev+lquuvvvyl7L71gnWQ7MesHE23Ifv95H4LSf3v8/vb9X3oOjiopj+COJC5//4JTda/axscYWiWkiouL/5udhDY+cWDsmr5dfVnX1at36oufxwQsgMxet34OuLt9RWXV1t/NaKD2SlPfHAXylta/j3WHf1xcsttxd+v2n919VdX/krJH0xb/ng98brtMuI6r6v/tPxuHRTrpKqOmnwfWlqMqbpJNXryNPaze9f3PIHR/jbVduuPNEgYUpoQ5CCXlJClLmFNXfnju9Gmz+3yTZTvv7r1H5Jwp8AL5F+6cH+c/+00rH8TAEsSAjXT9vtoRu9EVTSWlZzAGC+lv0dwU7lNtcX6Y0dMGNJIm/V3PCFLbcKauvLbIGj266vIYzpfdfCwZv0qCXcqnCQhDk6lRVB1E4oU2AAXmr/kizdxbucupZ76b8/1xwHtiAlDdrqkhCx1Gpa/9ySf0ftxLly9tJAt66+tH69/aDo4qOYTisxlWGw57PHXt31Ltcn64wNnd0ITjYQhVcvfdlEJWWoT1tSUfzWX+Y739a5EqFn/AQl39qJS//v9/rbFVw+QkEaBCVwNZAPdmyl3EmTH/KaD+Coarr9wht09MZCf5xUShjQc1C9dfl39GZXrT1SV34hPbmTzo+XkP1IhPlmSfbdYfw3roJRbB2bZuYQ1sdLyb5353972jaiODit7df3Vl7+ULVOyv6N1JAXJTlRZVfW/q/zx53Pv1fz+qr+fbl/DbUIpEqoAgCK9E1UAAIIqAGgiqJY5q4QZDZEQJUNCFBwJQfVikBAFOIWGQTW93MKd3L/yu+brPl662rHXX7f9Tfx0ayO+bIuEKF31078PaNmrpeo7Tyud+VMZFAKLO99OJ3lon6N8/dkPdj50AmPuF5y/o2n4kbztqNz+qNvqLNuZF69zIPYmKfcx2sUDKH8TxL5BO1/+7Pvp+9vr3++upPr6qSx/cegh18UvK3sq3X/u57aHCKrrr778pey+vXuRl+S3k5Wj6TZU//6a/j6s8t8vOsMEiAbKr3OLr4XbNf+U6tafXoO3fV1e+jpKkFGaMKNu++1LEqKUl3+PdVdcZ5pdN2q3N38Nbl391ZW/UnL9py1/vJ543XYZcZ3X1X9afrcOinVSVUdNvo+uaDGmum/Sj3Lqt6mWMD/AkoQShyTMICFKVj8kRCEhClKqJ6pyXcs9zixrPff/0PXrJMzId/9IiEJCFFymFkF1O6GK/Uu6CYh7nFnWaqkeuv7DkBAl07D8JETBBTg4qOYTgrSj1VI92AEJM0iI4tYPCVFIiILUXkHV7V4PvgIJ15PNGJaV637bqc3F5Qc4fP22exq3nuLvvstfmzowmZsq3/57mZimadb9fBQZm+/b5W26uWYdbiJtM7ktNfuHxaxSRv1sHc0vgrflD+XhLVt2f3Qrs8L+OVx9/VSX/1uec+8P5Mu0KrPxwfaq199s/x5Oo/6rfx84HyRUAQBFqieqAODSEVQBQBFBFQAUEVQBQBFBFQAUEVQBQBFBFQAUEVQBQBFBFQAUEVQBQI3I/wEtV2WciwvAJgAAAABJRU5ErkJggg==

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Jeff Moden

    SSC Guru

    Points: 994661

    Jeff Moden - Monday, March 12, 2018 8:08 AM

    With respect to the "Desired Month" interval in the following diagram (don't confuse with line # 3 or 6), what are lines 4 and 5 referred to as?
    data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAVUAAADmCAYAAABlJRZBAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAABm7SURBVHhe7d29dqpMF8DxnfdaNEVWroBcQTzNqdKmwzI2p7NM9zSk1C5tqjTRK4hXkGURvBffGT5kQPlQtgbj/7cWz3MUhWGQnZkBNldrQwAAKv6X/B8XYvVyJ3cvq+RVB82HcnV1J0cv4upF7q6GMk9eNtX5+sOPI6gCgCKCKhqYy/DqyrQg3Wn/Vl4j9xNZrz/lqZe8Bs4MQRWN+bO1CXjxNPOnMigEVts1Lg26UXfbDcpuF38lL3fuvGLAjoP6cO5+bnuIoHL9hXUMP5K3AWUEVRzkfhJK4E3lOYlsNqD1R7cyS4JuGHzJ4O7FhDLLBMX+SG6doJxvjfbk6TN5f+Yn722bDh5FXu3n7LqTNxPV67dDtX0ZSSBhMv/vciSLZB6giaCKA/Xk+lZksQzNv1fy8bYQL/gn9/FM6f15EG+xFDtXpC83JghOn7Mgdwh/lgZiG4TdoFy3/rm8T833x0/mm7H7f4EU4jKggqAKBaEsTbNvMepn3W/TMl3Il3xHUTRpib6KPKbzh5ojsjXrX32bf3ly048/DRwTQRUHWsn3l4gXRaq4JeoFYdyF30yFE069J/mM3p+JPx0oXprUcP3ACRBUcZBojHLhyziKWj358+CZluLj7utLV3OZ73j/9lor4tWsv/dHHryFjP5LW8fxGC9jqjgGgioamw6SrrWZBl/2pM8kG8N8+pQwEBn1s89kZ+i/5Tn3/kC+TKtykn5ZQfX67fBD3DqO33+Xv+bDjKniGLhN9cLYs+SP8iqf9IsPQv2hDi1VAFBESxUAFJ22pVq8q8a5OLs1NxFHsh7Vq3a0NE0Ysm/Cj4bbb7uvvy8hSHrHVfLyiFrX30EJY06wfRw/att/wqC6kpfHkYh72ctndjF2a/0b8eRWohPKvWvzrwu7LvHStx/tcPyobX/DoKrxlzK+QLv8MhqFdXg3UloP0V+irJW8f2tDqbVwzIQhVdt/NHG95HsdyXuqTR2l+j+KZHvdqawXdrT9r1A/P3r87KjDXS3Sczh+7JhqvdnaNx/1Z8nLEmHg2fHZZPLNt6J314GXvleYkgXO/B3zzFS3vsZmvlmetw7C5HWyPd7mje3ti7Zln/KFwdrLzXfXV6yDtG5c+c/4gV1e/nO763c/dhnZdmuI6y63vba+PbOefAVV1EFW/7m6blz/1d/XtLv+ir+f+HX2uf33v+f7zv5vWz8tHf34ibe9/He5f/0d6/hpQi2oxgXOChq99gKzqam6ZdSv4zBJZRcXHP1Qtn+0KfdHEasq3x5lz603E/3wnPqKf4iF+qys32bs9/SDqr8OnOXOfHMAzsyPelMh2wdNfnvi+osOhk3FFOu0vv6rv69jd/0V11Xym7MO2v9Ntu8421u6LarHz/bvo9QPHz9NKI2p1iW0+EnxsIP/t3CleTSGkt6b3lbbhCF1CT+6XL+xa1MeGf0n89WLPH89yB+3H7X6kLeFJw9/sj5b72ksvkzl3ekOmgPOuSEgrtN9tP2+mvl/MjLbG/wr/OZKNUv48jPbd4rjpydPYz/L3bD3CexuHT9KQbUuocZv1zJhSG3CjzOo3+hW0Kk8P76JiZ6bH3ckXJqyJicBfrHNHWcDkdk+434kfEnGSpMT2OOl9G09Ng2uHTt+lIJqlxNaJK1It0lk1Rzood0L+7rohCFJa2Nxm+QDcKi2arrLtiRNv9Jsa5Zn9vyd8PhJ2QBr63HxJh8q1Xja40cpqNYktGgk3vAv9SMvPthN39wp21yGg6nTHciv216LaGYXVJSvbcKQ2oQfGvV7AlFrI8sHsJFs35tzhKxenk3o8aXYqyx3rN+HMvuHNU5C0PxMvErClzM+fuzyipW1T++mY8fPXkHVTagRTU5FVCe0aKIwrmImtZaePdhnt07Z4oQe2f3b+XXbe7vDwPwCcqrK1zZhiFl2TcKP9vX7k+z2hfLwltVdnKV/RwAudcTfhzYbWGd+dLw0K2P9/q93xPo5+vFjbLY9maIhlKa/j/r6O+Xxw22qF4aEIO2crP7sdaHPNxJq3iCDk1Dq/gPQs5KXZ9N/vr0moJ4hWqpAB9gWcH/kjKL6M1lrJpzFyRBULwzd/3aoP9Sh+w8AigiqAKCoVVC1XaHOXtYCAA1ox7GDgqothL3Oi7ElAOfOXsP6aqKZjWkawXWvoJoG0/5yHN3mRUAF8BvYwGpj2ngZ35zQJrg2CqrFYLrrUo/50L1TIZmcO66Y/7Pz63S9/D89v07Xy8/86vmp+0mcF6BNcN3rkiobXKNr6biG7mzZfciwzeGov9/NBl+bt8AmXzl0H+/V/U+byOHN88FRHAC6Ju2NP9/Emaza/NE86ERVGlzt4C6BFcA5S3sfbYNp6qCgmrLBlW4QgHOmHcdaBVUAQB73/gOAIlqqF8aOHzEOfjjqD3UIqgCgiKAKAIoIqgCgiKAKAIoIqgCgiKAKAIoIqgCgiKAKAIoIqgCgiKAKAIoIqgCgiIQqAKCIluqFISFIO9Qf6lxWUJ0Po0cm7HjeF35asm82EzupU4oPzuMPS7kOBdW5DJ2dFk93orHvbOsiWt67iJ+8p2tX2X/bD+94+ydyP4keZxFPM/GnA8X6Y/+09neW7Z8wEBn1FRsnv2v/dCSoruTlbiBfQfzQrWz6FI2nHKTP1FpP/ibvHIc/c8uu87ybbjju/tnWlxsv+aci9s/h7u+dpyf3/siD2T9f37pB77fsH8ZU0T2rD3lb+DL+NUHvtwlluRC5vWb/7NKRoNqTp7EvC9OliJr+dy/mby+64zT7ZzNu13+Th3AiTtsIlU55/GSt4gk7aKfutFTdMbXxUvqFH0dxoDyanEGduvl1NJY/HTjzftsfhhPsn/tJsvz1WJb9/Jga+6fGSY4fG1D78vYQbnXN2T8OsxO6KQzWnnjrIExeq5itfbPJ/ix5qeZYy9UXBt7a06jUo+yfjC2nHWTTobd/1Orv2NT3T7gOvGP9xs/n+GmiIy3VuQyLfxXDpSzkVhi26YJT75+5/DdaiHfTT16j2vH3z3zYl5EE8o8uf63udP+ng3zXYCAyW+uMq20uqTILnZrXm26Gchcj1305wvJ/1BH3j5XtIzuZ/eTP1M/+sn8ONZd3e+AsRvGwQjJpX/L0W/YPt6leGBu8HuX1F11OdFrUH+pwSRUAKKKlCgCKaKleGNt9/V23Z54W9Yc6BFUAUERQBQBFBFUAUERQBQBFBFUAUERQBQBFBFUAUERQBQBFBFUAUERQBQBFBFUAUERCFQBQREsVABQRVC/GXIZuVnUzkW3pAKsXuTN1V3x6CZAiqHbGdtC7uroT3bjnyyx94qaZ9LLX7yr7qYP2KepvJS+PI1kkr/R0of6ghaDaCdmz1NOAF0+fck5P7fBnbtk1g3ad09Tf6uVR3h5mEnjJG8p+rv6giaB6UaYySFpBdF/3ZLr9j28P8vrEE15RjaDaCT15GvuyGPXjrt9RniJ5L5O0FTTzoydX/p7Aeuz6s93+N3l4fTJrAqoRVLvifpJ1/cbL+FHATnCYD+MWZm5yomLd/ByzLhNXZfre/PtNlp97xPCpHy98xPqLu/2vlUMJZ19/0GN+hOiiMFh74q2DMHmtzATVtR3E0zFbmxi9VlucBrX6C9eBZ+rKbF9x8tR2TgfrDwejpdoJcxkWWi0SLmUht3J9jP7m6kWepyL+3/vkjXN3zPrrydNn0gKOpjA6UWVPKnEiCbsQVLtiOsh3DQcis/VE1MJecn1ltOz+SCQIZaIcU3PdVzudsgt77Po7gR+tP6jhNlUAUERLFQAUEVQBQBFB9cKsXu64/bEF6g91CKoAoIigCgCKCKoAoIigCgCKCKoAoIigCgCKCKoAoIigCgCKCKoAoIigCgCKCKoAoIjUfwCgiJbqhSEhSDvUH+oQVNEhcxmS+R5nrkNBtXBARdOd0Ci4ENHjXqJnoGTPg/rkkdCXYdexf3W2PYKOBNWVvNwN5CsInQes2emz8rHA+D3m/41k4c/Un5uF82Efpuge/+f6YEW6/+iAlXx/2ae7itNioZeC89SRoNqTp7Evi1E/PqAYS7swoSwX9mmi7/I3aaWEgcioPzQdQ+C8dKelej/Jmv7jpfQLwXU+TFswzuQ865351fPrdKF8XvBv80jp3tNYfPmS7+QH0IXyVfnp8p37fCv3iO4zblh19zpVe+Ki/yYPIeOqmuwlQY/y2rHxKjum3pe3h9Aplz158Sw3Hdv/3ay/c2f3dXyS8jeMqXekpWoqtfBXS8KlLORWrvntXoB0+OdxM466enmWqfcgf9j/ODPd6f5PB/muQfSHa7LpDuKXu58k46jx/u+PbmXGJVUXJdf9t9OZDgF0JKjeyyQdT91MBNRL03v6ZP9fpF3Hv5nO9I9qd1qqAPALkFAFABTRUr0wJARph/pDHYIqACgiqAKAIoIqACgiqAKAIoIqACgiqAKAIoIqACgiqAKAIoIqACgiqAKAIoIqACgioQoAKKKlCgCKCKoAoIigehHsg9UKj6q4Kj7+eddnePZ+rK7+ds2/IkXghSKoXhB/lj2qYuZPZbAJDPZppgP5CsL84yzWPMnWVV5/MXe+nXji6mUiqF6o+0kogTeVZ1pTB6H+UIagerF6cn0rsliG0b/jR0T3467rmT7F8rTc+gMyBFXE7idZ13W8lD7BdW+5RyxTdxeLoHqxVvL9JeLd9JPXDhtgw0C8xZt8EBlKbNdfbkz1TB+vjPYIqhdqPuzLaOHLODqZMpfhMH8tgIRLWcitXBMZdsrXH5AhqF4Qt3s6+AokXE/kPplnZmZdVzsNRGbufFTXn5Hr/tuJIYCLxG2qAKCIlioAKCKoAoAigioAKCKoAoAigioAKCKoAoAigioAKCKoAoAigioAKCKoAoAigioAKCKoAoAigioAKCKoAoAigioAKCKoAoAigioAKEqC6lyGV1dSfExRJp6fe1SEme6KzzyfDwufuZP4I3Xfj+fnl2ffG5r/pv8ufj+dBwDdsVdLNfe0SDN9Og89mw9NoBt8SRC6n3mVP8l8q+r71mL0mATh3dzvz/ypDLYC60pe7gi4AH6OTvd/9SLPUxv0PiUfJ3vSa/ywSU88byGj/5qFw/tJKIE3leeqKAwAJ6YSVFcfb7IQX/62evTmrYxfA/Gmg4phCFdPrm9N63YZJq+tnjx92pYsTwEF8DP2Cqq5R/BWPH539XK3+ZwbIGu/33uS18Azn6P7DuA8HT6m+vlk2oWx3p8H03n/ku8kSvaePs1nZqbtmlf2fVfv6TXq1g+G78k7ZVby/SXi3fST1wDw83TGVE0Lc+wvZNTXaGGaLnw0DDCVafLOLvNhX0YLX8a5QVxOVAH4Wbmgmuue26kwuLk13+nC309M63MmMtjMH2wFxarv5yTDAEXu9wdfgYSMnQLomCvTFV8n/wYAtKTT/QcARAiqAKCIoIrmVi9y12RMHLhgjKmiIXtlRV/eHsKt24sBZPZoqe5KapImTOmCuvLF85vdrXWIquVrJIQ5dvnrhLJciNxeE1CBSralWi9cB56svSBMXndNdflmvtjW+Nbkz5IPWDO/MN9fZ7Nnaz/6fLyeeL63TldXv/z0+8lLI/6Os46K9TcqvxEGnjPfLX8T7ra53y++70zFAlSprN861fUfqy7/zqKGwdrzAvMJQM9FjKlG19Amd3iZg2tzV9fEvci1/0/MwZXM252sZTp4FHlN5ydvGo2WX7CVEKZi/U2Wb28N7o9uxcSOaF4YfMmg8Zhn1rVPlx19P2pNp/kUtte/rtrAogb1W6es/uvKb3NEfCW3+0XZ1NJ6CZeyuL3eeWcfcKiGQdUcWGNfFqN+3HVVPkHh5gooTls5W3dSKF+v5xxcu5K12ICSZuGygaaYkWtfhXU0WH+5lXy8LcQL/m1uhohuHV4sTae9gdWHvC08efjjlOBpbILoVN61hhtabV+stP5ryt+/8ZJ1zeX9yzfvx/Wy+v7iNmeoa95SvZ9sWgHr8VL6hwavHeJcAcmyC1PjkyKty5fe4hpPg6p7ZI+izfrj8c7NHxU79UeycPIxVLItNrmV4w6XHrF+a8rfi5uqspq/y9fDP/l7Gwdb87VcIAY0HNb9twEsDExL6E0+FKJq+5Zqwd7li7uPo9vZJjDPbF/3qNyEMG3X3xfTGDMt1az7G08NW9P9m1xCHH1Hrt+68tv5ptX+YSrcnmi7/+ubGDs39X/sPyS4RA2D6lyGxdPOiq2b9i3VJuWLA086tpYXt/SyrmAc8PZTtfxt+YQwTdZftfye/HkwXdyaJyeU6v2RB28hb85foNXLs+k8t82Rm9Ko3wp15e9dm1/CVEaj2/i1CbLy9ixvcmNqNZVeoUEyHrRkAlcD8dlX+/Fs2vfs8jE1LF/hDHTuaoHcPG8dzIK1iWHJGe7ts/c7lS5/R/mKZ50r15+oKr+RP/tvp+IZ8iplZ89TDeugTJPtK9Vk3dXlj66g2Cwg+Wxugek+6tLvGueIi/8BQNFFXFIFAKdCUAUARQTVMlHykF920oKEKMDREVQvxkpeHkci7mVXJc8JA3C45pdUuS2cZDroGtKjOHb5di2fhCgAtu3VUvXd+77N1LUUcOXlywJadO93GhhzES5/x8/wI3nb4S5/5k+Te8sT82G23GjK5sXrjJ/Z5T5nqxhg8zdB7Bu08+XPvp++v73+4jPIKlVsX720/t0yFjOcVZd/Z1HtcAZDGOiYi+r+24Dy/jcNjDPxp4PNwRpdjC/2YYLx/L9Le5tnORKikBAF2KUTQVX9NtUSNqBkcSS+Qyk2l3fTjPPH2Rjj/b9Acsf9FhKikBAF2LZXUM11HRW7XSoJVYyDy7f6FnN4SrvjM999JSHKHmrKT0IUnJPDx1QVzxxrtVSPVb7dSIiihoQo+EU60f3XaqkeLEnIMfov7SvPZRi1FMuRECX5pwYSouA3MYGrgR0JQezUmUdR1JVvV0KO4mM23GX465l91MYmucaO5ZMQhYQowA4kVAEARRd1SRUAHBtBFQAUEVTRnGZClmMlrInu/CrerXUEZ5Vw56dvkb4sBFU0tCIhC9BAw6CaXq7iTsW/0rs+c4IWw0bd+o/917pq+U3qr86xy1/nTBKyRE/VbXh976/y078PbNiz//W2L4mJLnHZXL4SX+JSvETodKrXH5d1e8pfkZO/3Cl/aU66/e5lP9nlTvXLr6s/o2L9jcpv5C/J2vfSorJLmorvO1OxAJXyy/ED95K1WGX5o0vcsu/nLzcrK3uqev+lquuvvvyl7L71gnWQ7MesHE23Ifv95H4LSf3v8/vb9X3oOjiopj+COJC5//4JTda/axscYWiWkiouL/5udhDY+cWDsmr5dfVnX1at36oufxwQsgMxet34OuLt9RWXV1t/NaKD2SlPfHAXylta/j3WHf1xcsttxd+v2n919VdX/krJH0xb/ng98brtMuI6r6v/tPxuHRTrpKqOmnwfWlqMqbpJNXryNPaze9f3PIHR/jbVduuPNEgYUpoQ5CCXlJClLmFNXfnju9Gmz+3yTZTvv7r1H5Jwp8AL5F+6cH+c/+00rH8TAEsSAjXT9vtoRu9EVTSWlZzAGC+lv0dwU7lNtcX6Y0dMGNJIm/V3PCFLbcKauvLbIGj266vIYzpfdfCwZv0qCXcqnCQhDk6lRVB1E4oU2AAXmr/kizdxbucupZ76b8/1xwHtiAlDdrqkhCx1Gpa/9ySf0ftxLly9tJAt66+tH69/aDo4qOYTisxlWGw57PHXt31Ltcn64wNnd0ITjYQhVcvfdlEJWWoT1tSUfzWX+Y739a5EqFn/AQl39qJS//v9/rbFVw+QkEaBCVwNZAPdmyl3EmTH/KaD+Coarr9wht09MZCf5xUShjQc1C9dfl39GZXrT1SV34hPbmTzo+XkP1IhPlmSfbdYfw3roJRbB2bZuYQ1sdLyb5353972jaiODit7df3Vl7+ULVOyv6N1JAXJTlRZVfW/q/zx53Pv1fz+qr+fbl/DbUIpEqoAgCK9E1UAAIIqAGgiqJY5q4QZDZEQJUNCFBwJQfVikBAFOIWGQTW93MKd3L/yu+brPl662rHXX7f9Tfx0ayO+bIuEKF31078PaNmrpeo7Tyud+VMZFAKLO99OJ3lon6N8/dkPdj50AmPuF5y/o2n4kbztqNz+qNvqLNuZF69zIPYmKfcx2sUDKH8TxL5BO1/+7Pvp+9vr3++upPr6qSx/cegh18UvK3sq3X/u57aHCKrrr778pey+vXuRl+S3k5Wj6TZU//6a/j6s8t8vOsMEiAbKr3OLr4XbNf+U6tafXoO3fV1e+jpKkFGaMKNu++1LEqKUl3+PdVdcZ5pdN2q3N38Nbl391ZW/UnL9py1/vJ543XYZcZ3X1X9afrcOinVSVUdNvo+uaDGmum/Sj3Lqt6mWMD/AkoQShyTMICFKVj8kRCEhClKqJ6pyXcs9zixrPff/0PXrJMzId/9IiEJCFFymFkF1O6GK/Uu6CYh7nFnWaqkeuv7DkBAl07D8JETBBTg4qOYTgrSj1VI92AEJM0iI4tYPCVFIiILUXkHV7V4PvgIJ15PNGJaV637bqc3F5Qc4fP22exq3nuLvvstfmzowmZsq3/57mZimadb9fBQZm+/b5W26uWYdbiJtM7ktNfuHxaxSRv1sHc0vgrflD+XhLVt2f3Qrs8L+OVx9/VSX/1uec+8P5Mu0KrPxwfaq199s/x5Oo/6rfx84HyRUAQBFqieqAODSEVQBQBFBFQAUEVQBQBFBFQAUEVQBQBFBFQAUEVQBQBFBFQAUEVQBQI3I/wEtV2WciwvAJgAAAABJRU5ErkJggg==

    Never mind.  Found it in the reference.  It's called an "OverLap".  Now I see what Gary was talking about above.  There is an "OverLap" in the diagram but it (and other things) are not depicted correctly.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply