Inserting a Value in a Field not in a View

Transact-SQL
1

I have a source column in a table called DAILY. When I insert the view into the table I want it to update the Source with DAILY. Do I have to do an insert into or update into the Source column after the other data is appended? Or can you do it in a view query? Thanks in Advance

2

You could do something like this:

INSERT INTO YourTable
(
    Column1,
    Column2,
    Column3,
    SourceColumn
)
SELECT
    Column1,
    Column2,
    Column3,
    'DAILY'
FROM
    YourView;
1 Like
3

Thank you I will give that a try