Checking All Date Columns in a Table(s)
Find minimum and maximum values for all date columns in a table or range of tables, using a mask.
2016-09-15 (first published: 2014-10-27)
2,414 reads
Larry Schmidt
Another Way to Look at Trees
An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.
2014-09-15
7,546 reads
SSRS Report Content Filtering by User Group
How to get an SSRS user's AD group membership in order to filter report content
2013-06-03
5,976 reads
Update Trigger to Store Only Updated Column and Former Value
History table needs individual rows for each column that has been updated, i.e., a column history.
2012-12-17 (first published: 2012-12-04)
1,041 reads
Blogs
GotoWebinar (and Teams) won’t screen share after macOS update to Catalina (10.15)
By HamishWatson
This blog post is about the situation where after upgrading to the latest macOS...
Improving TweetDeck with Better TweetDeck
By John
If you are at involved with the #sqlfamily, you are bound to hear about...
Interview with Bob Ward
By damianwidera
This is the eight interview we have done. This time our guest is the...
Forums
STRING_SPLIT with Index as Table-Valued Function
Comments posted to this topic are about the item STRING_SPLIT with Index as Table-Valued...
Protecting Data from the Inside
Comments posted to this topic are about the item Protecting Data from the Inside
Remove the middle of a string between wildcards
I have a field called 'jsonpayload' in a table called 'auditlog' that is populated...
Ask SSC