Comments for Growing up is optional

Comment on Thoughts on the New Zealand Skate Market by Nasty New Zealand Longboard Skateboard Market : Longboard, Long board, Longboard Reviews, Longboard Skateboard - Skurfboards.com

Wed, 09 Jan 2008 07:01:14 +0000

[...] Lindsay a local longboarder and previous skurfboards contest winner wrote a great article about the New Zealand skateboard market .This is a topic that is on the minds of most kiwi longboarders. New Zealand has most likely got [...]

Comment on Paging results in MS SQL Server by frosty_yul

frosty_yul — Thu, 31 May 2007 14:28:07 +0000

wish you could edit previous posts..

anyway, forget the word “dynamic”, just need to sort by a field in the inner table. any ideas?

Comment on Paging results in MS SQL Server by frosty_yul

frosty_yul — Fri, 25 May 2007 20:24:16 +0000

this paging script is great, until you would like to dynamically sort by a field in the inner table.

does anyone have a script that can handle this?

Comment on Paging results in MS SQL Server by broicher

broicher — Tue, 08 May 2007 09:50:39 +0000

this editor s…. you can reach me here if you have questions http://www.digital-ecom.de cu folks

Comment on Paging results in MS SQL Server by broicher

broicher — Tue, 08 May 2007 09:48:28 +0000

ok, second part:
WHERE Row>=1 AND Row=100 AND Row

Comment on Paging results in MS SQL Server by broicher

broicher — Mon, 07 May 2007 18:45:30 +0000

Hi folks,
if you use SQL 205 there is a much easier and faster solution. If you have more than 100.000 records, this here is a few seconds faster than the other solutions. In fact its pretty the same what mySQL does in the background, but its faster.

SELECT *
FROM (SELECT ROW_NUMBER()
OVER (ORDER BY Your_Data_ID DESC)
AS Row, *
FROM Your_Data)
AS WithRowNumbers
WHERE Row >= 1 AND Row

Comment on Paging results in MS SQL Server by tubesteako

tubesteako — Mon, 16 Apr 2007 16:06:16 +0000

Again, html encoded…

$x = number of rows per page
$y = x * page number

$count = $dbh->query(”SELECT count(*) FROM table WHERE conditions”);

if ($count < $y){
$x = $count % $x
}

Then plug $x, $y into the original formula:

SELECT * FROM (
SELECT TOP x * FROM (
SELECT TOP y fields
FROM table
WHERE conditions
ORDER BY table.field ASC) as foo
ORDER by field DESC) as bar
ORDER by field ASC

Comment on Paging results in MS SQL Server by tubesteako

tubesteako — Fri, 13 Apr 2007 22:10:01 +0000

Let me start by saying that Microsoft SQL Server 2000 is Satan’s gift to the world.

I’ve been using my programming language (php) to solve Foxhop’s problem (#10), without the use of stored procs or temp tables:

$x = number of rows per page
$y = x * page number

$count = “SELECT count(*) FROM table WHERE conditions”;

if ($count

Comment on Paging results in MS SQL Server by tuco

tuco — Sun, 28 Jan 2007 22:37:35 +0000

Oh, oh, it seems the system doesn’t allow me to paste all the code. Nevermind, a did a few improvement, reducing the “overhead” for the first select. If you want to take a look, I put a copy of this script at http://www.asteria.com.br/paging.txt

Cheers!

Comment on Paging results in MS SQL Server by tuco

tuco — Sun, 28 Jan 2007 22:22:41 +0000

Hi there!

This is the procedure I came over after the many samples. You simple have to pass a filter (this was in my case) plus the page number. Hope it helps!

ALTER PROCEDURE SP_CENARIO_LIST 1, 0

@ID_CENARIO tinyint,
@page int = 0,
@numrows int = 10

DECLARE @offset int

SET @offset = (@page * @numrows)

– Whole select
SELECT
IDENTITY(int, 1,1) AS RowNum,
CAST(CD_PERSONAGEM AS int) AS CD_PERSONAGEM,
DE_ARQUIVO,
DT_CADASTRO
INTO
#temp
FROM
T001_PERSONAGEM
WHERE
FL_OPCAO = @ID_CENARIO
AND
FL_ATIVO = 1
AND
FL_PUBLICAVEL = 1
ORDER BY
DT_CADASTRO ASC

– Paging
SELECT
*
FROM
#temp
WHERE
RowNum > @offset
AND
RowNum