tag:blogger.com,1999:blog-11096258.post1878603767772168027..comments2023-08-25T15:26:49.281+02:00Comments on InfoWorker Solutions: Using Dynamic Stored Procedures in BCS FindersKjell-Sverre Jerijærvihttp://www.blogger.com/profile/13654217591841196465noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-11096258.post-37310054642481604362014-11-20T00:15:20.241+01:002014-11-20T00:15:20.241+01:00This saved me! You are a life saver!This saved me! You are a life saver!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11096258.post-78632722565107511432013-07-16T13:12:20.841+02:002013-07-16T13:12:20.841+02:00This saved more time for us. Thank much on-behalf ...This saved more time for us. Thank much on-behalf of my entire team.Ramkumar Krishnanhttps://www.blogger.com/profile/07593862251269402877noreply@blogger.comtag:blogger.com,1999:blog-11096258.post-85328661881983079982012-05-17T17:00:40.302+02:002012-05-17T17:00:40.302+02:00You can use #temp table on stored procedure.
Some ...You can use #temp table on stored procedure.<br />Some times when we user Substring, CharIndex Sharepoint designer will not allow you to create any operations.<br />Create a dummy stored procedure with all columns in the original stored procedure and create operations.<br />Once operatinos are done and save BDC then export BDC and change stored procedure name with the real stored procedure.<br />or you can convert dummy stored procedure as the original.<br />It will work.<br /><br />Please let me know if you have any questions.<br />Thanks<br />BensonJoseph, Benhttps://www.blogger.com/profile/08070202110855174955noreply@blogger.com