9 Replies Latest reply: Jun 16, 2016 10:00 AM by shay raber RSS

    load from select return different results

    shay raber

      hi,

       

      I'm working on a script which I didn't wrote.

      the script part that saves data tend, lately, to return only few records from time to time (original source does not change)

      the script is written in a way I'm not used to and i don't know if it might be the reason.

      this is the script:


      SQL SELECT * FROM system.dbo.MITX_USER_PROJ;
      STORE MITX_USER_PROJ into $(Path_Full_QVD)\MITX_USER_PROJ (qvd);  DROP Table MITX_USER_PROJ;

      instead of writing it:

      MITX_USER_PROJ:
      SQL SELECT * FROM system.dbo.MITX_USER_PROJ;
      STORE * From MITX_USER_PROJ into $(Path_Full_QVD)\MITX_USER_PROJ.qvd (qvd);  DROP Table MITX_USER_PROJ;

      (sometimes, instead of ~300Kb the result returns as a ~70Kb file)

      can someone please assist?

      happened to someone?

      does the script change will help (not familiar with that file type)?