Search results for query: *

Hi All, I have a table with the following content: TableB ColumnA 1034% 2900% 3444% 10% (the percent signs in the tables are wildcards) I have a value 103459 (its a variable) and i want to check if this exists in the table; this value exists in the table because we have a value in the table...

Hi all, I have a table with the following content: TABLEA T1 | T2 | T3 123 1231243 GHAL 123 0003423 0001 123 3242342 0002 488 2342344 0001 456 3333444 0001 456 6526545 GHAL I want to to order this table by T1 and T3, but the order of the T3 must be: 0001...

Hi all, I have an application which communicates with MySAP 2005. I can query to get some information. Do you know where i can find the FI document number and the MM document number? I have the invoicenumber, suppliernumber, invoice date and company, can i find the FI document number and the MM...

Hi, I hope this will be the last quesion for today. I have a table with streetnames and housenumbers. I want to update this column with only the streetname and put the housenumber in another column. The table which i have is look like: TableA street | supplement My street 123 | StreetABC 56...

Hi all, SELECT * FROM XX_TABLEA WHERE T1 LIKE (SELECT T1 FROM XX_TABLEB WHERE USER_NAME = 'ZARGO') The tables are look like: XX_TABLEA T1 1100023 1012132 2012121 And the other table: XX_TABLEB T1 USER_NAME 10% ZARGO 11% ZARGO 20% OTHER I want to get these...

Hi, I have a table like this: tableA ColumnA NK232341234B01 111234556 JHJLKJKJLB01 SDFKSDJFLKASB01 How can i update these records to change the substr(columnA,-3,1) from B to 8 if this position has a B? When the value is like NK232341234B01 it must be NK232341234801 Hope somebody can help...

Hi all, I have a table with 3 columns TableA ColumnA ColumnFrom ColumnTo 566677 A1 A6 341334 TEST TEST 234333 000023 000150 I must put this information into another table with all values between ColumnFrom and ColumnTo TableB ColumnA ColumnB 566677 A1 566677 A2 566677 A3...

Hi all, Does anybody know how i must create a query to get the following result: TableA DOCSID DATE LINDEX 112334 14-12-2006 20:18:00 6007 112334 14-12-2006 20:23:00 1023 112334 14-12-2006 20:54:00 1005 112334 14-12-2006 20:56:00 1058...

Hi all, I have written a trigger but i think this isn't a smart one. Can some of you check this and write this smarter? CREATE TRIGGER [transfer] ON dbo.accounting FOR INSERT AS update accounting set t7 = 0 from accounting a inner join inserted I on a.docid=I.docid where i.docid in (select...

Hi all, I have a table with the following information: Mytable Column1 Column2 Colum3 1000 Userb 2006-10-25 6005 Userc 2006-10-24 3455 Userd 2006-10-24 6005 Usere 2006-10-23 1233 Userf 2006-10-23 6005 Userg 2006-10-22 I want to select the second user who has the...

Hi all, I have an Oracle database and in one of the tables the dateformat is stored like: 31-12-2005 1-1-2006 1-2-2006 28-2-2006 I want to convert these dateformats to DDMMYYYY, how can i do this? I have tried Select to_date(datecolumn,DDMMYYYY) from mytable..without success. I could only...

Hi all, Is it possible in Windows 2003 to give some users execute permissions for a share, because this folder contains some dll's, without giving list folder view rights? What i want is when they browse to that directory they couldnt see the contents, but the applications(on their pc's) must...

Hi all, I want to update two columns, it doesnt work what do i wrong? update supplier_data set a.supplier_num = b.supplier_num_new, a.comp_no = b.comp_no_new from supplier_conversion b, supplier_data a where a.supplier_num = b.SUPPLIER_NUM_OLD and a.comp_no = b.comp_no_old TIA, Zargo

Hi all, I have two tables like: Table1 indexnr 1001 1002 1003 1004 Table2 Indexnr | Datefield | Actionfield 1001 |09-20-2006 | 4000 1001 |09-21-2006 | 4001 1001 |09-22-2006 | 4008 1001 |09-23-2006 | 4050 1002 |09-20-2006 | 4001 1002 |09-21-2006 | 4050 1002 |09-22-2006 | 4060 I...

Hi all, I have vmware on my laptop. When i start some environments i couldnt copy some files from my system to the vmware sessions. I'm connecting to the vmware environments via remote desktop connections and i have checked the option to want my local disks etc. This problem occurs only when...

Hi all, Is it possible to disable some queries from an application. The application is doing a huge UDATE query which i want to disable. All other queries from this application is ok. We can't change the coding of the application. Is it possible that we can disable some queries from this...

Hi all, I know that 1433 is the default port to open for SQL server. Are there other ports to open when i want to communicate with my sql server (from my client machine) to fire some queries and show this in my application at the client side? At the moment i'm getting sql server does not exist...

Hi all, I have an huge view. Is it possible to create indexes on views. Is it better to create tables in stead of views and index those tables, maybe tables are faster then views? TIA, Zargo

Hi all, I have an huge table called link with the following content: company account Codestart Codeend 100 515055 U UZZZZZ 100 515055 KG1L KG1L 100 515055 KGINT KGINT 100 515055 KG1A KG1A 100 515055 LG1 LG5 100 515055 800000 899999 100...

Hi all, I have a performance issue and want to create some indexes on the column of a huge table. I never insert or update or delete in this table. Only what i'm doing is SELECT. What shall i do: - Create 1 index on all columns or - Create for each column a index And what kind of property...