i have an asp page in which i have a query something like this:
sql="select a.aid,a.empno as aempno,b.bid,b.empno as bempno
from allocation a ,build b
where a.someid=b.someid"
set rs=cn.execute(sql)
if not rs.eof then
if(eval(rs("aid"))<> eval(rs("aempno")) then
pendingAt="Person1";
endif
endif
can somebody help me in converting this query into a query for asp.net page?(in sql server 2005)
thanks in advance
Thanks and Regards,
Hoosha Boosha