Hi Dwain,

I don't think your query would work if I change the data a little.

Try your query with this new data:

Insert Into ES_SubModuleMaster

Select 1,1,'Academic',2013-01-01 00:00:00.0002013-01-04 00:00:00.000Start0

Union ALL

Select 2,1,'Administration',2013-01-04 00:00:00.0002013-01-07 00:00:00.000Start0

Union ALL

Select 3,1,'Information',2013-01-07 00:00:00.0002013-01-08 00:00:00.000Start0

Union ALL

Select 4,1,'Personal Information',2013-01-10 00:00:00.0002013-01-12 00:00:00.000Start0

Union ALL

Select 5,1,'School Setup',2013-01-13 00:00:00.0002013-01-15 00:00:00.000Start0

Union ALL

Select 6,1,'Sign Out',2013-01-16 00:00:00.0002013-01-17 00:00:00.000Start0

Union ALL

Select 7,1,'Welcome Page',2013-01-18 00:00:00.0002013-01-21 00:00:00.000Start0

Union ALL

Select 8,1,'Content Management',2013-01-01 00:00:00.0002013-01-03 00:00:00.000Start1

Union ALL

Select 9,1,'Content',2013-01-01 00:00:00.0002013-01-03 00:00:00.000Start8

Union ALL

Select 11,1,'Shared File List',2013-01-08 00:00:00.0002013-01-14 00:00:00.000Start8

Union ALL

Select 12,1,'Shared File List For Faculty',2013-01-01 00:00:00.0002013-01-07 00:00:00.000Start8

Union ALL

Select 13,1,'Alumni List',2013-01-01 00:00:00.0002013-01-05 00:00:00.000Start2

Union ALL

Select 15,1,'Content Management For Parent',2013-01-01 00:00:00.0002013-01-13 00:00:00.000Start1

Union ALL

Select 16,1,'InContent',2013-01-15 00:00:00.0002013-01-17 00:00:00.000Start9

Any other options??....I'm still stuck with the Ordering :crying: