Search results for query: *

Hello there, I can't figure it out how to get this result: I have a table with the following values: GROUP PRODUCT 1 A 1 B 2 A 2 A 3 B 3 C 4 A 4 C ... That is, x groups that with two products out of three available. The groups can have two products of the same or different kinds. I'm trying...

Hello everyone. I need to filter my query based upon the record date (RecordDate = day at the end of the month where the specific table was loaded). This recorddate can be different depending on the source file, so, for August 2005 I might have a file loaded on August 25th into one table, and...

Hello there, which algorithm could I use to encrypt the data in a column keeping the Key length? For example: Decrypted: ONETIME Encrypted: x95sf7w All encryption algorithms I have used (RC2,RC4, DES, 3 DES, AES) use a key lenght over 40. Cheers, Alfredo

Hello everyone, is it possible with SQL (select into) to generate a table with dynamic names? Example: Select COL01, COL02, COL03 INTO TABLE_"DATE" FROM TABLE01 where Table_"date" will be a table like TABLE_07112005, tomorrow it will be like TABLE_07122005, etc.. Cheers, Alfredo

Hello everyone, My mind doesn't want to work today.. I'm stuck with this: How can I fill up the blank spaces between two records with the value of the first one? That is, I have a table that looks like this (PRO_DESC & PRO_NAME are the column names): PRO_DESC PRO_NAME Request # Project 1 A B...

Hello everyone, is it there a way to select the numeric characters of a cell using just SQL? My records: Activity_Desc (55) COMUNICACIONES 03-SEGUROS ALIMENTOS Y BEBIDAS - 43 BIENES RAICES (68) CONSTRUCCION (14 ) CARTOGRAFIA My expected results 55 03 43 68 14 Tnxs!!! Alfredo

Hello there, thanks for the previous responses. Is it there an easy way to replace one character of a field by 0 (zero) using just SQL? For example: TXN_AMT 000024584862R 000000473929J 000000012929A 000005013141S to TXN_AMT 0000245848620 0000004739290 0000000129290 0000050131410 The length of...

Hello everyone, how can I select all the characters from a field after the second comma (or space)? I have: FULL_NAME ALFREDO JOSE PEREZ REVERTE and I would like to select everything after the second space, that is: PEREZ REVERTE. Cheers, Alfredo

Hello everyone and Happy 2005, Is it possible to record the usage of Excel, Powerpoint, Word, etc..., that is, for monitoring their use to be able to know when the applications are launched. Thanks and regards, alfredo

Hello everyone, I'm having this discussion with a fellow data modeler regarding the use of COUNT vs. SUM. I'm used to build the DAILY_TRANSACTIONS_FACT with a unique TXN_ID column whose values are just consecutive numbers. When calculating number of transactions, I just do COUNT(TXN_ID). My...

Hello everyone, this is my first posting to this group, sorry if it's been asked before, here is my question: is it possible and what would be the best way to do time series analysis TY / LY (this year last year calculations with BO Designer? As far as I've found right now, there could be two...

Hello there, How can I format a number into a string such as "V00000000000" For example: valor = 4736718 will return: V00004736718 valor = 82213944 will return: V00082213944 I guess it's with a function like Selection.NumberFormat = "V00000000000" but I can't figure it out... Thanks a...

Hello there, how can I convert a text string like "YYYYMMDD" into a date format "DD/MM/YYYY"? thanks, alfredo

Hello, can you execute an insert into command by clicking on a link / button, etc... without having to send it to a new .asp page? I have 2 .asp pages: Page1.asp shows some database data and requests some values using a form. Page2.asp shows the same database data and performs some...

Hello everyone, I need to show incremental dates based on the input from the users. The user first enters the date, and then the number of periods and the type of period (weekly, monthly, etc..). For example: User input: Date = 05/09/2004 (spanish style DD/MM/YYYY), Number = 4, Period =...

Hello there, I need your help before I [pc]... A part of my result table should show 1, 2, 3 .. rows (never more than 10) depending on the value entered by the user through a form. The output must be, if the user enters 4: some info 1º Item 2º Item 3º Item 4º Item other info The code I have...

Hello everyone, Can I "ident" (I think that's the right word) with ASP the results of a database query on a table such as: Name Product $ SALES ALFREDO PRODUCT1 25 ALFREDO PRODUCT2 5 ALFREDO PRODUCT3 10 to make it look like: Name Product...

Hello there, I need to calculate the total amount (SUM(SALDO_ACTUAL)) of the accounts belonging to a customer obtained from a database after the customer's id is obtained from an input box. What I would like to obtain is: ACC NUMBER AMOUNT 123090912 125.00 468468664 100.00 TOTAL...

hello everyone, is it there a SQL query that will empty all the tables in my database? Something like DELETE FROM ALL_TABLES... Thanks! alfredo

Hello there, can I format the number retrieved from a database with the formatcurrency function so it gives me a different currency than the one in the server? I get : $20,000.00 and I need Bs. 20.000,00 Thanks in advance for your help in this matter. Alfredo