I need some help to finish my code as this programming is new to me. I have 110 Entity_SQN number that I need to generate a new line based on current values for that SQN Number in the DIM_Category table, where I need to alter only 2 column values in the new line.
Example: for each Entity_SQN I need a new line where Detail_SQN should be 0, Grouping1,Grouping2,Descri
ption, Entity and Entity_SQN should be the same as in DIM_Category for that Entity_SQN and Text should have the value 'No Category'
I would appreciate if someone could help me finish the code, what I'm having problems with is how do I insert the values from the DIM_Category table?
DECLARE @Detail_SQN int,
SET @Detail_SQN = 0
set @Grouping1 = ?
set @Grouping2 = ?
set @Description = ?
set @Text = 'No Category'
set @Entity = ?
set @Entity_SQN = ?
--This query gives me the correct result to add into the DIM_Category table
Select distinct @Detail_SQN,Grouping1,Grouping2,Description,@Text,Entity,Entity_SQN
where Entity_SQN in