|
|
Posted by Erland Sommarskog on 05/03/06 00:50
rcamarda (robc390@hotmail.com) writes:
> My question is how can i use my data from a table and pass it to the
> SPGeocode via a select statement?
> The table I would use is:
>
> CREATE TABLE "dbo"."D_BI_Student"
> (
> "STUDENT_ADDRESS1" VARCHAR(50) NULL,
> "STUDENT_ADDRESS2" VARCHAR(50) NULL,
> "STUDENT_CITY" VARCHAR(50) NULL,
> "STUDENT_STATE" VARCHAR(10) NULL,
> "STUDENT_ZIP" VARCHAR(10) NULL
> )
> ;
> This is so new to me, I am not even sure what to search.
If you want to call that procedure for every student in the table, you
would have to set up a cursor over the table and call the proceduire
for each row.
Of course, if it's possible to rewrite that procedure to work on
the entire table directly that's better, but since you seems to be
calling an external API (from an SP???) this may be difficult.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|