Sybase 11 - Array Emulation or Replace character in deliminated string
I am pulling my hair out trying to produce a efficient solution to a problem
I need to generate a SQL 'IN' statement on the fly in a stored procedure,
I wanted to pass an array into the procedure to generate the IN statement
but I don't believe this can be done. So instead I need to pass in some deliminated
text, which cannot be comma deliminated! So please could some one suggest
how I should replace my deliminator in SQL with a new deliminator so I can
assign this to a new variable to be held in the IN statement!
I would appreciate any suggestions anybody has!
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL