You can check the below mentioned articles by Paul White for more information on CROSS-APPLY
http://www.sqlservercentral.com/articles/APPLY/69953/
http://www.sqlservercentral.com/articles/APPLY/69954/

The below mentioned videos from YouTube by...

We would certainly need more detail like
1. DDL of the tables involved
2. Some sample data
3. Expected results based on the sample data to test the solutions

With no DDL and sample data to test, this is what I could come up with.

SELECT O.OrderID, O.CustomerID, O.CustomerVisitID, O.ItemID, O.ItemDesc, O.TransactionDate,
   F.OrderID AS NOrderId, F.CustomerID AS...

The link given below should give you some idea as well.
http://sqlhints.com/2015/07/10/how-to-get-difference-between-two-dates-in-years-months-and-days-in-sql-server/

Yes. It should, but...

You will need a FULL OUTER JOIN

DECLARE @Table1 TABLE (ID INT, Label VARCHAR(10), Value INT)

DECLARE @Table2 TABLE (ID INT, Label VARCHAR(10), Value INT)

INSERT @Table1

SELECT ...

You can also use the LEAD or LAG functions to access the next and previous row values respectively

You can do this without using REPLACE as well

UPDATE d

set d.[Description] = c.zipcode + ' - ' + d.Description

FROM [DocumentManagement].[dbo].[LesDescription] as d

inner join [DocumentManagement].[dbo].[LesCities] as c

on d.account = c.city

This should be of help..

DECLARE @FirstTable TABLE

(

ChildNode INT,

ParentNode INT

)

DECLARE @SecondTable TABLE

(

Node INT,

BSid VARCHAR(20)

)

INSERT @FirstTable( ChildNode, ParentNode )

SELECT...

les.61 (9/19/2016)

If I run the SET command I get an "incorrect Syntax near '=' " message.

I ran

Select (City + ' - ' + [Zip-Code] + '...