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

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!