Hi,
I have been using access for several years now and am getting up to speed in SQL Server now.
In Access, you can create a new column that is based upon other columns in the table. Then, within the same query, you can use the new column as a basis for a new calculated column and so on.
My question is that I see in SQL Server views I don't have this ability. So, if I use a column from a table to create a calculated column, I can't then refer to that new column within the same view.
Rather, I have to either create a new view on top of the first view where I am then allowed to use the new column or I have to copy all of the calculations from the old column into the new calculations (which makes it very messy).
Has anyone seen an easier solution here? Thanks
Best Regards,
C
I have been using access for several years now and am getting up to speed in SQL Server now.
In Access, you can create a new column that is based upon other columns in the table. Then, within the same query, you can use the new column as a basis for a new calculated column and so on.
My question is that I see in SQL Server views I don't have this ability. So, if I use a column from a table to create a calculated column, I can't then refer to that new column within the same view.
Rather, I have to either create a new view on top of the first view where I am then allowed to use the new column or I have to copy all of the calculations from the old column into the new calculations (which makes it very messy).
Has anyone seen an easier solution here? Thanks
Best Regards,
C