Search results for query: *

Hi, I've got a varchar field that has decimal data in it. For example: 20.00, 120.00, 1120.00. I need to get the data to look like 20, 120, 1120 to link it up to ID numbers in another table. I tried converting the data to float, int and numberic, but each time it creates an error. Does...

I'm importing a text file into a table using a DTS package. The transformation is being done with VBscript. I need to change the script to convert (or cast) some fields as float. The text file brings them in as text and the database fields are float, thus the package fails. I have tried...

Hi everyone, I have a few batch files which copy files from a directory on one server to another server. There is a windows scheduled task which runs these files. The OS of the computer that task is running on has recently been upgraded to windows2000. Now when the batch files run we are...

Hello, I have multiple SQL tables which contain different types of comments for companies. I want to write a query which pulls them all together for a specific company so you can easily view all the comments for that company. However I just want to see all the comments in one field. So instead...

I wasn't sure which forum to go to with this one. An associate of mine is unable to open more than one internet explorer session. We assume it is a setting somewhere but can't find it. She is running IE 6.0 on Windows 2000. Does anyone have any ideas where the problem could be? Thanks! Jenn

To make my problem easier to understand I have used customers and transactions which I think everyone should be familiar with as opposed to my actual application. I have a web page that displays a report of let's say Customers and purchase dates. It has multiple customers with multiple...

I need to update data in a database on Server A with data in a database on Server B. How do I reference Server B in the query in my DTS package on Server A?. Server A is SQL2000, Sever B is SQL7 (if that makes a difference). Thanks! Jenn

Hi! Has anyone every had to import a text file into SQL Server that has more than one delimiter? I have a text file delimited with pipes and commas; however the import wizard only allows me one column delimiter. Can I get around this? Thanks! Jenn

I am having trouble trying to query data to return the most current date, per ID. There are multiple records per ID in the table. Data Example: ID Date 123 2/28/02 111 1/31/02 123 1/01/02 111 11/30/01 222 5/31/02 222 12/31/01 111 11/30/01 My...

Hi out there, I have a table with 600 records. I'd like to assign these records randomly to 15 different associates for work. What I need to do is select 40 random records and update the "Owner" column in my table with an associates name. I can't take the TOP 40 records because the...

Does anyone know the SQL equivalent of the FIRST and LAST aggregate functions from Access. We are using SQL 7.0 (if it makes a difference) Thanks! Jenn

How do I copy or export SQL Jobs and DTS packages from one server to another. We got another server to use for testing and development. I need to have everything on the old server copied to the new. I copied the tables, views and stored procs but need the jobs and DTS packages. I'm running...

I get the following error running a scheduled job using the SQL Server Agent. I'm trying to run a DTS which empties a table then copies a text file into it. If I run the DTS manually, it completes with no problem. Error is the error: DTSRun: Loading... DTSRun: Executing... DTSRun...

Hello, The secretary in my group creates a Powerpoint presentation monthly and sends it via email to everyone in our department. She has "normal" microsoft office sounds embeded into the presentations which we all can hear when we open the presentation in email. There is one sound...

Is it possible to create a view to update or insert data into a table? I get the SQL update statement to work but can't save it as a view. When trying to save I get an error that there is incorrect syntax near the keyword "update". Is there a special syntax for Update and Insert...

Hello out there! I am trying to install SQL Server7 on a PC. The PC had SQL 7 installed before, but had to be re-cloned. The message I receive on the install is: ODBC components on your system need to be updated but one or more files are in use or marked as read only. Close all applications...

Does anyone know how to export the results of a CFquery to an excel file? Is there a CFtag for it? Thanks, Jenn

I'm trying to write a query to update a field in a SQL.7 table with data in another table where the unique identifiers are equal. I tried doing this in Access and then checking the sql behind the query. The query works but the sql didn't work in SQL.7. example: UPDATE aos INNER JOIN goodsic...

I have a stored procedure that creates a temporary table from another temp table. Then I'm selecting records out of the table to view. (I'm displaying the data in a Cold Fusion application) Here's the code at the end of the SP. ----------------------------------------- Create table #temp4...