Hello,
 I have an table with fromdate and todate columns in experince table.
 fromdate todate
 01/10/2000 01/10/2001
 10/10/2001 11/11/2003
 12/11/2003 09/12/2005
 i want to insert values
 fromdate todate
 10/10/2005 3/10/2006 as fromdate todate experinece dates.
 i am using sql server as backend and asp as frontend.
 before inserting i want is any experience available with this values
 in the above three rows.
 Please help me in this scenario
 Regards,
 Rama Kishore,
 ramakishoreiic@.gmail.comHi
I'm confused
Can you explain more what are you trying to achivie?
IF NOT EXISTS ( SELECT * FROM Table WHERE ...)
--Inserting here
ELSE
something else
<ramakishoreiic@.gmail.com> wrote in message
news:1143029185.205342.166360@.i40g2000cwc.googlegroups.com...
> Hello,
> I have an table with fromdate and todate columns in experince table.
> fromdate todate
> 01/10/2000 01/10/2001
> 10/10/2001 11/11/2003
> 12/11/2003 09/12/2005
>
> i want to insert values
> fromdate todate
> 10/10/2005 3/10/2006 as fromdate todate experinece dates.
> i am using sql server as backend and asp as frontend.
> before inserting i want is any experience available with this values
> in the above three rows.
> Please help me in this scenario
> Regards,
> Rama Kishore,
> ramakishoreiic@.gmail.com
>
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment