Comments by Member 10463904 (Top 19 by date)

s s when i am executing i got the error as
Msg 8114, Level 16, State 1, Procedure form, Line 0
Error converting data type varchar to date.

s s i got the error..
Msg 8114, Level 16, State 1, Procedure form, Line 0
Error converting data type varchar to date.

I already post my codes... My problem is in joining part only.. i got the result of only the left table.. cant able to get the result of another table... i dont kow the what is the problem of joining

DVN_CD PHC_CD HSC_CD IDNO ANC_fullID Res_visitor ANM_NAME HUSB_NAME PHONE1 PHONE2 Address Age Community Anm_Edu Husb_Edu Gravida Para LMP EDD AN_Reg_Date Height Blood_group VDRL HIV Husb_HIV Remarks Scan1_Date Scan1_Result Scan1_Findings Scan2_Date Scan2_Result Scan2_Findings Scan3_Date Scan3_Result Scan3_Findings AN_HR_Ref AN_Compln AN_Ref_Date AN_Ref_Place AN_Ref_Compliance N_HR_Ref N_Compln N_Ref_Date N_Ref_Place N_Ref_Compliance Deli_place_Suggested Preg_Outcome Deli_Date Deli_nature No_Borns Deli_place Deli_dist Deli_hosp Partograp Survival_Status Death_Period Death_place Death_date Death_cause VitA PN_HR_Ref PN_Compln PN_Ref_Date PN_Ref_Place PN_Ref_Compliance FW_Services GDM_Sugar45 Closed Closed_Reason Closed_Date Closed_UpdDate UpdDate RepDate AppDate ohsc_cd Genl_updDate ANRef_updDate Scan_UpdDate Natal_updDate PNRef_updDate PN_UpdDate Deli_updatedBy Instalment1 Instalment2 Instalment3 Migrated_Date Scan1 Scan2 Scan3 preg_outcome1 preg_outcome2 preg_outcome3
40 8301 01 23474 40830101023474 1 rani ramesh 9551137424 71/14,6th street,a.s.nagar 23 3 4 4 1 0 2010-10-04 00:00:00.000 2011-07-11 00:00:00.000 2010-12-01 00:00:00.000 157 2 2 2 2 2011-01-01 00:00:00.000 1 2011-03-02 00:00:00.000 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 2011-07-07 15:30:00.000 1 1 3 40 NULL 2 1 NULL NULL NULL NULL 1 0 NULL 0 0 3 NULL 1 0 NULL 2012-01-29 11:26:59.000 2012-01-29 11:26:59.000 NULL 2012-01-29 11:22:00.000 NULL 2012-01-29 11:22:00.000 2012-01-29 11:26:49.000 NULL 2012-01-29 11:25:38.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
40 8301 01 23476 40830101023476 1 TAMIL SELVI MURUGAN 9841854046 36,8TH STREET,A.S.NAGAR 25 3 2 4 2 1 2010-10-18 00:00:00.000 2011-07-25 00:00:00.000 2010-12-02 00:00:00.000 160 4 2 2 2 2011-02-01 00:00:00.000 1 2011-04-25 00:00:00.000 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 2011-07-20 22:20:00.000 1 1 3 40 NULL 2 1 NULL NULL NULL NULL 1 0 NULL 0 0 4 NULL 1 0 NULL 2012-01-29 11:39:55.000 2012-01-29 11:39:55.000 NULL 2012-01-29 11:35:40.000 NULL 2012-01-29 11:35:40.000 2012-01-29 11:39:46.000 NULL 2012-01-29 11:38:47.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
40 8301 01 23477 40830101023477 1 KALAIVANI RAJESH 9941977291 33,6TH STREET,A.S.NAGAR 25 1 3 4 1 0 2010-10-05 00:00:00.000 2011-07-12 00:00:00.000 2010-12-03 00:00:00.000 159 1 2 2 2 2011-01-03 00:00:00.000 1 2011-03-02 00:00:00.000 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 2011-07-11 10:05:00.000 1 1 3 40 NULL 2 1 NULL NULL NULL NULL 1 0 NULL 0 0 3 NULL 1 0 NULL 2012-01-29 11:46:15.000 2012-01-29 11:46:15.000 NULL 2012-01-29 11:42:21.000 NULL 2012-01-29 11:42:21.000 2012-01-29 11:46:07.000 NULL 2012-01-29 11:45:16.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
40 8301 01 23478 40830101023478 1 ANITHA ILAYARAJA 9841980776 69,7TH STREET,A.S.NAGAR 23 1 4 5 2 1 2010-10-20 00:00:00.000 2011-07-27 00:00:00.000 2010-12-03 00:00:00.000 160 4 2 2 2 2011-01-05 00:00:00.000 1 2011-03-02 00:00:00.000 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 2011-07-20 17:28:00.000 3 1 3 40 NULL 2 1 NULL NULL NULL NULL 1 0 NULL 0 0 4 NULL 1 0 NULL 2012-01-29 11:52:11.000 2012-01-29 11:52:11.000 NULL 2012-01-29 11:47:55.000 NULL 2012-01-29 11:47:55.000 2012-01-29 11:52:04.000 NULL 2012-01-29 11:50:59.000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
40 8301 01 23480 40830101023480 1 DHATCHAYINI PRABAKARAN 9790864587 56/59,5TH STREET,A.S.NAGAR 24 3 4 4 1 0 2010-09-18 00:00:00.000 2011-06-25 00:00:00.000 2010-12-07 00:00:00.000 160 2 2 2 2 2011-01-05 00:00:00.000 1 2011-03-05 00:00:00.000 1 2011-04-06 00:00:00.000 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 3 2011-07-01 22:20:00.000 1 1 3 40 NULL 2 1 NULL NULL NULL NULL 1 0 NULL 0 0 3 NULL 1 0 NULL 2012-01-29 12:11:23.000 2012-01-29 12:11:23.000 NULL 2012-01-29 12:07:10.000 NU

i need only classic asp, not C# and VB

pls tell me the rest of the codes

Pls help me how to export sql query result in excel... Tell me full coding explanation.. im new to sql

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en">
<head>
<meta charset="utf-8">
<title>IMMUNIZATION SCHEDULE</title>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><style type="text/css">
<!--
body {
background-color:#F7F7F7;
}
.style2 {font-size: 18px; }
-->
</style>
</head>
<script language="JavaScript">
// JavaScript Document
function validatedate(inputText)
{
var dateformat = /^(0?[1-9]|[12][0-9]|3[01])[\/\-](0?[1-9]|1[012])[\/\-]\d{4}$/;
// Match the date format through regular expression
if(inputText.value.match(dateformat))
{
document.form1.text1.focus();
//Test which seperator is used '/' or '-'
var opera1 = inputText.value.split('/');
var opera2 = inputText.value.split('-');
lopera1 = opera1.length;
lopera2 = opera2.length;
// Extract the string into month, date and year
if (lopera1>1)
{
var pdate = inputText.value.split('/');
}
else if (lopera2>1)
{
var pdate = inputText.value.split('-');
}
var dd = parseInt(pdate[0]);
var mm = parseInt(pdate[1]);
var yy = parseInt(pdate[2]);
var ww=parseInt(pdate[3]);
// Create list of days of a month [assume there is no leap year by default]
var ListofDays = [31,28,31,30,31,30,31,31,30,31,30,31];
if (mm==1 || mm>2)
{
if (dd>ListofDays[mm-1])
{
alert('Please Enter Date!');
return false;
}
}
if (mm==2)
{
var lyear = false;
if ( (!(yy % 4) && yy % 100) || !(yy % 400))
{
lyear = true;
}
if ((lyear==false) && (dd>=29))
{
alert('Invalid date format!');
return false;
}
if ((lyear==true) && (dd>29))
{
alert('Invalid date format!');
return false;
}
}
}
else
{
alert("Please Enter Date!");
document.form1.text1.focus();
return false;
}

document.form1.text2.value=document.form1.text1.value;
document.form1.text3.value=document.form1.text1.value;

//After 6th week Date
var dt=MyDate(document.form1.text1.value);
var tmp;
if (dt.getDate()<10)
{ tmp="0"+dt.getDate();}
else
{ tmp=dt.getDate();}
if (dt.getMonth()<9)
{ tmp=tmp+"/"+"0"+(dt.getMonth()+1);}
else
{ tmp=tmp+"/"+(dt.getMonth()+1);}

var tmp=tmp+"/"+dt.getFullYear();
document.form1.hepb.value=tmp;
document.form1.hepbh.value=tmp;
document.form1.bcg.value=tmp;
document.form1.bcgh.value=tmp;
//After 6th week date--(6weeks*7days=42)
dt.setDate(dt.getDate()+42);
document.form1.pen1.value=setMyDateFormat(dt);
document.form1.penh1.value=setMyDateFormat(dt);
//after 10th week date-- Alredy 6 weeks added (10-6=4*7=28)
dt.setDate(dt.getDate()+28);
document.form1.pen2.value=setMyDateFormat(dt);
document.form1.penh2.value=setMyDateFormat(dt);
//After 14th week date(14-10=4*7=28)
dt.setDate(dt.getDate()+28);
document.form1.pen3.value=setMyDateFormat(dt);
document.form1.penh3.value=setMyDateFormat(dt);
//After 9 month date
// dtt.setMonth(dt.getMonth()+9); already 14weks over (9month*4weeks=36weeks) 36-14=22weeks+21days(7*3),, (22+3)=25*7=175
dt.setDate(dt.getDate()+175);
document.form1.meas.value=setMyDateFormat(dt);
document.form1.meash.value=setMyDateFormat(dt);
}
/*Date.protot

Now im getting this kind of error.. ahat should i do now????

Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.

alter function fzz(@mdvn int,@fdate date,@tdate date)
returns @tabs table
(
DVN int,
PHC int,
HSC int,
ANC int,
TT1 int,
TTB int,
IFA int,
BP int,
HB int
)
as
begin
declare @DVN int,@PHC int,@HSC int,@ANC int,@TT1 int,@TTB int,@IFA int,@BP int,@HB int
declare fnc cursor for
select dvn_cd,phc_cd,hsc_cd,sum(ANC1) as ANC,SUM(TT1) as TT1,sum(TTB2) as TT2,sum(IFA1) as IFA,sum(BP1) as BP,sum(HB1) as HB from
(
select dvn_cd,phc_cd,hsc_cd,
case when visit_no=3 and Visit_date between @fdate and @tdate then 1 else 0 end as ANC1,
case when TTB=1 and TTDate between @fdate and @tdate then 1 else 0 end as TT1,
case when TTB>1 and TTDate between @fdate and @tdate then 1 else 0 end as TTB2,
case when IFA=100 and ANEDD between @fdate and @tdate then 1 else 0 end as IFA1,
case when BP>='140/90' and ANEDD between @fdate and @tdate then 1 else 0 end as BP1,
case when HB<11 and ANEDD between @fdate and @tdate then 1 else 0 end as HB1
from anvisits3 where dvn_cd=@mdvn and ANEDD between @fdate and @tdate
)a group by dvn_cd,phc_cd,hsc_cd
open fnc
fetch next from fnc into @DVN,@PHC,@HSC,@ANC,@TT1,@TTB,@IFA,@BP,@HB
while @@fetch_status=0
begin
insert into @tabs
select 'DVN'+convert(varchar(20),@DVN),'PHC'+convert(varchar(20),@PHC),'HSC'+convert(varchar(20),@HSC),
'ANC'+convert(varchar(20),@ANC),'TT1'+Convert(varchar(20),@TT1),'TTB'+convert(varchar(20),@TTB),'IFA'+convert(varchar(20),@IFA),
'BP'+convert(varchar(20),@BP),'HB'+convert(varchar(20),@HB)
fetch next from fnc into @DVN,@PHC,@HSC,@ANC,@TT1,@TTB,@IFA,@BP,@HB
end
return
end



SELECT * FROM fzz(40,'2011/01/01','2011/12/31')
---------------
i ubdated my query but now im getting the error as

Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'DVN40' to data type int.

now im getting this kind of error..

Msg 213, Level 16, State 1, Procedure func2, Line 46
Column name or number of supplied values does not match table definition.

noe im geting this kind of error.

Msg 213, Level 16, State 1, Procedure func2, Line 46
Column name or number of supplied values does not match table definition.

Thank u sir

Thank u sir