Search results for query: *

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...

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...

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...

I get this error: Login failed for user 'X4355-2000\ASPNET' I am using C# and the graphical sqlDataAdapter with the DataSet. Now I am accessing a SQL2000 DB. Does this mean that I have to create a .NET account for the DB now? Thanks Exams Passed: 70-152, 70-175, 70-176, 70-100

OK, I am NOT on our production server, thank God! BUT... Our transaction log was full today so I did some research on M$ and they instructed me to backup the logfile and then to delete the ldf file. Well this wacked the sql2000 db. So, I recreated the DB and tried restoring from the...

I need each param parsed out of this string. I am having trouble parsing if the vars vary in length. Data: ec=TTT&oc=CRM&tot=501&UID=88997 (SELECT ID, IP, TID, TheUserDetails.UserID as UserID, --Parsing Querystring, SUBSTRING(Querystring, CHARINDEX('ec=',Querystring) + 3, CHARINDEX('&'...

Here is the link. http://www.microsoft.com/windows2000/downloads/tools/logparser/default.asp How in the world do you use it? I know how to register the dll etc.. But to execute the queries and such from VB? Thanks Exams Passed: 70-152, 70-175, 70-176, 70-100

We have 500 Meg logfiles that need to be parsed but the CRAPPY thing about it is that I first have to eliminate these unnecessary empty spaces at the end of the files for our SQL DTS to work correctly. What would you suggest? Thanks Exams Passed: 70-152, 70-175, 70-176, 70-100

I know how to use the FSObject pretty good but here is the scenario. I have 10 different folders each containing ONE file with the SAME name. I need to copy these 10 files to ONE folder but of course you can't because the FSObject will overwrite the files leaving only one. How can I get...

I have a server and I want the SQL2000 DB to be accessed over the Internet through a simple ADO connection string. How do I start this? Thanks... Exams Passed: 70-152, 70-175, 70-176, 70-100

This is a sample of some data that is a result of a SELECT that calculates the total number of sites that referred traffic to our websites. What I would like to do is store these results in another table so that my boss can simply SELECT that results table and get the report. Is this good...

Before I update I want to test whether certain conditions are true but I get the following error. Why? Thanks Server: Msg 170, Level 15, State 1, Line 5 Line 5: Incorrect syntax near '>'. Server: Msg 156, Level 15, State 1, Line 20 Incorrect syntax near the keyword 'as'. UPDATE W SET...

Take a look at this pic and this is what I am trying to do. The code I have so far is below it. Code: UPDATE W SET PageRequested = PageRequested + '?tid=' + CONVERT(varchar(250), LEFT(NEWID(), 7)) FROM WebLog W INNER JOIN (SELECT IP, (ID), SUBSTRING(PageRequested, CHARINDEX('?tid='...

Here is the data that needs to be transformed. Take a look at IP 10.10.2.191. The code I already have adds the tid with the GUID that you see there. What I also need the code to do is seek out that last record 'crmresourcesthankyou.asp' and assign the SAME tid=52FC441. See what I mean? CODE...