duplicates

Wed, 29 Sep 2004 13:06:00 +0100

This is a multi-part message in MIME format.

------=_NextPart_000_0037_01C4A625.10F97080
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

If you have syntax like 'report field1 feild2 etc.' you could try using
syntax like 'heading at sortitem field1 feild2 etc.'

Regards, Joe.

This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this e-mail and any
attachments sent with it may have been altered without the consent or
knowledge of the author.

  _____  

From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Kristina Carlton
Sent: 28 September 2004 19:19
To: 'powerh-l@lists.sowder.com'
Subject: duplicates

Hi,

I am running a Quiz extract and I am using the SET NODUPLICATES command.
However, I am getting duplicates anyhow. What might I be doing wrong?

To clarify further, I run an extract with claim detail information. The
claim detail information has the treating physician's FEIN. I access the
subfile that is created and link it to our physician file to get detailed
physician info. There could be multiple entries in the claim file for each
physician obviously, but I was hoping they would not be duplicated in my
physician detail extract. Actually, it works for all but one physician (this
is a small sample only). I checked that database and do not have duplicates
in the physician table.

Thanks,

-Kristina

Ext. 2459

------=_NextPart_000_0037_01C4A625.10F97080
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:"Century Gothic";
	panose-1:2 11 5 2 2 2 2 2 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:9.0pt;
	font-family:"Century Gothic";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:9.0pt;
	font-family:"Century Gothic";}
p
	{mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	font-size:12.0pt;
	font-family:"Times New Roman";}
span.EmailStyle16
	{mso-style-type:personal;
	font-family:"Century Gothic";
	color:#333399;}
span.EmailStyle19
	{mso-style-type:personal-reply;
	font-family:Arial;
	color:navy;}
@page Section1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>If you have syntax like =
&#8216;report field1
feild2 etc&#8230;&#8217; you could try using syntax like &#8216;heading =
at
sortitem field1 feild2 etc&#8230;&#8217;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>Regards, Joe.</span></font><font color=3Dnavy><span
style=3D'color:navy'><o:p></o:p></span></font></p>

This e-mail and all information contained in it is
confidential and may be legally privileged. If you are not the =
intended recipient,
your access to this e-mail is unauthorized. Any use, dissemination,
distribution, publication or copying by you of this e-mail or any of the
information contained within it is prohibited and may be unlawful. Do =
not open
any attachments, delete it immediately from your system and notify the =
sender
promptly by e-mail that you have done so. The content of this e-mail and =
any
attachments sent with it may have been altered without the consent or =
knowledge
of the author.<o:p></o:p>

</div>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;font-family:"Times New Roman"'>

<hr size=3D3 width=3D"100%" align=3Dcenter tabindex=3D-1>

</span></font></div>

<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'> =
powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] <b><span =
style=3D'font-weight:bold'>On
Behalf Of </span></b>Kristina Carlton<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 28 September 2004 =
19:19<br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
'powerh-l@lists.sowder.com'<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> =
duplicates</span></font><font
size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;font-family:"Times New =
Roman"'><o:p></o:p></span></font></p>

</div>

<p class=3DMsoNormal><font size=3D1 face=3D"Century =
Gothic"><o:p>&nbsp;</o:p></font></p>

<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt'>Hi,<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt'><o:p>&nbsp;</o:p></span></font></span></p>

I am running a =
Quiz
extract and I am using the SET NODUPLICATES command. However, I am =
getting
duplicates anyhow. What might I be doing =
wrong?<o:p></o:p>

<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt'><o:p>&nbsp;</o:p></span></font></span></p>

To clarify =
further, I run
an extract with claim detail information. The claim detail information =
has the
treating physician&#8217;s FEIN. I access the subfile that is created =
and link
it to our physician file to get detailed physician info. There could be
multiple entries in the claim file for each physician obviously, but I =
was
hoping they would not be duplicated in my physician detail extract. =
Actually,
it works for all but one physician (this is a small sample only). I =
checked
that database and do not have duplicates in the physician =
table.<o:p></o:p>

<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt'><o:p>&nbsp;</o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt'>Thanks,<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span
class=3DEmailStyle16><font size=3D2 color=3D"#333399" face=3D"Century =
Gothic"><span
style=3D'font-size:10.0pt'>-Kristina<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span style=3D'font-size:10.0pt'>Ext. =
2459</span></font></span><o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

</div>

</body>

</html>

------=_NextPart_000_0037_01C4A625.10F97080--