Hi,
Thanks its working fine
With Best Regards,
Suganthan,V
> -----Original Message-----
> From: Anjali Pradhan [SMTP:Anjali.[Email Address Removed] Sent: Thursday, April 29, 2004 4:41 PM
> To: Vallipuram, Suganthan
> Subject: RE: Need an urgent help in StoredProcedures
>
> hi
>
> select field1 from table where field1 not in(select field2 from
> tblarchreq)
>
> you will get the desired output.
>
> anjali
>
>
> -----Original Message-----
> From: Vallipuram, Suganthan [mailto:[Email Address Removed] Sent: Thursday, April 29, 2004 2:39 PM
> To: LazyDBA.com Discussion
> Subject: RE: Need an urgent help in StoredProcedures
>
>
> Hi,
> The solution doesn't support me.
> Again I will say the problem.
>
> I have only one table and this table contains 2 fields and both fields are
> integer. The first one is a unique one (AutoNumber). The second field may
> contain any integer. Now I want the numbers from the field1(AutoNumber)
> but
> the condition is these numbers should not be in field2 in the same table.
>
> Please suggest a solution which should run fast, because there a lot of
> datas in this table.
>
> Thanks in advanced
>
>
> With Best Regards,
> Suganthan,V
> Mobile : +94-77-7807639
>
> > -----Original Message-----
> > From: O15_11_2002 [SMTP:[Email Address Removed] > Sent: Thursday, April 29, 2004 2:54 PM
> > To: Vallipuram, Suganthan
> > Subject: Re: Need an urgent help in StoredProcedures
> >
> > your welcome : )
> >
> > ----- Original Message -----
> > From: "Vallipuram, Suganthan" <[Email Address Removed] > To: "O15_11_2002" <[Email Address Removed] > Sent: Thursday, April 29, 2004 11:48 AM
> > Subject: RE: Need an urgent help in StoredProcedures
> >
> >
> > > HI,
> > > Thank you so much. I will try it now
> > >
> > > With Best Regards,
> > > Suganthan,V
> > >
> > >
> > > > -----Original Message-----
> > > > From: O15_11_2002 [SMTP:[Email Address Removed] > > > Sent: Thursday, April 29, 2004 2:15 PM
> > > > To: LazyDBA.com Discussion
> > > > Subject: Re: Need an urgent help in StoredProcedures
> > > >
> > > > yes, i think "not exists" better than "not in", may fastly
> > > > Suganthan, you should use "not exists"
> > > >
> > > > regards
> > > > ali
> > > >
> > > > ----- Original Message -----
> > > > From: "Bart Hayes" <[Email Address Removed] > > > To: "LazyDBA.com Discussion" <[Email Address Removed] > > > Sent: Thursday, April 29, 2004 11:04 AM
> > > > Subject: RE: Need an urgent help in StoredProcedures
> > > >
> > > >
> > > > > A self join should do it:
> > > > >
> > > > > select field1 from someTable
> > > > > where not exists(select * from someTable T2
> > > > > where field2 = someTable.field1)
> > > > >
> > > > > -----Original Message-----
> > > > > From: Vallipuram, Suganthan [mailto:[Email Address Removed] > > > > Sent: Thursday, 29 April 2004 3:42 PM
> > > > > To: LazyDBA.com Discussion
> > > > > Subject: Need an urgent help in StoredProcedures
> > > > >
> > > > >
> > > > > > Dear Friends,
> > > > > >
> > > > > > In MSSQL server-7, I want to write a stored procedure in which I
> > would
> > > > > > like to search a field value which should not be in another
> field.
> > For
> > > > > > example
> > > > > >
> > > > > > Table1 and ite field are field1 and field 2 both are integer,
> but
> > the
> > > > > > field1 is unique (AutoNumber).
> > > > > > I would like to get the values of field1, but these values
> should
> > not
> > > > be
> > > > > > in the field2.
> > > > > >
> > > > > > Please help me as soon as possible
> > > > > >
> > > > > >
> > > > > > Thanks in advanced
> > > > > >
> > > > > > With Best Regards,
> > > > > > Suganthan,V
> > > > > >
> > > > > >
> > > > >
> > > > >
> > ---------------------------------------------------------------------
> > > > > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > > > > Get today's cartoon: http://www.LazyDBA.com
> > > > > To unsubscribe, e-mail: mssqldba-[Email Address Removed] ,
> > > > > then respond to the confirmation email you get
> > > > > For additional commands, e-mail: mssqldba-[Email Address Removed] > > > >
> > > >
> > > >
> ---------------------------------------------------------------------
> > > > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > > > Get today's cartoon: http://www.LazyDBA.com
> > > > To unsubscribe, e-mail: mssqldba-[Email Address Removed] ,
> > > > then respond to the confirmation email you get
> > > > For additional commands, e-mail: mssqldba-[Email Address Removed] > >
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Get today's cartoon: http://www.LazyDBA.com
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] ,
> then respond to the confirmation email you get
> For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page