Database

SELECT (T.ID - 1)  AS MissingID
FROM   tblMyTable AS T
WHERE  (T.ID - 1) NOT IN (SELECT ID FROM tblMyTable);

SELECT (T.ID - 1)  AS MissingID
FROM   tblMyTable AS T
WHERE  (T.ID - 1) NOT IN (SELECT ID FROM tblMyTable)
  AND  T.ID  > @startnum;

WHERE  (T.ID - 1) NOT IN (SELECT ID FROM tblMyTable ORDER BY ID)

SELECT Missing.ID FROM
 (SELECT (ID - 1) AS ID
  FROM   tblMyTable
  WHERE  ID  > @startnum
  ORDER BY ID) AS Missing
  LEFT JOIN 
 (SELECT ID
  FROM   tblMyTable
  ORDER BY ID) AS Includes ON Missing.ID = Includes.ID
WHERE Includes.ID IS NULL;

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?