Browse Blog Posts by Tags

TSQL Beginners Challenge 23 - Create SQL Server version of the ORACLE TRANSLATE function

Moved to: http://beyondrelational.com/modules/19/tsql-beginners/336/tsql-beginners-challenge-23-create-sql-server-version-of-the-oracle-translate-function.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 12-20-2010
Filed under: Filed under: TBC_Challenge, BRH, string operations, character mapping, TSQL beginners challenge 23

TSQL Beginners Challenge 22 - Create SQL Server version of the ORACLE INITCAP function

Moved to : http://beyondrelational.com/modules/19/tsql-beginners/335/tsql-beginners-challenge-22-create-sql-server-version-of-the-oracle-initcap-function.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 12-06-2010
Filed under: Filed under: TBC_Challenge, BRH, string operation, Initcap, TSQL beginners challenge 22

TSQL Beginners Challenge 21 - Create SQL Server version of the ORACLE WM_CONCAT function

Moved to : http://beyondrelational.com/modules/19/tsql-beginners/334/tsql-beginners-challenge-21-create-sql-server-version-of-the-oracle-wmconcat-function.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 11-22-2010
Filed under: Filed under: TBC_Challenge, BRH, String Aggregation, TSQL beginners challenge 21

TSQL Beginners Challenge 20 - Play Mangled Words game in TSQL

Moved to http://beyondrelational.com/modules/19/tsql-beginners/333/tsql-beginners-challenge-20-play-mangled-words-game-in-tsql.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 11-13-2010
Filed under: Filed under: TBC_Challenge, BRH, TSQL, Pattern matching, TSQL Beginners challenge 20

TSQL Beginners Challenge 19 - Build valid HTML from the given unordered HTML Tags

Moved to http://beyondrelational.com/modules/19/tsql-beginners/332/tsql-beginners-challenge-19-build-valid-html-from-the-given-unordered-html-tags.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 10-25-2010
Filed under: Filed under: TBC_Challenge, HTML Parsing, TSQL Beginners challenge 19

TSQL Beginners Challenge 18 - Count the total occurrences of HTML tags in the given string

Moved to : http://beyondrelational.com/modules/19/tsql-beginners/331/tsql-beginners-challenge-18-count-the-total-occurrences-of-html-tags-in-the-given-string.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 10-11-2010
Filed under: Filed under: TBC_Challenge, BRH, HTML Parsing, String Parsing, TSQL Beginners challenge 18

TSQL Beginners Challenge 17- Working with Employee hierarchical structures

Moved to http://beyondrelational.com/modules/19/tsql-beginners/330/tsql-beginners-challenge-17-working-with-employee-hierarchical-structures.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 09-27-2010
Filed under: Filed under: XPath, TBC_Challenge, BRH, Hierarchial Relationship, tsql challenge for beginners, #TBC

TSQL Beginners Challenge 16 - Find the palindromic words from the sentence(s)

Moved to : http://beyondrelational.com/modules/19/tsql-beginners/329/tsql-beginners-challenge-16-find-the-palindromic-words-from-the-sentences.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 09-13-2010
Filed under: Filed under: TBC_Challenge, BRH, Find the palindromic words from the sentence(s), tsql challenge for beginners, #TBC

TSQL Beginners Challenge 15 - Reverse the order of words within a sentence

Moved to: http://beyondrelational.com/modules/19/tsql-beginners/328/tsql-beginners-challenge-15-reverse-the-order-of-words-within-a-sentence.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 08-30-2010
Filed under: Filed under: TBC_Challenge, BRH, Reverse the sentence, tsql challenge for beginners, #TBC

TSQL Beginners Challenge 14 - Count the number of occurrence of characters in the string

Moved to: http://beyondrelational.com/modules/19/tsql-beginners/327/tsql-beginners-challenge-14-count-the-number-of-occurrence-of-characters-in-the-string.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 08-16-2010
Filed under: Filed under: Character Merging, Character Count, Number Table, TBC_Challenge, #TBC

TSQL Beginners Challenge 13 - Validate GUID values and perform a horizontal and vertical count of characters

Moved to : http://beyondrelational.com/modules/19/tsql-beginners/326/tsql-beginners-challenge-13-validate-guid-values-and-perform-a-horizontal-and-vertical-count.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 08-02-2010
Filed under: Filed under: Challenge, Regular Expression, Data Validation, TBC_Challenge, BRH, PUZZLE, TBC, #TBC, #TSQL, #SQLSERVER

TSQL Beginners Challenge 12 - Find the available registration dates

Moved to : http://beyondrelational.com/modules/19/tsql-beginners/324/tsql-beginners-challenge-12-find-the-available-registration-dates.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 07-19-2010
Filed under: Filed under: Calender Table, Missing Dates, TBC_Challenge, BRH, TBC, #TBC, #TSQL

TSQL Beginners Challenge 11 - Find three most recent builds of each application from XML log

Moved to http://beyondrelational.com/modules/19/tsql-beginners/323/tsql-beginners-challenge-11-find-three-most-recent-builds-of-each-application-from-xml-log.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 07-05-2010
Filed under: Filed under: Version Detection, XPath, TBC_Challenge, BRH, PUZZLE, TSQL, SQL Server, #TSQL

TSQL Beginners Challenge 10 - Clean up alphanumeric strings by splitting digits and letters into separate columns

Moved to http://beyondrelational.com/modules/19/tsql-beginners/322/tsql-beginners-challenge-10-clean-up-alphanumeric-strings-by-splitting-digits-and-letters.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 06-20-2010
Filed under: Filed under: TBC_Challenge, BRH, PUZZLE, TSQL, SQL Server, #TSQL, #SQLSERVER

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node

Moved to http://beyondrelational.com/modules/19/tsql-beginners/309/tsql-beginners-challenge-9-find-the-parents-and-adjacent-members-of-the-node.aspx?tab=info

Posted to TSQL Challenges for Beginners by Niladri Biswas on 06-06-2010
Filed under: Filed under: Challenge, TBC_Challenge, BRH, PUZZLE, SQLSERVER, TSQL, DEVELOPER, BEGINNER

Tags

Blogs