Recent content by Jenns

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