QVD Load

[Anonymous]

Hi guys,

I used SQL script with condition from temporary table

  TempTable:

     Load

       Chr(39) & Concat(Distinct SessionId,Chr(39) & ',' & Chr(39)) &Chr(39) as ConcatValue

     Resident

           COMMENT_URLs;   

     Let vValue2=FieldValue('ConcatValue',1);

     Drop Table TempTable; 

  SESSIONS:

LOAD AutoNumber(Id) as Auto_Id,*;

SQL SELECT Id, [SessionId]

      ,[TimeStamp]

       ,[Ip]

      ,[Url]

  FROM [SEAC].[dbo].[UserTrack] where SessionId in ($(vValue2))

  ORDER BY SessionId, [TimeStamp] ASC;

Now I have qvd file SESSIONS FINAL with all records. I want to add autonumber for my qvd file for each SessionId

QVD:

LOAD AutoNumber(Id) as Auto_Id,*

FROM

(qvd)

  ORDER BY SessionId, [TimeStamp] ASC;

Please help me with idea.

Thanks,

[swuehl]

Here are some ideas to circumvent the limitations of autonumber in incremental load (if that's what you are interested in):

Autonumber Handling for QVD Optimized Load (via Key Storage)

[Anonymous]

Thanks for reply.

I used order by and it works.

The problem was in concant sql file and qvd file.