Here is the implemented example using PIVOT..

/*Script to create Sample Data*/

DECLARE @PercentData

TABLE(Name VARCHAR(50),Department VARCHAR(10), Percentage float)

INSERT INTO @PercentData(Name,department,Percentage)

SELECT 'Gustav','GW',80 UNION ALL

SELECT 'Gustav','NW',20 UNION ALL

SELECT 'Olaf','D',100 UNION ALL

SELECT 'Detlev','NW',50 UNION...

Dave Ballantyne (8/20/2009)

But WHICH exit row for WHICH entry row ?

Presumably 'Bob' will...

Just visit the link below to go thru quick tutorial on sql outer joins

http://www.quackit.com/sql/tutorial/sql_outer_join.cfm

In that case, you may use full outer join as follows:

select

ISNULL(entryt.EmpName,exitt.EmpName) EmpName,

ISNULL(entryt.EntryDateTime,exitt.EntryDateTime) EntryDateTime,

exitt.ExitDateTime

from

dbo.EntryTable entryt

...

If I'm not wrong sample data may be like this...

create table NodeItem

(NodeID int, ParentNodeID int)

go

insert into NodeItem

select 1 NodeID, null ParentNodeID union all

select 11 , 1111 union all

select...

Ok 🙂 Try out this..

SELECT [ScheduleID],ScheduleName

FROM [Schedule]

ORDER BY CAST(CASE

WHEN ScheduleName LIKE '%[0-9][0-9][0-9][0-9][0-9][0-9][0-9]' THEN RIGHT(ScheduleName ,7)

WHEN ScheduleName LIKE '%[0-9][0-9][0-9][0-9][0-9][0-9]' THEN RIGHT(ScheduleName ,6)

WHEN ScheduleName LIKE '%[0-9][0-9][0-9][0-9][0-9]' THEN RIGHT(ScheduleName ,5)

WHEN...

Hope you're looking for this...

SELECT {ColumnName}

FROM {TableName}

WHERE {ColumnName} LIKE 'Schedule%'

ORDER BY CAST(REPLACE({ColumnName},'Schedule','') AS INT)