I need to retrieve data (i.e., price) from a service by passing a specific security identifier and date.
The servide is http://rplus.intdata.com/cgi/nph-rplus and requires an ID/password.
Can anyone help with the basic structure?
Is there a difference between the following?:
Store '' to m.variable
store '' to lcVariable
Is accessing either variable faster than the other?
p.s. There is no SCATTER command involved here.
Denny,
Thanks for your quick reply. I guess SQL Server ain't all that if it can't support arrays. Nevertheless, I have successfully used the SQL statement with the NOT IN list on a 3GB sql table. Other than placing values in another table, what about creating a method in a class?
After successfully establishing a SQL connection, rather than using the following:
Select * from sqltable where fieldname NOT IN ('v1',...,'v8')
I would prefer something like the following:
Select * from sqltable where ASCAN(gArray, fieldname) = 0
any suggestions?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.