Thank

Thank a lot

thank to everybody

Question is more general and used for any column.

It is not for me but for a my collegue...He said that he needs to use position but not column name or...

the first col is with identity:

select * from table WHERE $IDENTITY = '28'

but i get the error..

Any help? 

OK,

I have resolved the problem, I forgot to add OUTPUT after the OutPutParameters.

Thank

Thank to everybody,

I'll try your suggestion ...

thank

I have re-written the statement,

declare @OutputParameter varchar(100) ,

        @OutputParameter2 varchar(100) ,

        @StoreProc varchar(128) ,

        @StoreProcCall nvarchar(128) ,

        @rc int

select @StoreProcCall = 'exec @rError=' + @StoreProc + '...

Making some tests I have partially solved the problem with locking hints, now the performance get better.

thank

We have same opinion. I think this is a lock problem and memory, in fact when sql server hangs on a table; write/read on disk is null, it means that...

Thank to everybody for your useful suggestion.

I'll try

IF NOT EXISTS (select procedure entry here)

EXEC('CREATE PROCEDURE ....') ............................

thank

Thank... here another solution (for everybody) , but yours one is faster....

DECLARE @sd INT

SET @sd = 5400

SELECT [HH:MM:SS] = 

    CASE WHEN @sd/3600<10 THEN '0' ELSE '' END

   ...

I'm thinking that you are right.

thank a lot, I will investigate in this way...

Sorry,

the error is:

Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'domain\machine'.

the problem is that: I log on to windows as domain\user and log on to SQLserver with windows...

Write at the beginning and at the end of store proc: print getdate().