In MS SQL I need to select particular values by name from a table and insert them into a single row in another table.
In a real basic sense I need this but 10+ results into a 10+ column row with a date/time reference.
Insert into [table2].[namealias1]
Select [number] as namealias1
Where [name] = 'name1'
DATESTAMP NameAlias1 NameAlias2
Or is this the best way to even think about it?
The end goal is to record the specific values with a time stamp in a single row in another table.