Database

Declare @cnt int
Select @cnt = count(*) from table

UPDATE TABLE 
SET FIELD2 = @cnt
WHERE FIELD1 = @Parameter

CREATE PROCEDURE dbo.StoredProcedure1 
  @param1 int,
  @cnt int output
as
Select @cnt = count(*) from TABLE where column = @param1
RETURN 0
<pre>

So then when you call the stored procedure you will have to add two sqlparameters to your sqlcommand.  The @cnt needs to be marked as direction = output

After you call to executenonquery on the stored procedure you can then check the parameters and get the output value.  Then use this value when doing the insert or update.

You can't actually call a stored procedure in an insert statement.  
You can call a function, but there are other limitation with functions.

Hope that helps.
Ben

<br />
create procedure dpo.StoredProcedure1<br />
        @cnt int = 0<br />
        @AccountID int<br />
        @NewAccountID int<br />
        AS<br />
        SELECT @cnt = Count(*) FROM PlaceInReferralLine<br />
        //Used to make sure this Prodcedure has not already been done      <br />
        SELECT ReferredBy FROM UserAccounts WHERE AccountID = @NewAccountID<br />
        //Some IF statement so that if the value of the result is a null value, empty    <br />
        //string processing continues otherwise it would return "0"<br />
        <br />
        //Select the account that is in top postition<br />
        SELECT AccountID FROM PlaceInReferralLine WHERE PlaceInReferralLine = 1<br />
        <br />
        //Set the NewAccountID's referer to AccountID<br />
        UPDATE UserAccounts SET ReferredBy = @AccountID WHERE AccountID = @NewAccountID<br />
<br />
        //Add the new account to PlaceInReferralLine<br />
        INSERT INTO PlaceInReferralLine (AccountID, PlaceInReferralLine) VALUES (@NewAccountId , @cnt)<br />
        //Subtract 1 from all AccountID's PlaceInReferralLine                <br />
        UPDATE PlaceInReferralLine SET PlaceInReferralLine = PlaceInReferralLine - 1<br />
                <br />
        //Move the Referer back to the back of the line.<br />
        UPDATE PlaceInReferralLine SET PlaceInReferralLine = @cnt WHERE PlaceInReferralLine = @AccountID<br />
RETURN 1<br />

if (Select count(*) from table where column = @param) = 0
begin
end

 if (select isnull(column2,'') from table where column = @param) = ''
Begin

End

Declare @accountID int
select @accountid = accountid form table where col2 = 1

Developer611 wrote:

what is the problem?

Developer611 wrote:

But how can I do this in short time . Did you have any solutions ?

SalarSoft wrote:

I think transactions work with temporary tables that mean changes will apply to original tables after commit. This means that we can use original tables while a transaction is running!?!

SalarSoft wrote:

I have 5 or more queries that run in same time and one of queries take along time to done.