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

sessionKey locationKey sessionStart sessionEnd instructorKey Flag carKey productTypeKey

164192 NULL 2015-07-01 06:00:00.000 2015-07-01 08:00:00.000 36754 NULL 133 2

164196 34 2015-07-01 09:45:00.000 2015-07-01 11:45:00.000 13783 NULL 133 2

164195 34 2015-07-01 11:45:00.000 2015-07-01 13:45:00.000 13783 NULL 133 2

164085 13 2015-07-01 14:00:00.000 2015-07-01 16:00:00.000 39097 NULL 133 2

164096 13 2015-07-01 16:15:00.000 2015-07-01 18:15:00.000 39097 NULL 133 2

164133 13 2015-07-01 18:15:00.000 2015-07-01 20:15:00.000 39097 NULL 133 2

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