See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.
ALTER PROCEDURE IMINVLOC_SQL_Paged @Where varchar(2000) = NULL, @OrderBy varchar(2000) = NULL, @PageIndex int, @PageSize int AS BEGIN DECLARE @SQL nvarchar(2000) DECLARE @Count int SELECT @Count = (SELECT COUNT(*) FROM IMINVLOC_SQL) DECLARE @StartRowIndex int SET @StartRowIndex = (@PageIndex * @PageSize) + 1; WITH Results AS ( SELECT ROW_NUMBER() OVER (ORDER BY Item_No ASC) AS Row, Item_No, Item_Filler, Std_Cost FROM IMINVLOC_SQL ) SELECT Item_No, Item_Filler, Std_Cost, @Count As TotalRecords FROM Results WHERE Row BETWEEN @StartRowIndex AND @StartRowIndex + @PageSize - 1 END
|How to count the amount of days from a date in the past||2||37|
|Need help with a query||3||40|
|MS SQL 2005 Srink database in chunks||4||40|
|Order by but want it in specific order||2||21|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!