QVD Where condition for between values

[rxp03570]

Hi,

I'm trying load a qvd, but I want to limit the accounts to only pick account between 1 and 100, Can some one help me with the correct logic.

For Eg:

Load * from

C:\Users\draab\Documents\Data_Trans.qvd]

(qvd) Where AccountID ?????.

Thanks,

Rahul

[Anonymous · Accepted solution]

WHERE AccountID >= 1 and AccountID <= 100

[rajivmeher]

Hi Ruan

Shouldn't it be WHERE AccountID >= 1 and AccountID < 101

Otherwise the boundary values 1 and 100 will be excluded?

Regards

Rajiv.

[Anonymous]

Thanks Rajiv, missed that ! I have edited the post so he can easily copy.

Much appreciated.