Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 help please

Author  Topic 

jql
Starting Member

30 Posts

Posted - 2010-12-17 : 10:04:48
i have a table that has referral numbers. each referral is into a certain dept. it then gets passed on to different departs but gets a new referral referral number
dept reason ref
admin query 1
sales asse 2
HR rehab 3

i need to show the the ref 1 reason but group the contacts from each of the sub referras.

Referral no.1 will always be admin

i know i have not explained very well but am having a lot of trouble with this query so any help will be appreciated

Thank you

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2010-12-17 : 12:32:47
I'm not following you. Perhaps this link can help you post your question in a way that we can help you better:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-12-20 : 08:51:45
See if this helps
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -