I have a table called "Issue" and table called "Receive" and both have same attributes they are "code,curr_val,date,coin_note,no_of_items,amount,operator_id,officer_id"And also code ,curr_val, and date are superkeys. data types are char(8),datetime,char(1)if t is a coin c,if it is a note n,money,char(8),char(8) I'm using sql server 2000 I want to get the difference of currency values (ex no of $10notes,$50 notes).In other words I want to get the difference of Items in the "no_of items"attribute. I tried toget notes value and no of notes items in receive table. >SELECT curr_val,count(*)AS Items ,SUM (amount)AS Amount_Rs FROM RECEIVE AS R WHERE coin_note='n'GrOUP BY curr_val I tried toget notes values and no of notes items in issue table >SELECT curr_val,count(*)AS Items ,SUM (amount)AS Amount_Rs FROM ISSUE AS I WHERE coin_note='n'GrOUP BY curr_val . What I want is the difference betveen the items values of R and I with their currency value please help ASAP Thanx Thilani

There is a data grid and I have entered data into datagrid.So I want to store these in a database table .How can I do it. :( This is very Argent

How to excecute stored procedure by using c# application in run time? I need to know the coding. Please someone help me as soon as possible Thanx

Thilani