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
Hi
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.googlegr oups.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