Search results for query: *

Im sorry. now Im really lost is how should I read them into an array and rename

Hi I have a problem where i have a folder with number of system generated .txt files that it names 00001.txt, 00002.txt etc currently on 05473.txt. Each file has the descriptor for the file content as the first 10 characters of the firstline of said file. I am trying to use SSIS to loop...

Thanks for your replies, when i am back in the office in the morning. I will try them out and feedback.

It is an Old syem that has become critical to the business and any major change to data structure has to be sanctioned the above method is the only way the data will be allowed to be stored as making the change will to the structure will take too much time to obtain the signatures.

Hi I'm either trying to over think this as I think it should be quite simple. I have 2 tables The first with an Action Table which is a list of records and date for each eg.(RecordNumber, PDate). The second table is a history table with the list of records and 6 date columns eg.(RecordNumber...

Thanks for the help yesterday, sadly I am on contract at a company that only have the following options available to them via the 'sql server 7.0' program menu: Books Online Client network Utility Enterprise Manager * Import and Export Data MSDTC Administrative Console Profiler Query Analyzer...

Thanks for your speedy reply. I was a liitle trigger happy when it came to the 2005 its actualy sql server 7. I cant find an object explorer in this one.

I am trying to get the entire DDL for my existing SQL Server 2005 database extracted into a .sql file is this possible? and if so is there a set SQL code to accomplish this? Thanks M

I do not get that option when setting up the connection. Do you mean when setting up the connection in the ODBC Aministrator or is this an option native to excel

I have an Excel sheet that has 85 tabs of data that I would like updating from an oracle database. I have set up database queries on each and tested them all and they all run correctly. My problem is once I have closed and come back to the workbook at a later date, when i refresh data I get the...

yes there will always be a title and an initial. yes i think that is what i am looking for.

I have a table that stores customer information, at present I do not store the customer title, initials and forenames as separate fields - they are stored as a single field, for example, “Mr”, “Mr & Mrs”, “Mr J” and “Mrs AD” are stored as a single field. I would like to split out this field into...

Thanks very much, thats exactly what i was after

Hi, i have completed a report in Access97 and the users have asked for the detail section of the report to be striped row by row alternating from a light grey to white. I have drawn a blank on how to acheive this. I know it is possible but just cant remember how. Any help would be greatly...

Hi, I have a problem accessing reports from the OnDemand Server. I can log into the website no problem, and browse through the folders containing all the documents we have on the ODS. However, when I try to access a document I get two messages: Brio Quickview - File Error Error Opening File -...

Is there a way of hard coding the order of colums in a pivot, depending the the value returned by the result set eg. if result = 1 then column order = 12345 else if result = 2 then column order = 54321

I have a table i need to query the table holds in formation for the last year my only needs to see the infor for the last full week, eg if today is Tuesday i would need the information for last week eg the previous Sunday to Saturday. do you have any ideas?

Hi Guys, I need to get data for the FullWeek before the LastFullWeek (last but one full week if you like) is there a way of doing this or does anyone have a formula i could use. I am using Crystal 8.5 on a Sybase Adaptive Server. Date is coming from a {Datetime} field. thanks in Advance Matt

I have just upgraded from Crystal 8.0 to 8.5. And when I try to open some of my older reports in I get the TLV error. The reports that I completed in V8.0 open correctly but other reports that were created in earlier versions don't open correctly. I have about 750 Reports only 140 of them as...

Thanks m99 + Malcolm, The Data in the field is actualy stored as a 12Character long string. eg: 1,001,214.00 This now means that the Month value is seperated by a ",". My current formula is as follows but it doesn't seem to work. An error message is displayed saying. 'The...