Viewing 15 posts - 16 through 30 (of 31 total)
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...
September 28, 2011 at 2:21 pm
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...
September 28, 2011 at 2:15 pm
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...
September 28, 2011 at 2:02 pm
@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...
September 28, 2011 at 1:45 pm
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...
September 28, 2011 at 1:41 pm
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...
October 7, 2010 at 12:14 pm
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...
October 7, 2010 at 11:11 am
Yes DTS. My apologies for the typo.
October 7, 2010 at 9:48 am
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
)...
September 30, 2010 at 1:11 pm
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...
September 29, 2010 at 6:13 pm
Great. Thank you very much for the help!
May 27, 2010 at 12:48 pm
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...
May 26, 2010 at 2:32 pm
Thank you very much for your help! I will study your code and try to execute it on my end. 🙂
May 18, 2010 at 2:50 pm
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...
May 14, 2010 at 3:38 pm
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...
May 14, 2010 at 2:53 pm
Viewing 15 posts - 16 through 30 (of 31 total)