...it's me...eRiCk

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

almost 1 year from my last post? alot news from me :D i got married in sept 2007, got daughter by now ( < 2 months :D), still in my latest office (gonna find another one soon, hope i found it in time) my knowledge about SAP is better than the last, got my own project running (hope gonna be alot more so i don't have to work for someone again), learning NET .2008 now and Enterprise Library 4.0 (for .NET 2008 version) and gonna developt new application using .NET syntax only (maybe migrate to C# because it's faster) MCSD, try it for two times and it both fails for the same Subject :D, don't intrested in taking exam ever again.. what else???? hmmmmmmm, until then