Database

CREATE PROCEDURE SelectRecipient
AS
DECLARE @mail nvarchar(4000)
Select Mail FROM Member
select Mail from Member
exec @mail = SelectRecipient
select @mail
GO

CREATE PROCEDURE SelectRecipient
AS
SELECT Mail from Member
GO

SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandTypeStoredProcedure;
cmd.CommandText = "SelectRecipient";
cmd.Connection = myConnection;
SqlReader reader = cmd.ExecuteReader()
while(reader.Read())
{
    string mail = reader.GetString(0);
    // Do something with the result
}

CREATE PROCEDURE SelectRecipient
@Recipient varchar(40)
AS
Select Mail FROM Member
Where Member = @Recipient
GO

TheinstruTara wrote:

But how do write the sql if I want both the 1st row and the 3rd row. They both differ in only the Param name.

TheinstruTara wrote:

I have to calculate the difference between the amounts in the 1st row and that in the 3rd row.

TheinstruTara wrote:

I understand what a primary key is, but my database does not require it, or so I think!!

SELECT * FROM Tab1 WHERE param='AS' AND param='BJ' AND cat='x1' AND payee='y1'

TheinstruTara wrote:

WHERE param='AS' AND param='BJ'

SELECT * FROM Tab1 WHERE param IN('AS', 'BJ') AND cat='x1' AND payee='y1'

(param = 'AS' OR param = 'BJ')

TheinstruTara wrote:

In my program I do not know which row it actually is

Frank Kerrigan wrote:

This should not be posted in the SQL forum !