July 20, 2011 at 7:39 am
Hi
I was wondering if someone could shed some light as to what this error message means in SSRS 'An item with the same key has already been added'.
I believe that the error message relates to this section of the store procedure( i could be wrong) but i don't seem to have any problem otherwise
SELECT H.Item
, H.Company
, H.Division
, H.Corporation
, H.Sold
, H.Department
, H.ShipTo
, H.Hist1
, H.Hist2
, H.Hist3
, H.Hist4
, H.Hist5
, H.Hist6
, H.Hist7
, H.Hist8
, H.Hist9
, H.Hist10
, H.Hist11
, H.Hist12
, M10.Item
, M10.May10_Ad1
, M10.May10_Ad2
, M10.May10_Ad3
, M10.May10_Ad4
, M10.May10_Ad4
, M10.May10_Ad5
, M10.May10_Ad6
, M10.May10_Ad7
, M10.May10_Ad8
, M10.May10_Ad9
, M10.May10_Ad10
, M10.May10_Ad11
, M10.May10_Ad12
FROM #History H INNER JOIN
#FcstMay10 M10
ON H.Item = M10.Item
If you need more information please let me know
__________________________________________________________________________________
Steve J
Jnr Developer
BSc(Hon)
July 20, 2011 at 7:47 am
Try this 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 20, 2011 at 8:14 am
I've done the google search and i understand that SSRS only uses the column names as a key not the table + column names. I've changed it to the following but still getting the same error message
SELECT --H.ItemH
H.Company
, H.Division
, H.Corporation
, H.Sold
, H.Department
, H.ShipTo
, H.Hist1
, H.Hist2
, H.Hist3
, H.Hist4
, H.Hist5
, H.Hist6
, H.Hist7
, H.Hist8
, H.Hist9
, H.Hist10
, H.Hist11
, H.Hist12
, M10.May10_Ad1
, M10.May10_Ad2
, M10.May10_Ad3
, M10.May10_Ad4
, M10.May10_Ad4
, M10.May10_Ad5
, M10.May10_Ad6
, M10.May10_Ad7
, M10.May10_Ad8
, M10.May10_Ad9
, M10.May10_Ad10
, M10.May10_Ad11
, M10.May10_Ad12
FROM #History H INNER JOIN
#FcstMay10 M10
ON H.ItemH = M10.ItemM
__________________________________________________________________________________
Steve J
Jnr Developer
BSc(Hon)
July 20, 2011 at 8:19 am
M10.May10_Ad4 is repeated twice?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 20, 2011 at 8:35 am
Your right didn't spot that one works perfectly thanks
__________________________________________________________________________________
Steve J
Jnr Developer
BSc(Hon)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply