DotNetShoutout - Stories tagged with challenge

challenge

atom rss
11
Shouts
spam Shout it Mute it

TSQL Beginners Challenge 13 - Validate GUID values and perform a horizontal and vertical count of characters - TSQL Challenges for Beginners
published 1021 days, 3 hours, 13 minutes ago posted by jacobsebastianjacobsebastian 1022 days, 13 hours, 59 minutes ago
Monday, August 09, 2010 2:32:49 PM GMT Sunday, August 08, 2010 3:46:26 AM GMT
The challenge involves validating the GUID values and perform horizontal and vertical count of the characters "1, 2, 3, 4, 5, A, B, C, D, E" (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: Puzzle, TSQL, SQLServer, challenge
8
Shouts
spam Shout it Mute it

TSQL Challenge 34 - Search for two keywords within the maximum distance of one word between them - TSQL Challenges
published 1040 days, 2 hours, 21 minutes ago posted by jacobsebastianjacobsebastian 1040 days, 14 hours, 25 minutes ago
Wednesday, July 21, 2010 3:24:21 PM GMT Wednesday, July 21, 2010 3:20:11 AM GMT
This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between them (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, tsql challenges, Puzzle, TSQL, challenge
6
Shouts
spam Shout it Mute it

TSQL Beginners Challenge 11 - Find three most recent builds of each application from XML log - TSQL Challenges for Beginners
posted by jacobsebastianjacobsebastian 1049 days, 10 hours, 17 minutes ago
Monday, July 12, 2010 7:28:09 AM GMT
This challenge involves reading information from XML columns. The table keeps track of the progressive builds of an application in a development environment and your task is to identify the most recent 3 builds of each application. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: challenges, TSQL, puzzles, SQLServer, challenge
6
Shouts
spam Shout it Mute it

TSQL Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges
published 1075 days, 7 hours, 2 minutes ago posted by jacobsebastianjacobsebastian 1075 days, 11 hours, 52 minutes ago
Wednesday, June 16, 2010 10:42:58 AM GMT Wednesday, June 16, 2010 5:53:23 AM GMT
The idea of this challenge is to clean up the phrase from the words identified as noise words, but only when these words appear at the begining or the end of the string, not in the middle of the string. Your job is to read each row from the source table and remove any noise words from it. The noise words that you need to remove are stored in another table. You should remove the noice words only if they appear at the beginning or end of the sentences. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, tsql challenges, DBA, Puzzle, TSQL, developer, challenge
3
Shouts
spam Shout it Mute it

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners
posted by jacobsebastianjacobsebastian 1082 days, 12 hours, 46 minutes ago
Wednesday, June 09, 2010 4:59:29 AM GMT
This challenge refers to a real-world problem I came across recently. The requirement was to identify all 'direct' or 'indirect' parents of a given child node and all its siblings. (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, Puzzle, TSQL, developer, Database, challenge