How to have data in Range column

I have 1 table named Temp1 and Columns are as below. In this table we have to make sure that salary of employee for any designation must be in between TopRange and Bottom Range. So I need to create a column combining 2 column Salary Top Range and Salary Bottom range

Emp ID  (primary key)
Emp Name
Designation
Salary 
Salary top range 
salary bottom range

​x
 
Emp ID  (primary key)Emp NameDesignationSalary Salary top range salary bottom range ​

Sample data:

Emp ID  -123,
Emp Name  - ABC,
Designation  - Executive,
Salary -10000,
Salary top range - 15000,
Salary bottom Range - 3000

 
Emp ID  -123,Emp Name  - ABC,Designation  - Executive,Salary -10000,Salary top range - 15000,Salary bottom Range - 3000 ​

I want to create a column Range with a value of 3000-15000. Is that possible in SQL Server?

Answer

You can add a computed column:

alter table t add column salary_range as
     ( concat(bottom, '-', top) );

 
alter table t add column salary_range as     ( concat(bottom, '-', top) );​

This column will be calculated when you query it, so it will always be up-to-date.

Note that range is a SQL keyword, so I renamed it to salary_range. As a keyword, it is used in defining the window frame for a window function.

Advertisement

Answer