First things first, I'm not using MS-SQL by choice and I consider myself a newbie...
I put two scripts together with UNION because of the way the tables are laid out. I just want some duplicate information removed. I have to use the same field name in the same table to get the service and the roll which is why I think I have to use a union in my script. Question: What tools are available to kill the effects of the UNION function? Here is an example of my return result.... row LName service roll 1 Smith physician 2 Smith medical 3 Anderson surgical 4 Anderson medical 5 Sowards physician 6 Gill physician I want it to look like this... row LName service roll 1 Smith medical physician 2 Anderson medical surgical 3 Sowards physician 4 Gill physician Every physician is going to have a roll but not every physician will have a service assigned. Is there any tool available or any simple script that could combine the two records if there is a service for that physician? If anyone can give me the name of a function you might use in whatever rdbms you use, maybe I can find the equivalent for MS-SQL...if there is one. TIA, John _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
