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,601 reads
The challenge is to transform monthly resource efforts into weekly actuals.
2012-03-05
732 reads
The challenge is to identify the sequence of accounting transactions.
2012-02-20
1,628 reads
The challenge is to find the Episode and Sequence based on interval.
2012-02-06
1,270 reads
The challenge is to create a query for a report that show expiring material
2012-01-23
923 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,818 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,395 reads
This challenge invites you to identify the longest sequence of alphabets from a string.
2011-11-28
976 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
600 reads
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?