Sorry I havent time to think through your problem in detail but below is a proc that will split out the various values in a field if you specify the delimiter.
Hope it is of some help.
CREATE PROCEDURE Split(@string varchar(2000),@delimiter varchar(10))
as
DECLARE @str varchar(2000)
SET @str...
Help!
One of my colleagues has created a web page with a button called Eddiebutton.swf. When clicked it should open up a page called name.htm but when he clicks on it the address changes from c:\eddie\web\name.htm to c:\eddie\web\Eddiebutton.swf\name.htm and obviously cannot find the page!
Any...
Sorry, I forgot to mention that i need to be able to send a report based on this table to the many companies that are selected. Preferably in a HTML document.
I am in the middle of creating a new CRM database in MSAccess2000. I have created a selection form with various combo boxes, radio buttons etc. This creates a table with the list of accounts that i need. The table is called TBL_MAILSHOT and the email address field is called E_MAIL_ADDRESS. Any...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.