tags:

views:

11

answers:

0
Q: 

Sybase SP result into Temp Table

HI, I have a SP which returning more than 100 fields with 1000+ row. I need to to save all in temp table and and rum my customize query to get the appropriate data.

I did many search but i am unable to find the right solutions for my project. I will appreciate if anyone can share his idea.

create table #SP_Result (i need to create field dynamically according to the SP return result )

exec Ministry..civil_record "2010-08-07","Autogen",20,NULL,NULL,NULL,NULL,NULL,NULL,NULL

I need dump the result from SP to #SP_Result.

related questions

Stop Zend_Db from quoting Sybase BIT datatype field values
Wrapper on conneting Sybase ASE using pyodbc in Django?
SybaseHelper class ?
.net connect to Sybase database,throw exception:Connection to Sybase server has been lost. All active transactions have been rolled back at
Can not connect to ASE-Sybase Using ADO.NET Data Provider
Sybase Ase 15 error on multiple recordsets and active transaction
Update on row for each group with max value in other column
Access sql that triggered the trigger from within trigger (Sybase)
SYBASE "net password encryption reqd" avalaibility
Finding server password encryption properties
Driver Problem in Sybase
Advantages of Sybase's AseClient for ADO.Net 2 over the ODBC driver
Query on Vertical partitioning in Sybase
sybase - fails to use index unless string is hard-coded
problem sybase autogenerated ids
Linq 2 Sybase ASE database? What are the options?
sybase - can not migrate database
Introspecting DEFAULT values and computed columns in Sybase ASE
How to INSERT INTO table DEFAULT VALUES in Sybase ASE
How to do a full outer join without having full outer join available.
Configuring SQL Anywhere to read from an ASE server
How Can I Populate 2TB data for sybase database?
unable to compile stored procedure in sybase ase11
Report on individual password expiration intervals in Sybase ASE 12.5
Find Sybase stored procedure in db given a text string that appears in the proc