Search results for query: *

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

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

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

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

Hello, I have an application that I built that I am having a most difficult time with. The application is an employee number generation app designed to generate employee numbers for three companies. The front end is Visual Basuc 6 and the back end is MS-SQL. I store employee information in...