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

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

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

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

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

I have two tables, Table1 and Table2. Both tables have an account code of xxx-xxxxx-xxxx-xxxx. Every account code is unique. I'm trying to produce a query that will give me a resulting table of all records in Table1 except the records which have a matching account code in Table2. I can't...