Hi All

I am writting an stored procedure to get the recently inserted records primary key as follows:


ALTER PROCEDURE [DBO].[AddEditUserMsgDetails]
(
@iJobID [INT]=NULL,
@iUserID...

Hi

I want to execute below query in ms-sql server 2000 but its giving errors.
Can anybody help please.

select * from ( select vRefTable from mainmenu where iMenuId=58 )
where (select...

Thanks buddy

I have a table with 3 columns as follows:

lower upper id
12 20 100
100 150 200


I want to select range of numbers based on lower and upper column.
For example I...