lmu92, interesting approach.

I need time to get into.

It's true, I'm using SQL server 2008, but we can make the sintax compatible with 2000 and (or) 2005.

🙂

--create table konta

IF EXISTS (SELECT * FROM sys.objects

WHERE object_id = OBJECT_ID(N'[dbo].[Konta]') AND type in (N'U'))

DROP TABLE [dbo].[Konta]

GO

CREATE TABLE [dbo].[Konta](

[SIFRA] [nvarchar](20) NULL,

[NAZIV] [nvarchar](60) NULL,

[KUDO] [nvarchar](1) NULL

) ON [PRIMARY]

GO

--create table...

OK.

I will give a try to explain and follow the article for code and example data, but here is 3 AM and my english is not so good. So...

It's for financial calculations here in Croatia.

Here we have something that is called Brutto Bilance.

It's something like hierarchicly presenting money on accounts.

1,12,1200,4,4100,.... this are accounts.

So 12 is part of 1,...

I have also 1 date field (we can call it Date1)

so, in results I need to have also 4 columns:

1. column = ID

2. column with values Date1 <= @DateFrom,...

I can't believe that you did it in so simple way!!!!!

This is brilliant.

Thank you SSChasing Mays

Can I make it a little complicated?

Regards, Davor Geci

I have played a little bid with this code.

Here are 2 methods, 1. method that search a record and 2. method that retrives a page.

1. method

-- big thanks goes...

Glad to help,

I have edited the post several times.

I have optimized it a little bit, so check if you have the last version.

Maybe Jacob wants to put this in...

Hello Franco,

I implemented the algorithm in my project and it works like a baby with 1.5 millions of records.

Thnx goes to Jacob.

In this code I'm using table called UFAGL and...

I'm new to this concepts,

how can I get the Rownumber of particular primary key to go to this page?

Regards Davor

Thnx Ten, for tip.

I have resolved the generation of the test data with INSERT INTO & cross join.

Davor

🙂

Thnx, guys for yours reply's

In that case, is there any chance to catch the sql sent by the application to the server, and then to process it to add dbo....

Thnx Jan for Your reply.

I'm heaving the same Idea, but I wanted to see if there is some another approach or how did others manage this problem.