Finding the right JOIN type

Question

Post reply

Finding the right JOIN type

Viewing 10 posts - 46 through 54 (of 54 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

At this point it seems the two of you are putting in far more effort on this than the OP. 😉

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Anatoly Ukhvanov SSC Enthusiast Points: 191 More actions · Answer 2

ChrisM@Work (6/14/2012)
What I'm hoping to do is encourage the OP to find out for sure how these tables are supposed to relate to each other.

Me too, I think this should be clarified. As I understood, the relation is like this:

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 3

Sean Lange (6/14/2012)
At this point it seems the two of you are putting in far more effort on this than the OP. 😉

I'm outta here mate 🙂 job done.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Anatoly Ukhvanov SSC Enthusiast Points: 191 More actions · Answer 4

Sean Lange (6/14/2012)
At this point it seems the two of you are putting in far more effort on this than the OP. 😉

Yes, it is! I'm a newbie in SQL Server, that's why this problem (the topi? of the original post) is interesting to me, that's why I've spend so much time to write in this topic (hours). 🙂

reliableitservice SSC Enthusiast Points: 194 More actions · Answer 5

Well I have to thank you both for the results and time spent.

The story with this tables and database is: I work for a company who uses some ERP software that is written in FoxPro and uses SQL in the back end.

The software has a module to write reports but it is limited. I bought a copy of SQL with reporting services so we can start creating reports here.

I asked the ERP software for some help to understand the naming of the tables and the relation of them to one to another and I got nothing!!!

I discovered inside the ERP software the name of the tables that are used for each screen of data input plus running queries to find out the corresponding tables.

I am not sure if I would be able to explain the relationship of the zzxpgrpr and the zzxpgtyr but it will make more sense if you see the attached excel sheet at the beginning of the post. There is a screen shoot of the actual style reference window. Any given style may have a combinations of 8 different group codes. Each group code is described in the zzxpgtyr table and it is called Merchandise group.

I can tell you both the the work is done. You both have delivered more than enough and I thank you both for that. So let's save some efforts for more questions to come.

Anatoly Ukhvanov SSC Enthusiast Points: 191 More actions · Answer 6

reliableitservice (6/15/2012)
I can tell you the the work is done.

Do you mean you achieved the following?

reliableitservice (6/11/2012)
DESIRED results
STYLE LBL DIV
2204852 GOSSIP JUNIOR

Did suggested scripts do the desired work? Or you're still getting the following?

reliableitservice (6/13/2012)
still getting multiple results (9 actually).

Anatoly Ukhvanov SSC Enthusiast Points: 191 More actions · Answer 7

Folks, did you see that?! I'm not a grasshopper any more! I'm now SSC Rookie! :w00t:

Could anyone explain to me, a ukrainian, what does it mean? Which meaning from enumerated on Wikipedia is supposed?

Sean Lange SSC Guru Points: 286590 More actions · Answer 8

Anatoly Ukhvanov (6/15/2012)
Folks, did you see that?! I'm not a grasshopper any more! I'm now SSC Rookie! :w00t:
Could anyone explain to me, a ukrainian, what does it mean? Which meaning from enumerated on Wikipedia is supposed?

SSC = SQL Server Central.

The next piece is just silliness.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Anatoly Ukhvanov SSC Enthusiast Points: 191 More actions · Answer 9

Anatoly Ukhvanov

SSC Enthusiast

Points: 191

June 15, 2012 at 10:49 am

#1501796

Hurray! :w00t: :w00t: :w00t:

reliableitservice SSC Enthusiast Points: 194 More actions · Answer 10

Congratulation Anatoly!!!!!!

Yes, you were able to achieve what I was looking for.

The little detailed note about the "Division" was overlooked until you pointed it out. I sort of figured it out, that is why I send the extra data.

I was also able to integrate the script into my existing one where I have more tables in it.

You guys are awesome!!!!