Recent content by Kirbydog

Hello, I have been trying to parse an XML fragment into an SQL temp table so that I can use in my Crystal Report 10. I tried using OPENXML but cannot get the data to flow into the table. Here is an example of what I am trying to do... DECLARE @intDoc INT DECLARE @chvXMLDoc varchar(8000)...

Good Evening, Happy New Year! I have come across a problem using Crystal Reports 10, now hold onto your horses because my question is a SQL question but it may have an answer in Crystal. I am in a high production environment where I have built a report for use in Crystal Reports 10. The...

Thanks everyone for your help, I was able to resolve the date addition/subtraction issue by the following syntax: StatusDate = CONVERT(DATETIME,CONVERT(varchar(12),GETDATE())) - 6 Which put the date portion into an interger format which allowed for the subtraction, again thanks for your...

Yes, I tried the following, DATEDIFF(day,5,StatusDate) where day is the DATE, 5 is the number to subtract so that I get to a day that was five days ago and StatusDate is the field that I want to select all days that meet this criteria. In VB it can be done with no problem but in SQL 7 I created...

Good Morning, Well the query did not work for the date addition/subtraction portion of the where clause. For some reason SQL 7 cannot perform date addition or subtraction. I tried looking in the SQL on-line books but could not find anything on subtracting dates in a where clause and...

Will do, thanks... :-) James

Thanks Krickles, I applied your solutions this morning but I won't be able to tell you anything until tomorrow morning when I get in. I created the job to run at 12:00 AM, 1:00 AM and 2:00 AM PST so we will see what happens, lets keep our fingers crossed, (X) :-). James

Hello fellow programmers, I have a situation that I need help with, I have a VB front end and a MS-SQL back end. I need to automate an update query to run once every 24 hours in order to track some inventory items. A sample of my query is as follows: UPDATE Tools03 SET TransCode = 3, TransDesc...

Hello Folks, Success, my solution was to restore my suspect database to a new database and then I changed my applications to point to the new database with the data still intact. Whew, I will never ever delete a log file again... Thanks for all of the help. Happy 4th Of July, :-) Sincerely...

Thanks J, I tried the first solution set and it worked but we had the database setup for replication, now we can not get it out of replication so that we can detach and reattach it. Once we get the database removed from replication we believe that it will be ok? Any further suggestions? James

We have a SQL 7 server with a database that is live, several days ago we found that the 'LDF' file had grown beyond the capacity of our hard drive, 15GB and the hard drive is 17GB so we deleted the LDF file by mistake. Now we cannot get the database from the state of suspect because the errors...

Dear Fellow Programmers, Success, James Lean's helpful insight as to the number of columns that I was trying to return hit the nail on the head. I used the colum that has the employee ID numbers and filerted for the last name and excluded the temporary numbers. The only other problems was...

I corrected that problem, now I keep geting the same error with this version of the query: EHRS.Open "SELECT MAX(EIDNUM) AS MaxID, " _ & "empLName, " _ & "empComp FROM EmpHistory " _ & "WHERE (SELECT...

Dear SQLBill, Thanks for your info, however, I think there is a ghost in my machine, I can not get your sample to run, I keeop getting a syntac error at the end of the query... I tried to get as close as your example as I could: EHRS.Open "SELECT MAX(EIDNUM) AS MaxID, " _...

Hello fellow porgrammers, I have tried to resolve a problem in the VB forum that is giving me a really difficult time. The problem is a SQL query that uses a MAX function to retrieve a value in a table that holds employee numbers and other pertinent data that supports an application that I...