March 7, 2014 at 2:49 pm
What I exect is something like
Select record_id
from Security_assignement
Join....
where ........
The the return is
494
Thanks!
March 7, 2014 at 3:04 pm
Seattlemsp (3/7/2014)
What I exect is something likeSelect record_id
from Security_assignement
Join....
where ........
The the return is
494
Thanks!
It is crystal clear except for the portions where you have a series of dots and the logic required to get the output.
As I said previously why only 494 and not 61??? It seems you have some logic in your head that you are not sharing with us. We are trying to help but you are not trying to help us.
Perhaps the article referenced here will help.
_______________________________________________________________
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/
March 7, 2014 at 3:06 pm
The closest I can come up with is something like this.
select *
from security_assignment sa
join matter m on m.r_type = sa.r_type
join [group] g on g.group_id = sa.group_id
join category c on c.category_id = m.category_id and m.r_type = sa.r_type
This returns both 61 and 494 for all the values that match but obviously is not totally correct as the matter gets mixed into it. Unless you can explain this in a way that makes sense I am going to leave this to somebody else.
_______________________________________________________________
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/
March 11, 2014 at 4:01 pm
It is pretty close!
The reason for 61 not support to return bacause:
1. The M 61 does have two groups which are exect the same as it assoicated catgory
2. Hower the C 12363 has additional group of 100073 assigned to it but the M 61 doesn't have that group.
Not sure if this task is possible.
I apploigize of my slow responding. It has been a crazy time.
Many thanks your helpes!
Tianhong
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply