Search results for query: *

I have a column of data, which looks like the following: 2143-2352-234 2143-D325-4 SC3-TLC-178 2412-2341C-382 Basically what I’m trying to accomplish is split this string up into three separate fields and separate them by the ‘-‘. Here is a sample of the code I’m trying to run to attempt this...

Well re-installed it and still having the problem. Let me clarify a few things. I have two working exports of fixed width data working in the DTS package. My problem is with ONE table and only one table. Every other table I try works fine, except that one table.

I'm working on a DTS package trying to export data from one of the tables to a text file. This is normaly a simple mundane task which requires no effort to accomplish, however something has gone wrong with a particular table. In my database I can export any table to a text file but this one...

What if I need to include it if the first number would be in my range I'm looking for??? Say it's 30E38. I would need to include it, not exclude it. Only reason I'm excluding it right now is because it's 98E35. The 90000 and up is out of my range.

Ok I fixed my repeating data problem. I needed to include one more category in my account_code, and in my comparison in order for it to become even more unique. However I still can't seem to filter out anything that has alphanumeric values.. Maybe it's a problem how I have my table setup...

That didn't seem to work. Sorry if I didn't explain it better. I'll play with it and see if I can get it to work. For now I just created a simple query to drop that one record. I'm having a different problem however. I have further complicated the code and I am getting unexpected results...

I'm trying to actually exclude that entirely. I don't need 9XXXXXXXX anything. However based on how the data formated and I'm doing my comparison it's bailing out. I need objects from 30000-39999, 50000-69999, 80000-89999. However there is one object that has the value of '98E35'. How can I...

I have one field that has all numbers in it, but one record contains alphanumeric. For example I'm filtering out all of the records based on numbers: Where ((object is between 30000 and 50000) ... I have one file that is valid and it's 98E35. This causes problems when I'm trying to filter it...

It seems to be almost hit and miss. Any ideas?

well it seemed to fix itself :-\. I ran it again and it worked fine. However I have noticed a new problem. Here is what I'm doing. If there is a better way please help me. Basically I'm importing from two files, running a query on that information and inserting that query into another table...

I'm trying to import from a text file directly into the database. I'm useing a transform data task to do this task, however it's not working correctly. When that portion of the dts package runs, it imports the data into the database but does it 7 times. Is there any way to get it to import it...

Ok I'm trying to do a simple function in SQL. I have the following: (in microsoft access) Select fund & '-' & department & '-' & object From accounts It produces xxxx-xxxxxx-xxxx How do I do the same thing in SQL for SQL Server 2000???

Sorry if I'm a big ignorant to what your talking about. What is a DTS package, and how do I create one? Is there a site someone could refer me to for some additional help?

How do I do that? I'm kinda new to Microsoft SQL

Is there a way to automate import and export of data? Every night I need to export a few queries. I will have to upload them to another database. Is there a way I can have SQL kick out the txt file? I'm also having to do a daily import of account balances. Is there a way for SQL to do an...

I have run into the same problem. The factory installs are completely ignorant. I haven't had the time to re-build my machines yet, so I simply moved the /opt directory into my /export/spare directory. I then created a symbolic link to it and things work simply fine.

Hmm.. I have never even tried this. When I get the chance I will. We run WebSecurity. It replaced I-Gear.

That worked ;-) Thanks!!!

What type of problems are you having with it?

I have two databases, A and B. I'm trying to do a select from database A table a1 and insert that into database B table b1. What do I need to do to make this happen? Is it possible?