Jacob Sebastian, CTO at Excellence Infonet - Beyondrelational.com Member Profile

Getting Started with Adobe After Effects - Part 6: Motion Blur

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Friends

My Badges

Quiz Master

Puzzle Master


	Request Friendship

Jacob Sebastian

Upload Image

38 years old

Ahmedabad, India

Male

My Sections

The Art of XSD - SQL Server XML Schema Collections (Books)

Idera SQL virtual database (Tools)

Ahmedabad SQL Server User Group (User Groups)

SQL Locator (Tools)

Idera SQL diagnostic manager (Tools)

Images for my blog posts (Pictures)

Jacob's Blog (Blogs)

The Art of SQL Server FILESTREAM (Books)

Idera SQL Safe backup (Tools)

Idera SQL comparison toolset (Tools)

My Activities

Blogs	1649
Ask	1605
Presentations	84
Just Learned	3260
Syndicated Blogs	183
Tutorials	111
Scripts	37
Awards	13
Interview Questions	137
Pages	38
Mentoring Corner	14
Books	47
User Groups	5
Puzzles	3235
Just Blogged	4
What is New	112

Jacob Sebastian

1 · 100% · 32004

My Home Page

I am a "Puzzle Master"
Puzzle Master is a prestigious badge awarded to people who have created one or more TSQL Challenges.
View Other Puzzle Masters

Get Code

Use the following HTML code to embed this badge in your blog or website.

				<a href="http://beyondrelational.com/members/jacobbr/badges/puzzlemaster/default.aspx"> 
					<img 
						src="http://beyondrelational.com/images/badges/puzzlemaster.jpg" 
						alt="Puzzle Master"
					/>
				</a>

TSQL Challenge 70 - Find the longest sequence of alphabets in a string – Part 2
This challenge invites you to identify the longest sequence of alphabets from a string. This challenge is Version 2 of the TSQL Challenge 67. The difference is that in this version, you should apply circling while finding the longest sequence.
View Challenge

TSQL Challenge 69 - Find the most relevant advertisement based on keywords – Part 2
A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page. Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.
View Challenge

TSQL Challenge 67 - Find the longest sequence of alphabets in a string
This challenge invites you to identify the longest sequence of alphabets from a string.
View Challenge

TSQL Challenge 66 - Find the most relevant advertisement based on keywords
A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page. Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.
View Challenge

Solving the Running Total Problem
This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial transactions.
View Challenge

TSQL Challenge 64 - A Payroll calculation Challenge
This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays.
View Challenge

TSQL Challenge 61 - Generate an HTML calendar in TSQL
This challenge is to generate an HTML calendar based on the data stored in a table. The concept is very similar to the calendar we generate for the Quiz Series.
View Challenge

TSQL Challenge 60 - Generate a relational tree structure from a string
An ETL application receives product and category information in a text file. The category hierarchy is specified as a string. Your job is to read the hierarchy information and generate a relational table (result set) representing the hierarchy of categories.
View Challenge

TSQL Challenge 59 - Playing Chess in TSQL – Part 2
This is a continuation of the previous challenge where we generated a TSQL representation of a chess board filled with pieces based on input strings in Forsyth-Edwards Notation. This challenge invites you to perform a bit more complicated operation.
View Challenge

TSQL Challenge 58 - Playing Chess in TSQL – Part 1
Let us play Chess with TSQL in this challenge. The input table contains strings that represent the layout of chess boards filled with pieces using Forsyth-Edwards Notation. Your job is to read the input string and generate a result set that represents the position of pieces in a chess board.
View Challenge

TSQL Challenge 57 - Identify rows that match the rollup trade data
This challenge is related to calculations used in stock markets and the original idea was found in one of the SQL forums. Your job is to scan the trades data and identify combination of trades that match a given rollup data. The sample input data for this puzzle is given below.
View Challenge

TSQL Challenge 47 - Read the modification history and identify the first and last card numbers
A table contains the list of modifications made to each card. Your job is to write a query that shows the first number, current number (most recent) and the number of changes made.
View Challenge

TSQL Challenge 45 - Evaluate mathematical expressions presented using Roman Numerals
This challenge involves evaluating mathematical expressions presented using Roman Numerals and return the result of each expression.
View Challenge

TSQL Challenge 44 – Identify products that belong to each unique color combinations
Here is an interesting challenge which might give you a fun time categorizing products by color. The first part of your job is to identify the unique color combinations of products and the second part is to identify the products that have the given color combination.
View Challenge

TSQL Challenge 43 – Identifying incomplete segments and missing elements
This challenge involves writing a logic to identify incomplete segments and missing elements in an electronic data integration file exchanged between two applications.
View Challenge

TSQL Challenge 42 – Transform rows to columns with dynamic positioning
This challenge involves writing a logic to change the column position of values in the output based on the presence and absence of other values on each output row.
View Challenge

TSQL Challenge 41 - Extract email addresses from text data
This challenge involves extracting email addresses from a table that contains text data downloaded from various websites.
View Challenge

TSQL Challenge 40 - Convert string representation of numeric values from binary to hexadecimal format
This challenge involves converting numeric values from binary format to hexadecimal format. Your job is to process all the input rows from the source table and produce hexadecimal representation of the binary values.
View Challenge

TSQL Challenge 39 - Calculate Gross Profit by Item using FIFO method
This challenge is related to an inventory management application where your job is to calculate the profitability by item (cost vs sales) using First-In-First-Out (FIFO) processing method.
View Challenge

TSQL Challenge 38 - Calculate SQL Stars awarded to the Winners of TSQL Challenges
This challenge involves parsing a delimited string and applying some logic to perform some calculations based on the position of tokens within the string. This challenge has got a fake (or self?) reference to the TSQL Challenges itself. Your job is to calculate the SQL Stars awarded to each of the winners by parsing a delimited string.
View Challenge

TSQL Challenge 37 - Calculate the downtime and duration of servers based on the monitoring log
This is a challenge to identify the downtime of servers from the log data generated by a monitoring application. There is a monitoring application that keeps checking the status of several servers at 5 minute intervals. When the monitoring application finds that a particular server is down, it adds a record into the log table.
View Challenge

TSQL Challenge 36 - Create a graph/Chart with TSQL
this challenge is to draw a graph using TSQL
View Challenge

TSQL Challenge 35 - Find the total number of 'Full Attendees' in each 24 HOP Session
The recent 24-hours-of-pass or more widely known as #24HOP on twitter and other social media was one of the most exciting SQL Server events that happened recently. For this challenge, we created some (fake) attendance data for this event. Your task is to count the number of attendees who watched the complete presentation of each speaker.
View Challenge

TSQL Challenge 34 - Search for two keywords within the maximum distance of one word between them
This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between them.
View Challenge

TSQL Challenge 30 - A Matrix Transposition challenge in TSQL
This is a matrix transposition challenge and your job is to change the position of the numbres in a 5x5 matrix. Transposition includes converting rows to columns and sorting the values horizontally and vertically.
View Challenge

TSQL Challenge 29 - Reorganize sales data by sales amount
This challenge presents a tough task of reorganizing the data in a sales table. The table is not normalized correctly and the sales detail data of three items are stored in each row. Your job is to reorganize the items in the table by sales amount (quantity * price). Reorganize the items from left to right, bottom to top. The item with the highest sales amount should come on top left of each invoice.
View Challenge

TSQL Challenge 28 - SELECT TOP N articles from each category from a SQL Server 2000 database
This challenge is specifically for SQL Server 2000. You cannot use any of the new features introduced in later versions of SQL Server. Sumit runs a website where he publishes technical articles on SQL Server.
View Challenge

TSQL Challenge 27 - Identify overlapping weekly schedules of Nurses
This challenge is related to a scheduling problem in the home health care industry. The task is to look into the schedules of nurses and identify any overlapping schedules.
View Challenge

TSQL Challenge 26 - Identify weekly schedule of training programs by course, classroom and timing
Here is another scheduling problem that deals with the allotment of classrooms for various training programs. Your challenge is to read the source data and build an output result set that shows the weekly schedule of each training topic and the class room in which training is scheduled.
View Challenge

TSQL Challenge 25 - Appointments and Recurring Schedules
This challenge presents a scheduleing problem related to recurring appointments. The task is to calculate and generate a list of appointments that are supposed to take place between two given dates. The calculation should be done based on the recurring configuration of each appointment. Each appointment has a 'Schedule Start Date' and 'Schedule End Date' and any occurrences that fall outside those dates should be ignored. When generating the appointments between two dates, consider the start date and end date of each appointment.
View Challenge

TSQL Challenge 24 - Find discrepancies in the scheduled activities and actual activities performed by employees
This is a problem that I had seen in one of the forums many years back. This problem is related to a reporting requirement from the data stored by a 'poorly designed' system. The system has one table that stores the appointments scheduled for each employee. There is another table that keeps tracks of the activities performed by employees.
View Challenge

TSQL Challenge 23 - Calculate the uptime and downtime of a system by reading the data from an audit log
This challenge involves reading the audit log entries generated by a monitoring application and create a report that shows the up-time and down-time of a system that the application is monitoring.
View Challenge

TSQL Challenge 13 - Break a batch of invoices into multiple parts based on rules
This is a real life scenario I came across recently. We build applications for the health care industry and one of the modules in the application generates invoices for the services provided to the patients and sent them to the insurance companies.
View Challenge

TSQL Challenge 4
This is a simple challenge to write a piece of code that validates an SSN. The key here is to write “shortest” TSQL code that removes invalid SSN values and returns a result set with only valid SSN values.
View Challenge

TSQL Challenge 3
the task is to reverse a string without using the REVERSE() function. What is wrong with the REVERSE() function? Nothing Really! As I mentioned earlier, this is to refresh your TSQL skills on set based operations. In real life, you should always use the REVERSE() function, if ever you need to reverse a string.
View Challenge

TSQL Challenge 2 - Calculate the Business Hours
The challenge is to calculate the Business Hours between StartDate and EndDate. Let us define Business Hours as the time between 8 AM and 5 PM, Monday to Friday.
View Challenge

TSQL Challenge 1 - Pair-wise and ordered assignment of objects from two different lists
This challenge will be interesting for TSQL enthusiasts as well as bird lovers! It involves assigning food items to birds from two different baskets. Here is a ‘relational’ representation of birds, food items and baskets in the form of tables and rows.
View Challenge

Friends

My Badges

My Sections

My Activities

I am a "Puzzle Master"

Get Code