Generate a column with data from 2 columns

[gradinumcp]

Hi there!

I have 2 columns:

1) Division--with numbers 100, 101, 102,....

2) Stations-with numbers 1,2,3,...

I want to create another column say "Div-Station" with values 100-1, 100-2, 100-3, 101-1, 101-2.....so on.

How do i do that in SQL server. I am an absolute beginner in this.

Thanks!

 

[sleipnir214]

UPDATE <tablename> SET <destination columnname> = CONCAT (<first source columnname>, '-', <second source columnname>)

is one way. There are likely others.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[sleipnir214]

If this table will have rows added to it regularly, creating this additional column is probably contraindicated, as you will have to run this update after every insert.

You could just derive the column during your select statements.


Want the best answers? Ask the best questions!

TANSTAAFL!!