Question: Fix sql code : I get the error in SQL Report Builder An item with same key has been added this is my sql query::
Fix sql code :
I get the error in SQL Report Builder "An item with same key has been added"
this is my sql query::
SELECT top 75 * FROM [EOLTData].[dbo].eolt_scenario_value v (NOLOCK) JOIN [EOLTData].[dbo].eolt_scenario o (NOLOCK) ON o.id = v.eolt_scenario_id JOIN [EOLTData].[dbo].eolt_sequence q (NOLOCK) ON q.id = o.eolt_sequence_id JOIN [EOLTData].[dbo].eolt_process p (NOLOCK) ON p.id = q.eolt_process_id JOIN [EOLTData].[dbo].eolt_stage g (NOLOCK) ON g.id = p.eolt_stage_id
ORDER BY g.stage_start
____________________________________________________
i would to to keep all coulmns but exclude id columns beside eolt_scenario_value v
Step by Step Solution
There are 3 Steps involved in it
The error message An item with the same key has been added typically indicates that there are columns with the same name in different tables which cau... View full answer
Get step-by-step solutions from verified subject matter experts
