How to exclude a value range from loading in script

[omyahamburg]

Hello everybody

In my script I load one field with a range of values:

e.g.

Field 1

1398005

1400001

1400002

1400003

1400004

1400004/01

1400005

1400006

1400007

1400008

1400009

1400010

1401009/1

1401009

1474385

2453474

2773319

8447565

9354793

9703607

How can I set in the script, that values 1400001-1401009 will be excluded, but 1400004/01 + 1401009/1 will be loaded together with all other values ?

Thanks for your help.

[#2]

Hi,

Just write sql statement in the script It works

example:

SQL SELECT NAme,Roll

FROM Supriya.dbo.Customer WHERE Roll NOT BETWEEN 9 AND 99 ;

Thanks,

Supriya

[deepakk]

hi,

You can try out the method used in the application.

There might be easier ways but at the moment I can think only  of this

Deepak

[omyahamburg]

Hi,

thank you, in my script WHERE [Field 1] NOT BETWEEN... does not work.

[Table2]:

load [Field 1]

Resident Table1;

DROP Table1;

[omyahamburg]

Hi Deepak

That looks great, thanks a lot, I will try it.

Joerg

[#6]

Hi,

Try using

[Field 1]< 1400001 AND [Field 1]> 1400009

Hope this helps.

BR, Neha