adding sorels.fpartno = aritem.fpart cuts it down from 3075 to 1204
but there's no fitem in sorels
data looks ok, it lists the same record 3 times
With that change do you now still see duplicate results?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
mcummings (7/31/2013)
adding sorels.fpartno = aritem.fpart cuts it down from 3075 to 1204but there's no fitem in sorels
As I said, WE are guessing - you shouldn't be .
If you don't understand how those tables are related, you should not be changing anything until you learnt the relationships.
Sorry to be blunt, but if you are being paid to do this, you should learn not guess.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);
yesa
mister.magoo (7/31/2013)
mcummings (7/31/2013)
adding sorels.fpartno = aritem.fpart cuts it down from 3075 to 1204but there's no fitem in sorels
As I said, WE are guessing - you shouldn't be .
If you don't understand how those tables are related, you should not be changing anything until you learnt the relationships.
Sorry to be blunt, but if you are being paid to do this, you should learn not guess.
+1
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
What ever happened to civility? Is everyone born with equal knowledge and experience? No, it is gained day by day. We should be more courteous toward someone who is asking for help......
SSNinja (7/31/2013)
What ever happened to civility? Is everyone born with equal knowledge and experience? No, it is gained day by day. We should be more courteous toward someone who is asking for help......
#1 - We tried to help.
#2 - We don't know the data and how the tables are related so we don't know what is wrong.
#3 - We're not the ones getting paid to do this.
We tried!
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
SSNinja (7/31/2013)
What ever happened to civility? Is everyone born with equal knowledge and experience? No, it is gained day by day. We should be more courteous toward someone who is asking for help......
... says the one that has not posted a single "courteous" hint
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply