Voltar
  Cessação do contrato de trabalho  

Contrato de Trabalho

Contrato de Trabalho

Tome conhecimento das várias questões relacionadas com contrato de trabalho, desde formas de vínculo, tipos de contrato, suspensão e redução, mudança de local de trabalho e alteração da categoria profissional.



Dentro do tema Formas de Vínculo de Trabalho poderá informar-se sobre questões ligadas ao período experimental, carteira profissional e promessa de contrato de trabalho.
Poderá ainda alargar os seus conhecimentos consultando a página sobre a segurança social.
Saiba tudo sobre contratos de trabalho a termo e efectivo ou em part time.
Além disso, informe-se sobre as causas e consequências da suspensão e as obrigações dos trabalhadores durante este período e o de rescisão.
Saiba o que a entidade patronal pode fazer em termos de mudança de local de trabalho e ainda como proceder à alteração de categoria profissional.


    Voltar
  Cessação do contrato de trabalho  


Formas de vínculo do trabalho
[... ]

Tipos de contrato de trabalho
[... ]

Suspensão e redução do contrato de trabalho
[... ]

Mudança do local de trabalho
[... ]

Alteração de categoria profissional
[... ]

- As empresas podem exigir exames genéticos?
[... ]

- Negociar o contrato de trabalho
[... ]

Deixe o seu comentário


 
Publicidade
Siga-nos: Facebook Expresso Emprego Twitter Expresso Emprego Linkedin Expresso Emprego

Publicidade


Formação Em Destaque...   Formação
 

IT Production Support

Randstad Technologies - HR Solutions

Java Application Support Engineer

Randstad Technologies - HR Solutions

Pl/Sql & Oracle Forms Developer

Randstad Technologies - HR Solutions

Programador Microsoft .Net

Randstad Technologies - HR Solutions

Application Support Engineer

Randstad Technologies - HR Solutions

Programador Júnior .Net

Randstad Technologies - HR Solutions
 

Publicidade

©2015 | Expressoemprego | Todos os direitos reservados

Nome da Class Nº Utilizações
BOPageTree 36
  Data Hora Comando
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:48 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:49 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
  30-01-2015 12:12:49 SELECT PageTreeId,TAG,StartDate,EndDate,CancelDate,Title,Summary,Body,BodyHtml,Intro,IntroHtml,Keywords,Online,TopNavigation,NOrder,PageMenuTypeId,ParentPageTreeId,ShowPartilha,HPImageFileId,CreationDate,CreationUser,ChangedDate,ChangedUser FROM [PageTree] WHERE PageTreeId= @PageTreeId
FOPageTree 13
  Data Hora Comando
  30-01-2015 12:12:48 SELECT PageTreeId, TAG, StartDate, EndDate, CancelDate, Title, Summary, Body, BodyHtml, Intro, IntroHtml, Keywords, Online, TopNavigation, NOrder, PageMenuTypeId , ParentPageTreeId, ShowPartilha, HPImageFileId, CreationDate, CreationUser, ChangedDate, ChangedUser , (select top 1 Prev.PageTreeId From PageTree as Prev where Prev.online= 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder < PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder desc) as PrevPageTreeId , (select top 1 Prev.Title From PageTree as Prev where Prev.online= 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder < PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder desc) as PrevTitle , (select top 1 Prev.PageTreeId From PageTree as Prev where Prev.online = 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder > PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder) as [NextPageTreeId] , (select top 1 Prev.Title From PageTree as Prev where Prev.online = 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder > PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder) as [NextTitle] , (select Parent.Title From PageTree as Parent where Parent.PageTreeId=PageTree.ParentPageTreeId ) as [ParentTitle] FROM PageTree WHERE PageTreeId = 4154
  30-01-2015 12:12:48 SELECT PageTreeId, TAG, StartDate, EndDate, CancelDate, Title, Summary, Body, BodyHtml, Intro, IntroHtml, Keywords, Online, TopNavigation, NOrder, PageMenuTypeId, ParentPageTreeId, ShowPartilha, HPImageFileId, CreationDate, CreationUser, ChangedDate, ChangedUser , (select top 1 Prev.PageTreeId From PageTree as Prev where Prev.online= 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder < PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder desc) as PrevPageTreeId , (select top 1 Prev.Title From PageTree as Prev where Prev.online= 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder < PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder desc) as PrevTitle , (select top 1 Prev.PageTreeId From PageTree as Prev where Prev.online = 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder > PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder) as [NextPageTreeId] , (select top 1 Prev.Title From PageTree as Prev where Prev.online = 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder > PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder) as [NextTitle] , (select Parent.Title From PageTree as Parent where Parent.PageTreeId=PageTree.ParentPageTreeId ) as [ParentTitle] FROM PageTree WHERE ParentPageTreeId = 4154 AND Online=1 ORDER BY NOrder, PageTreeId
  30-01-2015 12:12:48 SELECT FileId FROM PageTreeFile WHERE PageTreeId = 4154 Order By NOrder
  30-01-2015 12:12:48 SELECT FileId FROM PageTreeFile WHERE PageTreeId = 3681 Order By NOrder
  30-01-2015 12:12:48 SELECT FileId FROM PageTreeFile WHERE PageTreeId = 3701 Order By NOrder
  30-01-2015 12:12:48 SELECT FileId FROM PageTreeFile WHERE PageTreeId = 3744 Order By NOrder
  30-01-2015 12:12:48 SELECT FileId FROM PageTreeFile WHERE PageTreeId = 3699 Order By NOrder
  30-01-2015 12:12:48 SELECT FileId FROM PageTreeFile WHERE PageTreeId = 3700 Order By NOrder
  30-01-2015 12:12:48 SELECT FileId FROM PageTreeFile WHERE PageTreeId = 4698 Order By NOrder
  30-01-2015 12:12:48 SELECT FileId FROM PageTreeFile WHERE PageTreeId = 4732 Order By NOrder
  30-01-2015 12:12:48 SELECT PageTreeId, TAG, StartDate, EndDate, CancelDate, Title, Summary, Body, BodyHtml, Intro, IntroHtml, Keywords, Online, TopNavigation, NOrder, PageMenuTypeId, ParentPageTreeId, ShowPartilha, HPImageFileId, CreationDate, CreationUser, ChangedDate, ChangedUser , (select top 1 Prev.PageTreeId From PageTree as Prev where Prev.online= 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder < PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder desc) as PrevPageTreeId , (select top 1 Prev.Title From PageTree as Prev where Prev.online= 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder < PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder desc) as PrevTitle , (select top 1 Prev.PageTreeId From PageTree as Prev where Prev.online = 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder > PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder) as [NextPageTreeId] , (select top 1 Prev.Title From PageTree as Prev where Prev.online = 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder > PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder) as [NextTitle] , (select Parent.Title From PageTree as Parent where Parent.PageTreeId=PageTree.ParentPageTreeId ) as [ParentTitle] FROM PageTree WHERE ParentPageTreeId = 4154 AND Online=1 ORDER BY NOrder, PageTreeId
  30-01-2015 12:12:49 SELECT PageTreeId, TAG, StartDate, EndDate, CancelDate, Title, Summary, Body, BodyHtml, Intro, IntroHtml, Keywords, Online, TopNavigation, NOrder, PageMenuTypeId , ParentPageTreeId, ShowPartilha, HPImageFileId, CreationDate, CreationUser, ChangedDate, ChangedUser , (select top 1 Prev.PageTreeId From PageTree as Prev where Prev.online= 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder < PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder desc) as PrevPageTreeId , (select top 1 Prev.Title From PageTree as Prev where Prev.online= 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder < PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder desc) as PrevTitle , (select top 1 Prev.PageTreeId From PageTree as Prev where Prev.online = 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder > PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder) as [NextPageTreeId] , (select top 1 Prev.Title From PageTree as Prev where Prev.online = 1 and Prev.ParentPageTreeId=PageTree.ParentPageTreeId and Prev.Norder > PageTree.Norder and Prev.PageTreeId <> PageTree.PageTreeId Order By Prev.Norder) as [NextTitle] , (select Parent.Title From PageTree as Parent where Parent.PageTreeId=PageTree.ParentPageTreeId ) as [ParentTitle] FROM PageTree WHERE PageTreeId = 4154
  30-01-2015 12:12:49 SELECT FileId FROM PageTreeFile WHERE PageTreeId = 4154 Order By NOrder