Here is my Sample Data (Below SQL For Create Sample Data)
Here is End result Looks like.
What I want to check Visit column If Visit is more then 1 then create a duplicate row. First row with all Information i.e (4,Sam,P,111,2). However, Second row should be without Amount (4,Sam,P,,2) Because we don't want to calculate the same amount twice.
Please help how I can accomplish this one in SQL or SSIS.
Here is the SQL
Create Table InsertMore
insert into InsertMore
Select * from InsertMore