A Function Gotcha with the Use of an Asterisk
This article describes and demonstrates the problem of using asterisk to select all fields from a table within a table function. (from Apr 2008)
2009-09-11 (first published: 2008-04-30)
18,043 reads
Stephen Lasham
Converting Hexadecimal String Values to Alpha (ASCII) Strings
In an interesting exercise in data conversion, Stephen Lasham brings us a nice article on basic manipulations.
2008-04-25 (first published: 2007-05-17)
11,141 reads
Finding Gaps in a Sequential Number Sequence
Do you use identity values? Do missing values ever cause problems? Maybe you need to look for missing invoices? Stephen Lasham brings us a technique for finding those missing values in a sequence.
2006-04-03
13,395 reads
Reporting a menu structure using a recursive UDF
Selecting a menu structure from a series of tables is pretty easy. If you bound the number of levels in the menu. However if you have potentially variable numbers of levels. Stephen Lasham brings us a new piece on using recursion to select the data.
2005-10-11
8,545 reads
Extracting a String Within Delimeters - Part 2
T-SQL can be a complex language to work within and code solutions with. Author Stephen Lasham brings us a twist on his last solution of extracting a string from within another string. Read about his method of working with strings in T-SQL.
2004-09-13
7,837 reads
Extracting a String From Between Two Delimiting Characters
String manipulation in SQL Server or T-SQL can be a challenage. There are multiple ways to accomplish every task and often learning a new one may spark some creativity in yourself or teach you a better way to accomplish an old task. New Author Stephen Lasham brings us his technique for extracting a string that is delimited from within a larger string. Something I'm sure we'll all have use for in the future.
2004-06-14
13,565 reads
Blogs
Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions
Introduction Recently have been working on a “Proof of Concept” task where I wanted...
Extracting data from Common Data Services (Microsoft Dynamics 365) using Azure Data Factory
By Rayis Imayev
(2020-Mar-30) Little did I know that I can use Azure Data Factory (ADF) to extract...
Probing Columnstore Indexes
In this article, our focus will be to test, the performance benefits of columnstore...
Forums
Regarding for Microsoft Azure Certification
Hello Everyone, I am new here and I am preparing for microsoft azure certification...
Parameter has any limit or size?
Hi I have created report with Cascading parameter (Multivalued), Is there any limit or...
Ask SSC