Today I had a unique scenario where I had to introduce 2 spaces in between two fields.
I came across the space function which I used in my scenario.
The syntax is space(integer_expression)
The integer expression is an integer. IF a negative value is supplied a null is returned.
So for example look at the following syntax:
select First_name, + space(4) + Last_Name from test_table
The above select statement will generate 4 spaces in between the first name and last name
The space function will generate a miximum of 8000 spaces.
For more information click here
Below is a process that I follow every year to create a partition in existing multi-dimensional SSAS cubes that I maintain. Log in to t...
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
Did you ever have a situation where you felt like converting a Sql Server Analysis Services in Multidimensional Mode to Tabular Mode ? ...
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des...