The database field contains long string with data for Quantity and Parts. The challenge is to parse the data into separate (Quantity and Parts) fields for displaying in a report.
2012-03-19
2,574 reads
The challenge is to transform monthly resource efforts into weekly actuals.
2012-03-05
714 reads
The challenge is to identify the sequence of accounting transactions.
2012-02-20
1,608 reads
The challenge is to find the Episode and Sequence based on interval.
2012-02-06
1,256 reads
The challenge is to create a query for a report that show expiring material
2012-01-23
901 reads
The challenge is to wrap the text by specified position.
2012-01-09
2,883 reads
This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week.
2011-12-26
1,804 reads
Your task is to process the input table that contains several mangled words and try to 'un-mangle' them and validate them against a 'dictionary' table.
2011-12-12
1,379 reads
This challenge invites you to identify the longest sequence of alphabets from a string.
2011-11-28
959 reads
Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.
2011-11-14
583 reads
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
I am trying to use unpivot to extract some data, however, the results are...
hi, I have one nested transaction and want to deescalate to outer transaction's isolation/...
Comments posted to this topic are about the item Scaling Up Monitoring
Ask SSC