SQLServerCentral / Discuss Content Posted by Jacob Sebastian / Article Discussions / Article Discussions by Author

TSQL Challenge 80 - Find the minimal set of intervals without gaps

jacob sebastian — Mon, 16 Apr 2012 00:07:38 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 80 - Find the minimal set of intervals without gaps[/B]

TSQL Challenge 79 - Finding the Islands

jacob sebastian — Mon, 02 Apr 2012 00:02:37 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 79 - Finding the Islands[/B]

TSQL Challenge 78 - Parse single field into multiple fields

jacob sebastian — Sun, 18 Mar 2012 22:22:12 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 78 - Parse single field into multiple fields[/B]

TSQL Challenge 77-Transform monthly resource efforts to weekly actuals

jacob sebastian — Sat, 03 Mar 2012 14:38:21 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 77-Transform monthly resource efforts to weekly actuals[/B]

TSQL Challenge 76 - Identify the sequence of accounting transactions

jacob sebastian — Mon, 20 Feb 2012 00:01:37 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 76 - Identify the sequence of accounting transactions[/B]

TSQL Challenge 75 - Find the Episode and Sequence based on interval

jacob sebastian — Mon, 06 Feb 2012 00:03:30 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 75 - Find the Episode and Sequence based on interval[/B]

XML Workshop IV - FOR XML EXPLICIT

jacob sebastian — Thu, 28 Jun 2007 12:27:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/3059.asp

TSQL Challenge 74 - Find the expiring quantity of material

jacob sebastian — Mon, 23 Jan 2012 00:06:45 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 74 - Find the expiring quantity of material [/B]

T-SQL Challenge #1

jacob sebastian — Sat, 12 Sep 2009 15:27:48 GMT

Comments posted to this topic are about the item [B]T-SQL Challenge #1[/B]

TSQL Challenge 72 - Calculate the Payroll Hours of Employees

jacob sebastian — Sun, 25 Dec 2011 23:33:10 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 72 - Calculate the Payroll Hours of Employees[/B]

XML Workshop VI - Typed XML and SCHEMA Collection

jacob sebastian — Mon, 16 Jul 2007 17:22:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/3118.asp

Advanced XML Processing

jacob sebastian — Wed, 02 May 2007 16:40:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/2982.asp

XML Workshop X - Working with namespaces

jacob sebastian — Thu, 18 Oct 2007 15:07:48 GMT

Comments posted to this topic are about the item [B]XML Workshop X - Working with namespaces[/B]

XML Workshop - FOR XML PATH

jacob sebastian — Tue, 22 May 2007 10:55:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/3022.asp

More Advanced XML Processing Examples

jacob sebastian — Tue, 15 May 2007 10:33:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/2996.asp

Sales Order Workshop Part IV

jacob sebastian — Mon, 12 Mar 2007 10:04:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/2912.asp

Sales Order Workshop Part III

jacob sebastian — Mon, 12 Mar 2007 09:59:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/2911.asp

Sales Order Workshop Part II

jacob sebastian — Mon, 12 Mar 2007 09:27:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/2909.asp

Saving a Sales Order Part 1

jacob sebastian — Mon, 12 Mar 2007 09:22:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/2908.asp

TSQL Challenge 71 - Play mangled words game in TSQL

jacob sebastian — Mon, 12 Dec 2011 00:05:41 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 71 - Play mangled words game in TSQL[/B]

XML Workshop 25 - Inserting elements and attributes to an XML document

jacob sebastian — Wed, 17 Mar 2010 22:26:51 GMT

Comments posted to this topic are about the item [B]XML Workshop 25 - Inserting elements and attributes to an XML document[/B]

TSQL Challenge 70 - Find the longest sequence of alphabets in a string

jacob sebastian — Sun, 27 Nov 2011 08:56:34 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 70 - Find the longest sequence of alphabets in a string[/B]

XML Workshop XVII - Writing a LOOP to process XML elements in TSQL

jacob sebastian — Tue, 25 Mar 2008 21:50:25 GMT

Comments posted to this topic are about the item [B]XML Workshop XVII - Writing a LOOP to process XML elements in TSQL[/B]

TSQL Challenge 69 - Find the most relevant advertisement based on keyw

jacob sebastian — Mon, 14 Nov 2011 00:05:44 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 69 - Find the most relevant advertisement based on keyw[/B]

TSQL Challenge 68 - Generate kaprekar kernel or series from numbers

jacob sebastian — Mon, 31 Oct 2011 00:03:43 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 68 - Generate kaprekar kernel or series from numbers[/B]

TSQL Challenge 67 - Find the longest sequence of alphabets in a string

jacob sebastian — Mon, 17 Oct 2011 00:06:46 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 67 - Find the longest sequence of alphabets in a string[/B]

TSQL Challenge 66 - Find the most relevant advertisement based on keyw

jacob sebastian — Mon, 03 Oct 2011 00:10:13 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 66 - Find the most relevant advertisement based on keyw[/B]

Sql Jobs

SukeshMarla — Fri, 30 Sep 2011 03:27:11 GMT

Hi, i am working on a small procedure,where i have to create a Sql Job dynamically,The problem i am facing is,I want that job should start each day on 11 am and end at 4 am of next day.Can anybody help, in this sql Roll over tasks,Regards,Sukesh MarlaSr.Software Engineerwww.sukeshmarla.blogspot.com

TSQL Challenge 65 - Solving the Running Total Problem

jacob sebastian — Mon, 19 Sep 2011 00:07:44 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 65 - Solving the Running Total Problem[/B]

The Power of Merge

jacob sebastian — Tue, 17 Jul 2007 11:42:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/3122.asp

TSQL Challenge 64 - A Payroll calculation Challenge

jacob sebastian — Mon, 05 Sep 2011 00:09:31 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 64 - A Payroll calculation Challenge[/B]

TSQL Challenge 63 - A TSQL Sudoku

jacob sebastian — Sun, 21 Aug 2011 21:38:02 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 63 - A TSQL Sudoku[/B]

TSQL Challenge 62 - Break a long sentence in groups of 5 words

jacob sebastian — Sun, 07 Aug 2011 22:05:37 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 62 - Break a long sentence in groups of 5 words[/B]

XML Workshop VII - Validating values with SCHEMA

jacob sebastian — Mon, 16 Jul 2007 17:33:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/3120.asp

TSQL Challenge 61 - Generate an HTML calendar in TSQL

jacob sebastian — Mon, 25 Jul 2011 00:03:06 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 61 - Generate an HTML calendar in TSQL[/B]

TSQL Challenge 60 - Generate a relational tree structure from a string

jacob sebastian — Mon, 11 Jul 2011 00:06:40 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 60 - Generate a relational tree structure from a string[/B]

TSQL Challenge 59 - Playing Chess in TSQL – Part 2

jacob sebastian — Mon, 27 Jun 2011 00:03:36 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 59 - Playing Chess in TSQL – Part 2[/B]

TSQL Challenge 58 - Playing Chess in TSQL – Part 1

jacob sebastian — Mon, 13 Jun 2011 00:09:01 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 58 - Playing Chess in TSQL – Part 1[/B]

TSQL Challenge 57 - Identify rows that match the rollup trade data

jacob sebastian — Mon, 30 May 2011 00:03:42 GMT

Comments posted to this topic are about the item [B]TSQL Challenge 57 - Identify rows that match the rollup trade data [/B]

A Look At SQL Server Compact Edition

jacob sebastian — Thu, 31 May 2007 11:06:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/3040.asp