you can just use pseudo code

DECLARE @Results TABLE (

sessionKey int NOT NULL,

...

DECLARE @Results TABLE (

sessionKey int NOT NULL,

locationKey ...

you can just use this pseudo code

DECLARE @Results TABLE (

sessionKey int NOT NULL,

...

Here is the sample data

sessionKeylocationKeysessionStartsessionEndinstructorKeyFlagcarKeyproductTypeKey

164192NULL2015-07-01 06:00:00.0002015-07-01 08:00:00.00036754NULL1332

164196342015-07-01 09:45:00.0002015-07-01 11:45:00.00013783NULL1332

164195342015-07-01 11:45:00.0002015-07-01 13:45:00.00013783NULL1332

164085132015-07-01 14:00:00.0002015-07-01 16:00:00.00039097NULL1332

164096132015-07-01 16:15:00.0002015-07-01 18:15:00.00039097NULL1332

164133132015-07-01 18:15:00.0002015-07-01 20:15:00.00039097NULL1332

sql 2012

The whole Idea is. One session get cancelled i need to know if there are any contiguous sessions that associated with this sessions. The link is done on the start...

I just use outer apply but can be changed to CROSS APPLY.

The second outer apply is not the same as the first one. this condition is different

AND su2.sessionStart...

I have posted a sample data. The only thing I can not figure out how does the first record get in there.Because is not contiguous with any other sessions

If I run it through the query analizer I get the error saying that " ' " and " '' " columns does not exists, but if I do not...

The problem is already solved Thanks to everybody who participated in the discussion

if isNULL(intOrder)  Then

   intOrder="NULL"

  else

   intOrder=rs.Fields("intOrder").value

  end if

This will insert NULL into the table. I already tested this...

I can only think of 1 method . You need to create 2 connections 1 to your source and another to you destination. Try to dump data in temp tables...

MY solution is working Thanks everybody for your responses

the solution is following

if isNULL (intNavId) or isNULL(intSubID) or isNULL (intTAbid) or isNULL(intOrder) Then

intNavId="NULL"

...

I can not update the data. I have to copy the data as is. The only thing I can do is to change NULL value to 0

If you do not want to create a linked server You can write A ACtive X script with Dynamic properties where you going to include all you connection variabes