<div>
Sorry Russ, I shopuld have posted my real table names since i dont know how to translate your example to my actual table:<br />
<br />
my table is called DTE_Inbox<br />
and the column with the numbers is named Folio and it's the 5th column from left to right
</div>


Sorry Russ, I shopuld have posted my real table names since i dont know how to translate your example to my actual table:

my table is called DTE_Inbox
and the column with the numbers is named Folio and it's the 5th column from left to right

<div>
Replace Sequence with DTE_Inbox.<br />
Replace NumericValue with Folio.
</div>


Replace Sequence with DTE_Inbox.
Replace NumericValue with Folio.

<div>
Thank you russ it worked perfectly.<br />
Thank you Sharath for the clarification
</div>


Thank you russ it worked perfectly.
Thank you Sharath for the clarification

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Can you help me with this query please (ms sql 2005):<br />
<br />
I have a table like this:<br />
<br />
NUMBER<br />
1<br />
2<br />
3<br />
5<br />
6<br />
8<br />
9<br />
10<br />
20<br />
21<br />
25<br />
28<br />
30<br />
31<br />
<br />
I want to get this:<br />
<br />
START &nbsp; &nbsp; &nbsp; END<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3<br />
5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6<br />
8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10<br />
20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21<br />
25 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25<br />
28 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;28<br />
30 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;31<br />
<br />
thanks.
</div>
</div>


Hello,

Can you help me with this query please (ms sql 2005):

I have a table like this:

NUMBER
1
2
3
5
6
8
9
10
20
21
25
28
30
31

I want to get this:

START       END
1           3
5           6
8           10
20          21
25          25
28          28
30          31

thanks.

Group by correlation

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.