Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag function Rss

Search for any content tagged function

   Items 1 to 7 of 7   
 

Stairway to DAX and Power BI - Level 11: Function / Iterator Function Pairs: The DAX Concatenate() and ConcatenateX() Functions

Continuing his examination of the evolving DAX “Function / Iterator Pairs,” Business Intelligence Architect, Analysis Services Maestro, Microsoft Data Platform MVP and author Bill Pearson introduces the DAX Concatenate() and ConcatenateX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to Concatenate() and ConcatenateX(), in joining two text strings into a single text string, and in returning the concatenation of an expression evaluated for each row in a table, respectively.  Read more...
By Bill Pearson 2016/09/21 | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 707 reads

Finding “Active” Rows for the Previous Month (SQL Spackle)

SQL Server MVP Jeff Moden walks us through the classic problem of finding all the "Active" rows for the previous month using start and end dates. This is excellent for those new to T-SQL.  Read more...
By Jeff Moden 2014/01/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,397 reads

An Implementation of the FNV1a Hash Algorithm for SQL Server

Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing  Read more...
By Bret Lowery 2012/02/20 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 4,325 reads

4-4-5 Calendar Functions, Part 1

New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.  Read more...
By Cliff Corder 2010/09/06 (first published: 2009/09/28) | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 19,913 reads

4-4-5 Calendar Functions, Part 2

Part 2 showing how to get the Period in a 4-4-5 Calendar  Read more...
By Cliff Corder 2010/01/11 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 8,829 reads

SSRS Expressions Tips and Tricks

Some of the expressions and functions that have come in handy while developing reports in SSRS  Read more...
Rating: |  Discuss |   Briefcase | 20,599 reads

4-4-5 Calendar Functions, Part 1

New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.  Read more...
By Cliff Corder 2010/09/06 (first published: 2009/09/28) | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 19,913 reads
   Items 1 to 7 of 7