Click here to Skip to main content
15,937,735 members
Home / Discussions / Database
   

Database

 
GeneralRe: select in star schema Pin
mrx10014-Apr-12 23:05
mrx10014-Apr-12 23:05 
GeneralRe: select in star schema Pin
Mycroft Holmes15-Apr-12 13:50
professionalMycroft Holmes15-Apr-12 13:50 
AnswerRe: select in star schema Pin
Bernhard Hiller15-Apr-12 22:00
Bernhard Hiller15-Apr-12 22:00 
Questionselect in star schema Pin
mrx10014-Apr-12 22:34
mrx10014-Apr-12 22:34 
QuestionCombobox in datagrid Pin
Member 828136613-Apr-12 6:19
Member 828136613-Apr-12 6:19 
AnswerRe: Combobox in datagrid Pin
Mycroft Holmes13-Apr-12 12:58
professionalMycroft Holmes13-Apr-12 12:58 
QuestionPaging in SQL Pin
Billa212-Apr-12 20:46
Billa212-Apr-12 20:46 
AnswerRe: Paging in SQL Pin
cjb11013-Apr-12 0:43
cjb11013-Apr-12 0:43 
You don't say which SQL system this is, but assuming SQL Server.

I'd start at the basic, and use BETWEEN somehow. i.e. one of your WHERE clauses in the proc needs to be similar to:
SQL
WHERE [IDColumn] BETWEEN @StartID AND @EndID

Obviously @StartID and @EndID would be passed in.
Assuming IDColumn is an sequential and consecutive field this will return a defined number of rows.

In SQLServer 2008 (maybe 2005), they introduced RowNum (like Oracle), which would be more consistent, and wouldn't rely on an sequential field in the table.

That's where I'd start at least.
GeneralRe: Paging in SQL Pin
Billa213-Apr-12 15:12
Billa213-Apr-12 15:12 
AnswerSQL Server script to find table dependencies Pin
jujiro12-Apr-12 8:36
jujiro12-Apr-12 8:36 
GeneralRe: SQL Server script to find table dependencies Pin
PIEBALDconsult12-Apr-12 8:57
mvePIEBALDconsult12-Apr-12 8:57 
GeneralRe: SQL Server script to find table dependencies Pin
jujiro12-Apr-12 9:06
jujiro12-Apr-12 9:06 
GeneralRe: SQL Server script to find table dependencies Pin
PIEBALDconsult12-Apr-12 9:08
mvePIEBALDconsult12-Apr-12 9:08 
GeneralRe: SQL Server script to find table dependencies Pin
Chris Meech13-Apr-12 2:46
Chris Meech13-Apr-12 2:46 
GeneralRe: SQL Server script to find table dependencies Pin
Eddy Vluggen12-Apr-12 9:03
professionalEddy Vluggen12-Apr-12 9:03 
GeneralRe: SQL Server script to find table dependencies Pin
Mycroft Holmes13-Apr-12 0:46
professionalMycroft Holmes13-Apr-12 0:46 
AnswerRe: SQL Server script to find table dependencies Pin
Eddy Vluggen13-Apr-12 1:30
professionalEddy Vluggen13-Apr-12 1:30 
GeneralRe: SQL Server script to find table dependencies Pin
Mycroft Holmes13-Apr-12 4:25
professionalMycroft Holmes13-Apr-12 4:25 
GeneralRe: SQL Server script to find table dependencies Pin
Mycroft Holmes13-Apr-12 0:49
professionalMycroft Holmes13-Apr-12 0:49 
GeneralRe: SQL Server script to find table dependencies Pin
jujiro13-Apr-12 2:01
jujiro13-Apr-12 2:01 
GeneralRe: SQL Server script to find table dependencies Pin
Mycroft Holmes13-Apr-12 4:22
professionalMycroft Holmes13-Apr-12 4:22 
GeneralRe: SQL Server script to find table dependencies Pin
jujiro13-Apr-12 4:55
jujiro13-Apr-12 4:55 
GeneralRe: SQL Server script to find table dependencies Pin
Mycroft Holmes13-Apr-12 12:54
professionalMycroft Holmes13-Apr-12 12:54 
Questioncan not get union recordset from two Sql Server2K store procedure Pin
Zhenjie Fu11-Apr-12 22:28
Zhenjie Fu11-Apr-12 22:28 
AnswerRe: can not get union recordset from two Sql Server2K store procedure Pin
Eddy Vluggen12-Apr-12 9:02
professionalEddy Vluggen12-Apr-12 9:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.