Database

WITH ordered AS(
    SELECT  RoadID,BEGIN,END,ROW_NUMBER() OVER(PARTITION BY RoadID ORDER BY BEGIN) as rn
    FROM    roads
    )
SELECT  o1.RoadID,o1.BEGIN,o1.END
FROM    ordered o1,ordered o2
WHERE   o1.RoadID = o2.RoadID
    AND o1.rn = o2.rn -1
    AND o1.END <> o2.BEGIN
UNION
SELECT  o2.RoadID,o2.BEGIN,o2.END
FROM    ordered o1,ordered o2
WHERE   o1.RoadID = o2.RoadID
    AND o1.rn = o2.rn -1
    AND o1.END <> o2.BEGIN

SELECT a.*, b.*
FROM	TableName a,
        TableName b
WHERE a.roadid = b.roadid
AND   b.start = (SELECT MIN(c.start)
                 FROM   TableName c
                 WHERE c.roadid = a.roadid
                 AND   c.Start  > a.start)
AND   a.End <> b.Start
ORDER BY ...

create procedure ptest as
begin
   raiserror( 'message', 10, 10 );
end;
go

sqlcmd -S .\instancename -E -d dbname -i testproc.txt

Msg 8152, Level 16, State 14, Line 11
String or binary data would be truncated.

gavindon wrote:

This report is embedded in an ASP.net app