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
Did you know that you could export data from different SSRS Tablix into different excel sheets of a workbook?
Today I had a requirement from one of my customer to export data from two different tables generated out of SSRS reports into two different...
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...