find a way to select from SPROC, using OPENROWSET SELECT * FROM OPENROWSET(SQLOLEDB', 'Trusted_Connection=Yes;Server=(local);Database=myDB', 'exec SPROC_NAME ''Param_1'', ''Param_1''') or SELECT * FROM OPENROWSET(SQLOLEDB', 'Trusted_Connection=No;Server=(local);Database=myDB;uid=user_id;pwd=password', 'exec SPROC_NAME ''Param_1'', ''Param_1''') PS: change the server and database, sproc_name, uid, pwd to your need until then
this is my personal web blog..anything that i do each day hopefully can get in this blog since i only able to write it if i have spare time at the office..(ky g kerja aj ya hahaa)