Advertisement

10.13.2008 at 05:56AM PDT, ID: 23809299 | Points: 500
[x]
Attachment Details

HTMPL coding

Asked by samir_santra in JavaScript, JScript, Web Services

Tags: ,

I am using SQL 2000 database with SP4 . I have a table called call_req and colums are

ref_num, open_date , close_date , Serial_no

Requirement is  I want htmpl code for following logic

if open_date > 1-oct-08 and close_date < 31-oct-08
{
count(seril_no)
if count(serial_no) >2 then alert ('message')
}
Start Free Trial
[+][-]10.24.2008 at 05:44AM PDT, ID: 22795606

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-42 - Hierarchy / EE_QW_2_20070628