DotNetShoutout - Stories tagged with Puzzle

Puzzle

atom rss
7
Shouts
spam Shout it Mute it

TSQL Challenge 66 - Find the most relevant advertisement based on keywords
published 578 days, 1 hour, 35 minutes ago posted by dharadhara 580 days, 23 hours, 52 minutes ago
Friday, October 21, 2011 5:53:06 AM GMT Tuesday, October 18, 2011 7:35:45 AM GMT
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... (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: SQL Server, tsql challenges, Puzzle, TSQL
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 1015 days, 16 hours, 55 minutes ago posted by jacobsebastianjacobsebastian 1017 days, 3 hours, 41 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
9
Shouts
spam Shout it Mute it

TSQL Beginners Challenge 12 - Find the available registration dates
published 1026 days, 17 hours, 19 minutes ago posted by jacobsebastianjacobsebastian 1026 days, 23 hours, 3 minutes ago
Thursday, July 29, 2010 2:08:31 PM GMT Thursday, July 29, 2010 8:24:27 AM GMT
This challenge involves finding available registration dates based on event schedules and registration data. Students can register for an event only for a specific period defined in "tblRegistration" table. Another table callled "tblEvent" stores the registration details which indicates the dates where a registration is made. Your job is to find the available dates where no event is registered. (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: challenges, Puzzle, TSQL, SQLServer
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 1034 days, 16 hours, 4 minutes ago posted by jacobsebastianjacobsebastian 1035 days, 4 hours, 8 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 Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges
published 1069 days, 20 hours, 45 minutes ago posted by jacobsebastianjacobsebastian 1070 days, 1 hour, 35 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 1077 days, 2 hours, 28 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