Reply to thread

Message

<blockquote data-quote="Dirk" data-source="post: 65358" data-attributes="member: 11937">The sql-scripts above are versions with a nice layout.These here are the raw versions. (less spaces)The first (show) script:[code]Select p1.strTitle,p2.strTitle,p3.strTitle, p1.iStartTime, p2.iStartTime,p3.iEndTime, p1.iEndTimeFrom tblPrograms p1,&nbsp; &nbsp; tblPrograms p2,&nbsp; &nbsp; tblPrograms p3where p2.iStartTime &gt;= p1.iStartTime&nbsp; &nbsp; &nbsp;&nbsp; and&nbsp;&nbsp; p2.iEndTime&nbsp;&nbsp; &lt;&nbsp; p1.iEndTime&nbsp; &nbsp; &nbsp;&nbsp; and&nbsp;&nbsp; p2.idChannel&nbsp; =&nbsp; p1.idChanneland&nbsp;&nbsp; p3.iStartTime &gt; p1.iStartTime&nbsp; &nbsp; &nbsp;&nbsp; and&nbsp;&nbsp; p3.iEndTime&nbsp;&nbsp; &lt;= p1.iEndTime&nbsp; &nbsp; &nbsp;&nbsp; and&nbsp;&nbsp; p3.idChannel&nbsp; =&nbsp; p1.idChannel[/code]The second (delete) script[code]Delete tblPrograms p1where exists (Select 0 from tblPrograms p2&nbsp; &nbsp; &nbsp;&nbsp; where p2.iStartTime &gt;= p1.iStartTime&nbsp; &nbsp; &nbsp;&nbsp; and&nbsp;&nbsp; p2.iEndTime&nbsp;&nbsp; &lt;&nbsp; p1.iEndTime&nbsp; &nbsp; &nbsp;&nbsp; and&nbsp;&nbsp; p2.idChannel&nbsp; =&nbsp; p1.idChannel)and&nbsp;&nbsp; exists (Select 0 from tblPrograms p3&nbsp; &nbsp; &nbsp;&nbsp; where p3.iStartTime &gt;&nbsp; p1.iStartTime&nbsp; &nbsp; &nbsp;&nbsp; and&nbsp;&nbsp; p3.iEndTime&nbsp;&nbsp; &lt;= p1.iEndTime&nbsp; &nbsp; &nbsp;&nbsp; and&nbsp;&nbsp; p3.idChannel&nbsp; =&nbsp; p1.idChannel)[/code]This time I used the preview option!&nbsp;:idea:</blockquote>

[QUOTE="Dirk, post: 65358, member: 11937"] The sql-scripts above are versions with a nice layout. These here are the raw versions. (less spaces) [b]The first (show) script:[/b] [code]Select p1.strTitle,p2.strTitle,p3.strTitle, p1.iStartTime, p2.iStartTime,p3.iEndTime, p1.iEndTime From tblPrograms p1 , tblPrograms p2 , tblPrograms p3 where p2.iStartTime >= p1.iStartTime and p2.iEndTime < p1.iEndTime and p2.idChannel = p1.idChannel and p3.iStartTime > p1.iStartTime and p3.iEndTime <= p1.iEndTime and p3.idChannel = p1.idChannel[/code] [b]The second (delete) script[/b] [code]Delete tblPrograms p1 where exists (Select 0 from tblPrograms p2 where p2.iStartTime >= p1.iStartTime and p2.iEndTime < p1.iEndTime and p2.idChannel = p1.idChannel) and exists (Select 0 from tblPrograms p3 where p3.iStartTime > p1.iStartTime and p3.iEndTime <= p1.iEndTime and p3.idChannel = p1.idChannel) [/code] This time I used the preview option! :idea: [/QUOTE]

Verification