Recent content by Jesus4u

Please tell me if you think this is a good idea. I am storing recurring orders in table A. However when the recurring orders are processed on a weekly basis I want to store the processed date in table B so that I can track all the processed dates for each recurring order. Is this a good way to...

yes I realize that. :) I have to abandon this idea now due to work time constraints. Thanks anyway.... Exams Passed: 70-152, 70-175, 70-176, 70-100

This is a stressfull problem. Scenario: Win2K Server with SQL2000 server on same box. I get an error that says: The code below is using linked server to SELECT from an Access 2003 database. SELECT null as StoryID, TITLE as Headline, AIRDATE AS pubDate, [DESC] AS [Intro]...

Please help. This is my code. It brings back nothing. But if I hard code the date as '03/28/2004' it works! declare @sBeginSunday smalldatetime set @sBeginSunday = GetDate()-@@DateFirst+1 print @sBeginSunday SELECT * FROM CRM_MDB...broadcasts WHERE cast(AirDate as smalldatetime) =...

I am finished with my project and all I need is to figure out this error so please help. We have 2 servers. One webserver with sql2000 at a remote location accessed thru VPN and another on the local network with same configuration. On the local machine I scheduled a package to upload TableA to...

yes Exams Passed: 70-152, 70-175, 70-176, 70-100

THIS IS MY HEADER This is the content that I want to extract excluding the header above. THIS IS MY SECOND HEADER This is more content that I want to extract excluding the second header above. Thanks... Exams Passed: 70-152, 70-175, 70-176, 70-100

yes in Word. Exams Passed: 70-152, 70-175, 70-176, 70-100

How can I find all occurences of a string formatted like WE SLATE in bold font and then extract all the sentences beneath WE SLATE and then repeat the process looking for the same pattern again? Thanks and help... :o Exams Passed: 70-152, 70-175, 70-176, 70-100

I am trying to get the ClassName of the Opera browser and then read the url from the address bar but I can't seem to get the name of the address bar. What is it? I am using Spy++ and no luck. Other browsers' address bars are typically called "Edit" but not in Opera. Declare Function...

I already have a view in SQL2000. How can I use that query to return and display in Crystal? Any basics out there for me? Thanks Exams Passed: 70-152, 70-175, 70-176, 70-100

I already have a view in SQL2000. How can I use that query to return and display in Crystal? Any basics out there for me? Thanks Exams Passed: 70-152, 70-175, 70-176, 70-100

I had to reinstall IIS because out of nowhere I was getting a Server Application Error on my local Win2000 Prof box when trying to connect to a SQL2000 database in the webbrowser using ASP. Now the previous error is gone but now the SQL permissions do not allow the IUSR account to access the...

yes got it thanks Exams Passed: 70-152, 70-175, 70-176, 70-100

But I don't see the user 'X4355-2000\ASPNET' in the NT list at all... Exams Passed: 70-152, 70-175, 70-176, 70-100