Search results for query: *

That works perfectly! Thanks so much! Thanks! Jenn

Ah huh! I found out why. There are commas in there too. Rats! Now how do I handle that? Thanks! Jenn

Thanks for the help. Your code works just fine, but when I subsitute my field name for your variable I still get "Error converting data type varchar to float". select cast(cast (myField as float) as int) as myField from myTable. Why could it convert one way and not the other? Thanks! Jenn

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

Perfect! Thanks a lot! Thanks! Jenn

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

The "reuse windows" setting is checked on both our browsers and I dont' have the problem, so I don't think that's it. However, Ctrl + N works and that's good enough for her. Thank you both! Thanks! Jenn

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

Golom's post is EXACTLY what I needed. [thumbsup2] 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...

Thank you J. All I needed to do was run sp_addlinkedserver in the master database and then I was able to referenece the server like you suggested. Thanks! Jenn

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

Hey, that's perfect! Thanks a lot! 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...

I have the same error -2147217887(80040e21). I checked Microsoft's site and found the same article. My problem is I don't have a timestamp field. I am simply importing a text file into a table with all character fields. The DTS package runs fine by itself, but fails with the above error when...

After a bunch of unsuccessful queries, I got the results I wanted by writing this query: update mytable set owner = 'AssociateName' where myrec in (select top 40 myrec from mytable WHERE OWNER IS NULL order by myrec) Myrec is a unique identifer in mytable (which has a character value in this...

Thank you for your insight. In response to your last paragraph... Is it possible to do a query selecting the TOP 40 order by, lets say , DateEntered and then updating only those 40. Sort of like two queries in one? I'd rather not create a separate table just to get the sort. Thanks! Jenn