MDX Time Calculations Built to Scale

When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS...

MDX Time Calculations Built to Scale

When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS...

More than sp_help

If you have worked with SQL Server for very long you have probably run across the extremely useful system function...

IN clause in SQL Server

With IN clause, we can specify multiple values in a WHERE clause.

For example, in case of "IN", one can use...

Announcing SQL Server Radio – English Edition!

About a year and a half ago, I approached Guy and asked him if he wanted to start a podcast...

AVG() function in SQL Server

Avg():- This function is used to get the average value of a numeric column

Syntax:-

      SELECT AVG(column_name) FROM table_name

In this article,...

UPPER() function in SQL Server

UPPER():- This function is used to convert the value of a column to upper case.

 Syntax:

   SELECT UPPER(string)

OR

Select UPPER(Column name)...

LEN() function in SQL Server

LEN():- This function is used to get the length of the given string value.

  Syntax:-

    Select len (stringvalue)

  For example,

   ...

LOWER() function in SQL Server

LOWER():- This function is used to convert the value of a column to lower case

 Syntax:-

 Select LOWER (string)
 
 or
 
 SELECT LOWER(column_name) FROM table_name

For...

LTRIM() function in SQL Server

LTRIM ():- This function is used to get the string after the removal of leading blank spaces.

Syntax:-

LTRIM ( character_expression )

For example:-

Select LTRIM ...