Database

<br />
Create Procedure PrcUpdate_Pro_View<br />
(<br />
@Original_Primary_ID int,<br />
@Original_Tshwane_Prediction  float,<br />
@Lis_key varchar(50),<br />
@Tshwane_Prediction float<br />
)<br />
as<br />
UPDATE Property_mass SET   Tshwane_Prediction = @Tshwane_Prediction<br />
WHERE (Primary_ID = @Original_Primary_ID) And<br />
 (Tshwane_Prediction = @Original_Tshwane_Prediction <br />
OR @Original_Tshwane_Prediction IS NULL AND Tshwane_Prediction IS NULL)<br />
<br />
Update Property_Mass set Locked = Null  <br />
WHERE (SUBSTRING(Lis_Key, 1, 4) = @Lis_key And Locked=1) <br />
;SELECT Primary_ID, Boundary_area, Attrib_Code, Lis_Key, Func_Key,<br />
Actual_Extent, Improved_Value, Site_Value, Purchase_price,<br />
Purchase_date, prop_id, confidence_score, fin_ls_prediction, <br />
new_lis_key, new_func_key, Tshwane_Prediction, matchflag,<br />
source, flagtype FROM Property_mass WHERE (Primary_ID = @Original_Primary_ID)<br />
<br />

select PS.PROPERTY_id from Property_Summary PS
where PS.Cell_iD = 13 and Func_key like 'GEOSS%'

Exists(SELECT 1 FROM SDE.VALUATION V
WHERE PROPERTY_ID	= PS.PROPERTY_ID
AND VAL_STATUS_ID	= 2
AND NEW_IMPROVED_VALUE  <1
AND ARCHIVE_DATE IS NULL)

// VC++ code use to add data 
void CDbService::AddGData(string& fileName)
{
_CommandPtr pCom;

pCom.CreateInstance(__uuidof(Command));

pCom->ActiveConnection = m_pConn;
pCom->CommandType = adCmdStoredProc;
pCom->CommandText = _bstr_t("sp_GroupState");

// Add file name
pCom->Parameters->Append(pCom->CreateParameter(_bstr_t("FileName"), adVarChar, adParamInput, 50,&fileName));
}

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

CREATE PROCEDURE [dbo].[sp_GroupState] 
@FileName varchar, @State varchar
As
Insert into tblGroupState(DiskFileName, FileState)
Values (@FileName, @State);

USE [RFDB]
GO
/****** Object:  Table [dbo].[tblGroupState]    Script Date: 01/16/2008 10:54:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblGroupState](
	[DiskFileName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[FileState] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

I appreciate your help all the time...
Eranga

create view view_reports AS<br />
Select l.teach_id, tp.tp_pymt, t.teach_fname, t.teach_lname, tp.tp_pymt_mon, tp.tp_pymt_yr,<br />
count(l.stud_id), count(l.less_id) <br />
From tbl_teach_pymt tp, tbl_teachers t, tbl_lessons l<br />
Where l.less_start_date < cast(getdate() as datetime)<br />
AND l.less_end_date > cast(getdate() as datetime)<br />
Group BY l.teach_id;

create table tbl_teachers (<br />
teach_id int NOT NULL IDENTITY(51000,1),<br />
rent_id int,<br />
teach_fname text,<br />
teach_lname text,<br />
teach_add text,<br />
teach_unit_num text,<br />
teach_city text,<br />
teach_state text,<br />
teach_zip int,<br />
teach_instruments text,<br />
teach_email text,<br />
teach_phone int,<br />
teach_cell int,<br />
start_date datetime,<br />
primary key(teach_id),<br />
foreign key(rent_id) references tbl_rent(rent_id));<br />
<br />
create table tbl_teach_pymt (<br />
tp_id int NOT NULL IDENTITY(10000,1),<br />
teach_id int,<br />
tp_pymt money,<br />
tp_pymt_date datetime,<br />
tp_pymt_mon as(datepart(m, tp_pymt_date)) persisted,<br />
tp_pymt_yr as(datepart(yy, tp_pymt_date)) persisted,<br />
tp_date datetime,<br />
tp_credit text,<br />
primary key(tp_id),<br />
foreign key(teach_id) references tbl_teachers(teach_id));<br />
<br />
create table tbl_lessons (<br />
less_id int NOT NULL IDENTITY(30000,1),<br />
teach_id int,<br />
stud_id int,<br />
less_start_date datetime,<br />
less_end_date datetime,<br />
less_time as(datepart(hh:mm, ss_datetime)) persisted,<br />
less_day int,<br />
less_instrument text,<br />
primary key(less_id),<br />
foreign key(teach_id) references tbl_teachers(teach_id),<br />
foreign key(stud_id) references tbl_students(stud_id));