Hi Jeff,

Thanks for the tip on the (max) vs. (8000)/(4000) nvarchar/varchar data types in these functions. When I implemented your new splitter function, I used nvarchar(4000), which covers our...

Sure. My multistatement table-valued function (below) is a WHILE loop that repeats as long as the string has any characters in it, finding the first occurrence of the delimiter, inserting...

WOW!!! That crash you just heard was...

The OR operator is valid in JOIN conditions...

When you insert data into a table, SQL Server stores the data based on the table definition and index structure, not on how you feed the data to it. Read...

Sounds like you should look into FOR XML:

http://msdn.microsoft.com/en-us/library/ms191268.aspx

Hi Tom,

I see that we are on the same page. The only way I can make sense of Microsoft's nomenclature is to remember that I should use STDEVP when...

I thought the P in STDEVP stood for "Population", so STDEVP would be the estimated Population Standard Deviation (obtained by applying Bessel's correction to the actual Sample Standard Deviation) and...

What's going on here is that the STDEV() function in T-SQL returns the sample standard deviation (which for a single value will be undefined, hence the programmatically dictated NULL result)...

If I understand what you are trying to do correctly, you want to create a report with three required parameter values (@StartDate, @EndDate, @SurgeonName) and two optional parameter values (@Service,...

A friend who does metalwork as a hobby often dreams of blasting society back to, if not the Stone Age, then at least to the mid-18th century, where he as...