@SQLRNNR:

I see. Now that we know the script works fine and there is no need for the testing, would it be possible incorporate the script to work with only one...

@SQLRNNR:

This worked great. Thank you very much!

Question: why do I have to declare the TABLE, INSERT data, etc. Would it be possible to use only one SELECT statement and get...

@Cadavre:

Great solution as it covers all the possibilities in the product name field. However:

1) Is it possible to add this code in the following SQL statement so the new field...

@Phil:

Not all the records for the product name have the same exact length or format. However, all the availability dates have this exact format:

[Product Name Here] <span style="color:red;">Availability: 9/23/2011</span>

Thank you,

Phil...

@shatrughna:

Sure, I have tired using the SUBSTRING function but had no luck. I would like to sort the fields where I display the extracted dates from the product name field.

Thank...

Yes, I do. I used to have the VS 2005 and SQL 2005 on my machine; then I upgraded to 2008. I will try to locate the files and run...

I am creating new DTS packages from scratch. I downloaded SP2 from Microsoft and followed the wizard. The upgrade process went successfully. I am not really sure if the upgraded...

Yes DTS. My apologies for the typo.

Hello Lowell,

Thank for your help! I created a temp table called dbo.September and imported all the e-mail addresses. Here is the structure of the table:

CREATE TABLE [dbo].[September](

[nvarchar](50) NOT NULL

)...

Thank you Lowell. The e-mail addresses are residing in a different table called CRMContacts. I can easily join the CRMContact with Letter_C by using the ContactCode_C column. In fact, ContactCode...

Great. Thank you very much for the help!

Thanks for your reply Luke. No, I did not have any specific question. But, wanted to share my work with you to find out if there are ways I could...

Thank you very much for your help! I will study your code and try to execute it on my end. 🙂

I read the article couple times and I hope I got most of it done. If possible, please provide me with some instruction on how to get the rest of...

Once again, thank you very much for the reply Lutz. Here is the table structure as you requested:

Here is a sample result:

I was thinking of joining the CRMNote table with...