• RELEVANCY SCORE 3.74

    DB:3.74:How Do I Get The Columns Names And Data Types From Msaccess Database For Particular Table And How Do I Find Schema Name In Msaccess jm




    How do i get the columns names and data types from MsAccess database for particular table and how do i find schema name in MsAccess

    DB:3.74:How Do I Get The Columns Names And Data Types From Msaccess Database For Particular Table And How Do I Find Schema Name In Msaccess jm

    Hi,
    Check below similar thread
    http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/c8d7b3a6-cd99-4a45-a90b-66bfd6142b35

    Regards
    Ishan

  • RELEVANCY SCORE 3.61

    DB:3.61:Deleting Empty Columns sz





    Hi Guys,

    How can I delete empty columns in a data table? I am trying something like this:

    !

    Deleting empty columns

    nC = N Col(col1);

    names = col1 Get Column Names();

    for(i=1,inC,i++,

    If(Is Empty(names[i]),

    col1 Delete columns(names[i]));

    https://communities.sas.com/pre

    --

    However this is not deleting the empty columns. Is there another way to do this?

    Thanks.

    DB:3.61:Deleting Empty Columns sz


    Try this:

    !

    Re: Deleting empty columns

    dt = Current Data Table();

    nC = N Col( dt );

    names = dt Get Column Names();

    For( i = nC, i =1, i--,

    Summarize( c = Count( Eval( names#91;i#93; ) ) );

    If( c 0,

    Remove From( names, i )

    );

    );

    dt delete columns( names );

    --

  • RELEVANCY SCORE 3.46

    DB:3.46:Table Names And Number Of Columns 73




    Hi,
    I want to get the table names and the number of columns in that table in a database.
    Your help is highly appreciated.

    Thanks in advance.

    Bhargava S Akula.

  • RELEVANCY SCORE 3.46

    DB:3.46:Jtable Creation And Viewing 1m


    I want to create a table and display it along with the column names on it?

    i.e
    if I have two columns Names, Properties

    When I run I want to see

    Names Properties
    row1 row1properties
    row2 row2properties
    ...etc

    I tried giving this

    DataModelClass newDataModelClass = new DataModelClass();
    public JTable jTable1 = new JTable(newDataModelClass.data);

    which is displaying only the data not the column names.
    How can I get the column names also when I run?

    Thanks.

    DB:3.46:Jtable Creation And Viewing 1m

    It seems you need to study more. Go here to learn.
    http://www2.gol.com/users/tame/swing/examples/SwingExamples.html

  • RELEVANCY SCORE 3.45

    DB:3.45:Creating Contact Subgroups Why Do I Lose The Names What Is The Difference Between An Address Book And Contact List fd


    *I have created several contact subgroups in my address book
    When I add them from the contact list or address book of names I only get an email address
    in both columns titled name and email respectfully. Why do I lose the names?

    What is the difference between an address book and contact list?
    Thanks

    DB:3.45:Creating Contact Subgroups Why Do I Lose The Names What Is The Difference Between An Address Book And Contact List fd

    This article about the Outlook AB may be of interest

    Understanding the Outlook AddressBook
    http://www.contactgenie.info/understanding-the-outlook-addressbook

  • RELEVANCY SCORE 3.41

    DB:3.41:Doi Excel Problem mk



    Hi,

    I use the Method below to create my ranges in Excel.

    CALL METHOD spreadsheet-insert_range_dim

    EXPORTING name = 'LIFNR'

    top = top

    left = left

    rows = rows

    columns = columns

    updating = updating

    no_flush = no_flush

    IMPORTING error = error

    retcode = retcode.

    second Ranges Name;

    CALL METHOD spreadsheet-insert_range_dim

    EXPORTING name = 'MATNR'

    top = top

    left = left

    rows = rows

    columns = columns

    updating = updating

    no_flush = no_flush

    IMPORTING error = error

    retcode = retcode.

    After that I use method below to get the names into

    t_ranges. Till Now everything is ok.

    CALL METHOD cl_spreadsheet-get_ranges_names

    IMPORTING

    error = error

    ranges = t_ranges.

    But I just had to change the ranges Names depending on

    New Requirements.

    So I have changed the Ranges names with method again like this ( I need this time only one Range);

    CALL METHOD spreadsheet-insert_range_dim

    EXPORTING name = 'MAKTX'

    top = top

    left = left

    rows = rows

    columns = columns

    updating = updating

    no_flush = no_flush

    IMPORTING error = error

    retcode = retcode.

    After this I call Method below to get the name into t_range.

    CALL METHOD cl_spreadsheet-get_ranges_names

    IMPORTING

    error = error

    ranges = t_ranges.

    But This Time it brings me LIFNR and MAKTX into t_ranges,

    although I think I would see only MAKTX in t_ranges.

    What is wrong? Why has t_ranges LIFNR and MAKTX? t_ranges has to have only MAKTX.

    Do I have to clear the control or other

    Elements and how?

    Thanks for all.

    with my best Regards

    DB:3.41:Doi Excel Problem mk


    I am using this method and it works in my application under ECC 5.0.

    here is a sample from my code...

    refresh: gt_soi_range_list.
    clear: gt_soi_range_list.
    gt_soi_range_list-name = 'DATA1'.

    call method gh_oi_spreadsheet-delete_ranges
    exporting
    no_flush = ''
    ranges = gt_soi_range_list
    importing
    error = gh_oi_error
    retcode = gh_oi_retcode.
    call method gh_oi_error-raise_message
    exporting
    type = 'E'.

  • RELEVANCY SCORE 3.39

    DB:3.39:How Can I Get Column_Name And Column_Value In Tabular Format m8


    Hi,
    My problem is I have a the table emp

    I want the display to be
    ename scott
    deptno 10
    job ****

    like that
    for only those columns having some value in it.

    this is corresponding to one record only.

    how can I do it.
    though I know that I can get column names from user_tab_columns
    and the values is in emp table.

    please help.

    DB:3.39:How Can I Get Column_Name And Column_Value In Tabular Format m8

    There are a lot of ways to do this. If you are going to use
    John Donahue's approach, then all values of b must be of the
    same data type, so you would need to use TO_CHAR (deptno) b. If
    you want to specify only columns having some value, then you
    will need to add WHERE b IS NOT NULL. You can also add an
    additional sub-query to order by whatever column(s) you want.
    If you want to allow for an unknown number of columns where you
    don't know the names of the columns, then you can use a sql
    script to create a sql script, that references
    user_tab_columns. For example, running the first script below
    will create and run the second script below, which will produce
    the results below that.

    SET ECHO OFF
    SET FEEDBACK OFF
    SET HEADING OFF
    SET LINESIZE 150
    SET PAGESIZE 0
    SPOOL query.sql
    SELECT 'SELECT a column_name, b value'
    FROM DUAL
    /
    SELECT 'FROM (SELECT ROWNUM rn,'
    ||column_id||' orderby,'
    || ''''||column_name||''' a,'
    || 'TO_CHAR('||column_name||') b '
    || 'FROM (SELECT * FROM emp ORDER BY 1)'
    FROM user_tab_columns
    WHERE table_name = 'EMP'
    AND column_id = 1
    /
    SELECT 'UNION SELECT ROWNUM rn,'
    ||column_id||' orderby,'
    || ''''||column_name||''' a,'
    || 'TO_CHAR('||column_name||') b '
    || 'FROM (SELECT * FROM emp ORDER BY 1)'
    FROM user_tab_columns
    WHERE table_name = 'EMP'
    AND column_id 1
    /
    SELECT 'UNION SELECT ROWNUM rn,'
    ||TO_CHAR(MAX(column_id)+1)||' orderby,'
    || 'NULL a,'
    || ''' '' b '
    || 'FROM (SELECT * FROM emp ORDER BY 1)'
    FROM user_tab_columns
    WHERE table_name = 'EMP'
    /
    SELECT ')'
    FROM DUAL
    /
    SELECT 'WHERE b IS NOT NULL'
    FROM DUAL
    /
    SELECT 'ORDER BY rn, orderby;'
    FROM DUAL
    /
    SPOOL OFF
    SET PAGESIZE 1000
    SET LINESIZE 80
    SET HEADING ON
    SET FEEDBACK ON
    START query

    SELECT a column_name, b value
    FROM (SELECT ROWNUM rn,1 orderby,'EMPNO' a,TO_CHAR(EMPNO) b FROM
    (SELECT * FROM emp ORDER BY 1)
    UNION SELECT ROWNUM rn,2 orderby,'ENAME' a,TO_CHAR(ENAME) b FROM
    (SELECT * FROM emp ORDER BY 1)
    UNION SELECT ROWNUM rn,3 orderby,'JOB' a,TO_CHAR(JOB) b FROM
    (SELECT * FROM emp ORDER BY 1)
    UNION SELECT ROWNUM rn,4 orderby,'MGR' a,TO_CHAR(MGR) b FROM
    (SELECT * FROM emp ORDER BY 1)
    UNION SELECT ROWNUM rn,5 orderby,'HIREDATE' a,TO_CHAR(HIREDATE)
    b FROM (SELECT * FROM emp ORDER BY 1)
    UNION SELECT ROWNUM rn,6 orderby,'SAL' a,TO_CHAR(SAL) b FROM
    (SELECT * FROM emp ORDER BY 1)
    UNION SELECT ROWNUM rn,7 orderby,'COMM' a,TO_CHAR(COMM) b FROM
    (SELECT * FROM emp ORDER BY 1)
    UNION SELECT ROWNUM rn,8 orderby,'DEPTNO' a,TO_CHAR(DEPTNO) b
    FROM (SELECT * FROM emp ORDER BY 1)
    UNION SELECT ROWNUM rn,9 orderby,NULL a,' ' b FROM (SELECT *
    FROM emp ORDER BY 1)
    )
    WHERE b IS NOT NULL
    ORDER BY rn, orderby;

    COLUMN_N VALUE
    -------- ---------------------------
    EMPNO 7369
    ENAME SMITH
    JOB CLERK
    MGR 7902
    HIREDATE 17-DEC-80
    SAL 800
    DEPTNO 20

    EMPNO 7499
    ENAME ALLEN
    JOB SALESMAN
    MGR 7698
    HIREDATE 20-FEB-81
    SAL 1600
    COMM 300
    DEPTNO 30

    EMPNO 7521
    ENAME WARD
    JOB SALESMAN
    MGR 7698
    HIREDATE 22-FEB-81
    SAL 1250
    COMM 500
    DEPTNO 30

    EMPNO 7566
    ENAME JONES
    JOB MANAGER
    MGR 7839
    HIREDATE 02-APR-81
    SAL 2975
    DEPTNO 20

    EMPNO 7654
    ENAME MARTIN
    JOB SALESMAN
    MGR 7698
    HIREDATE 28-SEP-81
    SAL 1250
    COMM 1400
    DEPTNO 30

    EMPNO 7698
    ENAME BLAKE
    JOB MANAGER
    MGR 7839
    HIREDATE 01-MAY-81
    SAL 2850
    DEPTNO 30

    EMPNO 7782
    ENAME CLARK
    JOB MANAGER
    MGR 7839
    HIREDATE 09-JUN-81
    SAL 2450
    DEPTNO 10

    EMPNO 7788
    ENAME SCOTT
    JOB ANALYST
    MGR 7566
    HIREDATE 09-DEC-82
    SAL 3000
    DEPTNO 20

    EMPNO 7839
    ENAME KING
    JOB PRESIDENT
    HIREDATE 17-NOV-81
    SAL 5000
    DEPTNO 10

    EMPNO 7844
    ENAME TURNER
    JOB SALESMAN
    MGR 7698
    HIREDATE 08-SEP-81
    SAL 1500
    COMM 0
    DEPTNO 30

    EMPNO 7876
    ENAME ADAMS
    JOB CLERK
    MGR 7788
    HIREDATE 12-JAN-83
    SAL 1100
    DEPTNO 20

    EMPNO 7900
    ENAME JAMES
    JOB CLERK
    MGR 7698
    HIREDATE 03-DEC-81
    SAL 950
    DEPTNO 30

    EMPNO 7902
    ENAME FORD
    JOB ANALYST
    MGR 7566
    HIREDATE 03-DEC-81
    SAL 3000
    DEPTNO 20

    EMPNO 7934
    ENAME MILLER
    JOB CLERK
    MGR 7782
    HIREDATE 23-JAN-82
    SAL 1300
    DEPTNO 10

    115 rows selected.

  • RELEVANCY SCORE 3.38

    DB:3.38:How To Get Column Names In Android pp


    do u know howretrievethe columns of table using columns name NAME in Android !!
    Taking the value of Name dynamically by user!!!

    DB:3.38:How To Get Column Names In Android pp

    Your question is not clear. What is your back end? Can you show what have you tried?For every expert, there is an equal and opposite expert. - Becker's Law

    My blog

  • RELEVANCY SCORE 3.36

    DB:3.36:Microsoft Excel - Combine Columns ka


    I have "Mr. & Mrs." in one column, and "Smith" in the next column. This travels down 2000 rows with various titles and last names. I want to combine these two columns into one column, reading "Mr. & Mrs. Smith". How do I do this?

    DB:3.36:Microsoft Excel - Combine Columns ka


    Allan,

    It worked! Thanks very much for your help.

    jpmmjm

  • RELEVANCY SCORE 3.34

    DB:3.34:Spreadsheets 17


    I have a spreadsheet in Numbers/08. I am 'copy and pasting' some of the columns into another format in Pages. I want to merge two of the columns from Numbers into one when I put them in the Pages format, which means there will be 2 names in each of the merged cells. I want them one name beneath the other in each cell but when I try to do this, one name just eradicates the other. How do I get both names in the one cell?

    DB:3.34:Spreadsheets 17

    +After the first try, the previous method suggested stopped working for me. Whenever I press command c to copy, the name is deleted and I just get a "c". I can't understand what I'm doing wrong+.

    enaid,

    I quiver at the thought of that much manual labor, so I haven't tried it. I did try my suggestion, as you can see.

    Jerry

  • RELEVANCY SCORE 3.30

    DB:3.30:How To Get Table Names Of View Columns ? Resultsetmetadata.Gettablename ? 7j


    I am searching for a way to find out the table names that view columns point to. But with ResultSetMetaData.getTableName I do only get the name of the view itself. It's the same with Oracle and MySQL databases. I found some hints that these methods where not implemented in some oracle drivers for example and type 4 drivers should be used. But I haven't found a driver that gives the information until now. Is there any chance to get the information?

    DB:3.30:How To Get Table Names Of View Columns ? Resultsetmetadata.Gettablename ? 7j

    Hi, I get a little further with this. I do now know to which tables the view itself is "connected", but I do not know which column of the view points to which column of which table. Can you help with this, too. Maybe with more knowledge about system tables like dba_objects I could do this by myself, but if you can help, that would be perfect. Regards Udo

  • RELEVANCY SCORE 3.30

    DB:3.30:How To Know Which Columns Are Not Null And Which Are Null f9


    Hi Freinds,

    I want to Know ,How by Wrting a Query we can get the Names of The Columns from the Table which is set to not-null or null,

    Thanks

    Shoaib

  • RELEVANCY SCORE 3.30

    DB:3.30:Adding Columns To A Jtable fa


    Hi there,

    I was wondereing if anyone could tell me how you add more columns to a JTable, the code I have for the column bit is as follows:

    String[] columnNames = {"",
    "Monday",
    "Tuesday",
    "Wednesday",
    "Thursday",
    };

    Which gives the columns names, but how do I get more than five columns to appear on the screen?

    Cheers,

    Sabre

  • RELEVANCY SCORE 3.29

    DB:3.29:Dynamic Mappin Of Different Tables Named Different Columns Names But Need To Mapp To Destination 79


    I am trying to map Listof tables columns to the destionation Table columns .

    Problem i am facing is i have a list of table names and doing foreach of table name and then need to map each tables columns to the destinatio table columns.

    How to do this. I went through the forums but i dint find a proper answer to it. I can see that we can achieve this progrmmatically in SSIS (if its by using script component) then how to do this.

    Guidence needed.

    DB:3.29:Dynamic Mappin Of Different Tables Named Different Columns Names But Need To Mapp To Destination 79

    I went through the same pain last year when I needed to extract data from JDEdwards ERP tables having a gazillion of columns and a myriad of tables.
    I ended up creating the package programmatically in Visual Studio 2008 for that client, it took a bit of my time to set all up, but I save a lot of time mapping tables.
    Here is how I created it: follow this tutorial by Duane
    http://ssisbi.com/building-ssis-packages-programmatically-part-1/
    PS: I have no longer have access to my code, and the above blog has it all outlined very well.
    Good luck black@!Arthur My Blog

  • RELEVANCY SCORE 3.28

    DB:3.28:Getting The Name Of Columns When Doing Query 77


    Hi,

    I need to get the name of a column when im doing a query from a database (postgres). For example

    StationName Bakerloo Central Circle District HammersmithAndCity Jubilee

    Piccadilly 1 0 0 0 0 0

    The top line is my headings, so how do I found out what lines the piccadilly is from that database, i.e how to I get the names of columns?

    Thanks

    tzaf

    DB:3.28:Getting The Name Of Columns When Doing Query 77

    I suggest you do a select * from your table and then use the

    ResultSetMetaData class to get the column name of each column in the table.

  • RELEVANCY SCORE 3.27

    DB:3.27:Library jd



    When i go into my library it only shows two columns "file type" and "remaining" it doesn't show book names or any of the options on the left where you drag your books into the reader - how do i get this back?

    DB:3.27:Library jd


    Again, worth a try , I accidentally discovered this sorted something similar - hit the "bookshelves" "pictures" buttons (top right) alternately a couplwe of times quickly.

  • RELEVANCY SCORE 3.26

    DB:3.26:How To Get A List Of Tables In An Application x1


    In version 6.0 I could do a simple join on views CI_TABLE_DEFINITIONS and CI_APPLICATION_SYSTEMS to get a list of table names given the name of the application system. The requisite columns to perform the join aren't there anymore in version 6i. How does on accomplish this?

    DB:3.26:How To Get A List Of Tables In An Application x1

    If you want columns and column descriptions as well:

    select ci_table_definitions.name,ci_columns.name,cdi_text.txt_text, ci_application_systems.name
    from ci_columns,ci_table_definitions,cdi_text,ci_application_systems,sdd_folder_members
    where ci_columns.table_reference=ci_table_definitions.irid
    and cdi_text.txt_ref (+)=ci_columns.irid
    and ci_application_systems.irid = sdd_folder_members.folder_reference
    and sdd_folder_members.member_object = ci_table_definitions.irid
    and ci_application_systems.name = 'Application Name'
    order by ci_table_definitions.name;

  • RELEVANCY SCORE 3.24

    DB:3.24:Remove Previously Promoted Fields 8f


    I am having trouble removing previously promoted fields from my form library.
     
    Scenario:
     
    InfoPath 2007
    SharePoint Server 2007 using Forms Services
     
    I had published my infopath form as a content type and made that content type the default for this form library.  I then promoted several fields when I published the form and I gave them custom names in the publishing wizard.  I then changed the custom names when I published the next version of the form template (because I decided to call them something different). 
     
    The problem is that the old promoted field names are still showing in both the content type and the library along with the new names (I now have twice as many columns as I should have).  I was able to delete these extra columns from the content type but they still show up in the library.  When editing settings on the library, these columns are not editable (thier names are not clickable).  I have deleted all form instances from the library (thinking that maybe an old form instance that used the old names caused them to stick around) but that had no effect. 
     
    How on earth do I get rid of these columns that were created by field promotion?  I would rather not delete the entire form library because that means recreating my workflows that I have built on the library.

    DB:3.24:Remove Previously Promoted Fields 8f

    I have this issue as well, tons of fields duplicated, how can Microsoft approve garbage like this to production?
    Then they keep complaining that no one wants their Window Phone or their Windows 8, well, daa! look at the garbage we keep finding every day! I have to delete and recreate the site collection!

  • RELEVANCY SCORE 3.23

    DB:3.23:Query Creating Duplicate Entries 88



    I have created a query for a specific software package. When I run the query I see multiple lines for several, but not all the workstations listed. I have selected several columns of data I need output from this query. I do see differences in the lines for the duplicated device names. My question is how do I identify the cause for the duplicates and how do I get accurate data from the query?

    DB:3.23:Query Creating Duplicate Entries 88


    I have found this is typically caused by the items (columns) you are bringing back in the query. Make sure the machine component looks for the software you are specifically looking for. Also, if you have multiple lines per device, look at which of the columns have differences and start looking there how you can prevent the differences you aren't looking for. Like specifying a version number.

  • RELEVANCY SCORE 3.23

    DB:3.23:How To Copy Columns Of Data From One Table To Another Table ? 13


    I have a MS Sql Server 2008R2 system with 2 tables. Table1 has a set of columns. Table2 has the same columns as Table1 plus a few more columns. The columns that are common to both tables have the same names and the same data types.
    I'm writing a .net c# program to push data from Table1 into Table2. There are a few columns in Table2 that I cannot change. So I can't do something like drop table2, then create it with a 'select into' sql statement. To be specific, Table1
    has 20 columns and Table2 has 22 columns. Each tablehas about 1 million records. The 2 extra columns in Table2 are assigned by a line of business application and my program cannot overwrite them. The goal of the program is to get Table2
    updated from Table1, including any inserts and deletes that may be needed.
    Is there some simple way to push across the columns that match and leave the 2 that don't match unaltered?

    DB:3.23:How To Copy Columns Of Data From One Table To Another Table ? 13

    Hello re4,
    As John Sansom suggested earlier, use SSIS for your case. I think you do not want to do this operation frequently. May be daily or weekly or even monthly. Try to avoid Linked Server as possible. Linked Server or OPENROWSET queries are prone
    to have performance issues (not always).
    Even if you are looking for real time data sync, you can have incremental porting of data provided the data structure supports using SSIS and you can schedule the package to run every 1 minute or so.
    EDIT: You can Also look at Transactional Replication as an option.
    The above is personal opinion from my experience.

  • RELEVANCY SCORE 3.23

    DB:3.23:How To I Make The Columns Stay The Width Of The Column Header Names? xk


    In a web-based application, I am trying to display a report that is wider then the width of the screen.  Instead allowing horizontal scrolling, the report columns are compressed so the rows fit on 1 page.   This makes the report unreadable and unprofessional looking.  
     
    How do I make the columns stay the width of the column header names?   I don't mind how wide a report is (scrolling) I just don't want a report that is several pages wide to be compressed to fit on the screen.

    DB:3.23:How To I Make The Columns Stay The Width Of The Column Header Names? xk

    In a web-based application, I am trying to display a report that is wider then the width of the screen.  Instead allowing horizontal scrolling, the report columns are compressed so the rows fit on 1 page.   This makes the report unreadable and unprofessional looking.  
     
    How do I make the columns stay the width of the column header names?   I don't mind how wide a report is (scrolling) I just don't want a report that is several pages wide to be compressed to fit on the screen.

  • RELEVANCY SCORE 3.22

    DB:3.22:How Do I Rename Columns Example Instead Of A, B,C I Would Like House , Address, Zipcode 31


    I would like to rename the columns . instead of A, B. C. i nedd to insert names for those columns

    DB:3.22:How Do I Rename Columns Example Instead Of A, B,C I Would Like House , Address, Zipcode 31

    The switch between A1 and R1C1 is kept within Excel 2007's Excel Options.
    Click the Office button, then theExcel Options buttonin the lower right. Select Formulas within the list at the left and scroll down to Working with Formulas (second group of options).
    The R1C1 reference styleoption should be the first in this group.
    Toggling that option offshould get you back to the A1 reference style.

    If this proposed solution has resolved your issue(s), please return and mark it asAnsweredfor others to consider.

  • RELEVANCY SCORE 3.22

    DB:3.22:How Do I Separate Names In A Cell I Want First And Last Names In Different Cells. ax


    I have one column that contains names in the format of LastName, Firstname. I want two separate columns. What function do I use to do this without manually doing it? Thanks.

    DB:3.22:How Do I Separate Names In A Cell I Want First And Last Names In Different Cells. ax

    Rick,
    I have this ugly feeling that with one example this probably won't be the answer anyway but thanks for the tip.

    If this post answers your question, please mark it as the Answer.
    Mike H

  • RELEVANCY SCORE 3.21

    DB:3.21:Contact Names 1s


    Today, my contact names disappeared, and I only have phone numbers. How do I bring back the contact names?

    DB:3.21:Contact Names 1s

    Today, my contact names disappeared, and I only have phone numbers. How do I bring back the contact names?

  • RELEVANCY SCORE 3.21

    DB:3.21:How To Create A Dynamic Table Box Or Straight Table aa



    Hello:

    I'm able to import a xls with columns names, every time this xls has diferent columns names and diferent quantity of columns.

    I also have created a Data Island with all the column names.

    Now I need create a Table Box or a Straight Table with all the columns (diferents every reload).

    Please, how can I do that?

    Thank you

    DB:3.21:How To Create A Dynamic Table Box Or Straight Table aa


    Probably, but macros not always works on Access Point + Ajax.

  • RELEVANCY SCORE 3.21

    DB:3.21:I Need To Combine Two Excel Columns Into One. 1m


    Specifically I've exported a .csv file from another web app and it has First Names and Last Names in separate columns. I need them combined into a single column which includes both first and last names. I can't seem to remember how to get it come without the delimiter. I've already had to specify which columns to "skip" and other things in the dialogue box brought up when I "Get external data." Any way to do this cleanly?Thanks in advance,Dan

    DB:3.21:I Need To Combine Two Excel Columns Into One. 1m

    Easiest way, when already in Excel, is to use the CONCANTENATE function in a new column that will then have the combined text of the separate columns...For example column A has the first name and column B has the last name...use the following formula in any empty column cell: =CONCANTENATE(A1, " ", B1)(note added the literal space surrounded by quotes as thats how you would normally see the names.then you select and copy the formula of the cell (Cmd-C), then select/highlight the rest of the column and paste (Cmd-V) and you're done.

  • RELEVANCY SCORE 3.21

    DB:3.21:Getcolumns() Method On Databasemetadata Returns Empty For Table Synonyms 9s


    How can i get Information about table columns from TableSynonym.
    getColumns name in DatabaseMetadata returns empty result set for tableSynonyms.

    because of security restrictions and for easy database maintainence i should not use table names itself.

    I am using following method to check number of columns in Table synonym.
    passing tableSynonym for tableName pattern argument.

    getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
    Retrieves a description of table columns available in the specified catalog.

    Do you guys suggest any work around to get Columns associated with real table from its synonym.

    DB:3.21:Getcolumns() Method On Databasemetadata Returns Empty For Table Synonyms 9s

    What JDBC driver are you using? If you use Oracle, try this:

    //ORACLE fix:
    if (connection instanceof oracle.jdbc.driver.OracleConnection) {
    /* Turn on or off retrieval of synonym information in DatabaseMetaData.getColumns().
    Similar to setRemarksReporting, getColumns performs extremely slow if information about synonyms
    has to be included, because it neccessitates an outer join. By default, the JDBC driver will not report
    information about table columns when you pass a synonym to getColumns.

    You can get synonym information by passing true to this method, and turn it off by passing false.
    You can also control this behavior by passing a property named "includeSynonyms" as "true" to
    DriverManager.getConnection.

    http://exciton.cs.oberlin.edu/javaresources/Oracle/oracle/jdbc/driver/OracleConnection.html#setIncludeSynonyms(boolean)
    */
    ((oracle.jdbc.driver.OracleConnection) connection).setIncludeSynonyms(true);
    }

  • RELEVANCY SCORE 3.21

    DB:3.21:Wrapping Text For Column Labels sk



    I think this should be fairly simple, but how to do it is evading me.

    For Qlik Sense Desktop...

    I have a table with 7 columns. 2 of these have long names, which means that the columns get cut off when I try to look at them:

    I'm trying to not have those three dots there and just display the column. One way (I think) to accomplish this is to wrap the text of these long column names, which would make all the columns fit in a single view. I have no idea how to do this and have searched for hours about it.

    Any insights would be helpful.

    Thanks,

    JMR

    DB:3.21:Wrapping Text For Column Labels sk


    I think this should be fairly simple, but how to do it is evading me.

    For Qlik Sense Desktop...

    I have a table with 7 columns. 2 of these have long names, which means that the columns get cut off when I try to look at them:

    I'm trying to not have those three dots there and just display the column. One way (I think) to accomplish this is to wrap the text of these long column names, which would make all the columns fit in a single view. I have no idea how to do this and have searched for hours about it.

    Any insights would be helpful.

    Thanks,

    JMR

  • RELEVANCY SCORE 3.20

    DB:3.20:Excel Gallery Used List From Gallery Changed Column Names. What Are The Hovering Balloons How Do I Change Them fp


    I used a list from the Excel Gallery. I changed the names of the columns to create column names that I want to use. The column names were changed with no problem, however, when I hover over the columns, I get a yellowish balloon with the names of what
    the columns used to be. For example, where the column name was LASTNAME, a balloon shows up saying, "The person's last name".... How do I change or remove this? Can anyone even tell me what this is properly called?

    DB:3.20:Excel Gallery Used List From Gallery Changed Column Names. What Are The Hovering Balloons How Do I Change Them fp

    Which template are you using from the Excel Gallery?

    Quit and reopen Excel Workbook and check if that works.

  • RELEVANCY SCORE 3.20

    DB:3.20:Customer And Orders Manager Custom Fields jx


    How do I add columns to the ones that are available by default in the column chooser of the orders view in the Customer and Orders Manager?  I know I can use the LanguageCode_OrdersPresentationInfo.xml to modify the display names of these columns, but what determines which ones get displayed in this view?  Thanks.

  • RELEVANCY SCORE 3.20

    DB:3.20:How Do I Resize Columns In Itunes 11 Store? zk


    When in the iTunes 11 store, and after searching for a particular artist, I see the results. However, many of the song and albums names are cut off since the columns are too narrow. But I can't find any way to adjust them - there's no column headers to grab onto and I don't see anything relevant in the view options.Does anyone know how to adjust the width of these columns?

    DB:3.20:How Do I Resize Columns In Itunes 11 Store? zk

    When in the iTunes 11 store, and after searching for a particular artist, I see the results. However, many of the song and albums names are cut off since the columns are too narrow. But I can't find any way to adjust them - there's no column headers to grab onto and I don't see anything relevant in the view options.Does anyone know how to adjust the width of these columns?

  • RELEVANCY SCORE 3.19

    DB:3.19:Retrieving Column Names From A Sql Table 98


    How can I get the names of all the columns of a table from my data base?

    DB:3.19:Retrieving Column Names From A Sql Table 98

    http://java.sun.com/j2se/1.4.1/docs/api/java/sql/DatabaseMetaData.html
    http://developer.java.sun.com/developer/onlineTraining/new2java/supplements/solutions/June02.html

    Here I am adding the field information from a table to a vector called row which is added to another vector fieldInfo.

    fieldInfo = new Vector();
    ResultSetMetaData rsmd = rs.getMetaData(); // where rs is a resultset from a query
    for (int c = 1, cc = rsmd.getColumnCount(); c = cc; c++) {
    row = new Vector(); // save field information
    row.addElement(rsmd.getColumnName(c));
    row.addElement(rsmd.getColumnLabel(c));
    row.addElement(rsmd.getColumnTypeName(c));
    row.addElement(String.valueOf(rsmd.getColumnDisplaySize(c)));
    row.addElement(String.valueOf(rsmd.getScale(c)));

    ...

    fieldInfo.addElement(row);
    }rykk

  • RELEVANCY SCORE 3.19

    DB:3.19:How To Reference Arrays Dynamically? 71


    I have developed a sql query with a dynamic number of rows and columns. I know I can reference the rows by using a ' for i in 1..htmldb_application.g_f01(i) loop' and this is fine. I know that with a query with a standard number of columns you could reference them as htmldb_application.g_f02(i), htmldb_application.g_f03(i) and so on. However, in my case, I have a dynamic number of columns and they are in fact named f02, f03, f04 and so on. I could have 10 or I could have 15 of these. My problem is that now to get the values associated with these columns I have to dynamically determine the names of these columns through a string (ie mstring := 'htmldb_application.g_f0'||colnum||'(i)'') For each row I loop through and build this string which references each of the columns in my array. The problem is that this returns htmldb_application.g_f02(i) as the value and not the actual value of the field.
    I thought I could do 'select htmldb_application.g_f02(i) from dual' and then do an execute immediate statement to return the value but this returns an error saying something to the effect that the function does not exist. So without hardcoding the actual names is there a way to reference each of these columns dynamically?

    DB:3.19:How To Reference Arrays Dynamically? 71

    I have developed a sql query with a dynamic number of rows and columns. I know I can reference the rows by using a ' for i in 1..htmldb_application.g_f01(i) loop' and this is fine. I know that with a query with a standard number of columns you could reference them as htmldb_application.g_f02(i), htmldb_application.g_f03(i) and so on. However, in my case, I have a dynamic number of columns and they are in fact named f02, f03, f04 and so on. I could have 10 or I could have 15 of these. My problem is that now to get the values associated with these columns I have to dynamically determine the names of these columns through a string (ie mstring := 'htmldb_application.g_f0'||colnum||'(i)'') For each row I loop through and build this string which references each of the columns in my array. The problem is that this returns htmldb_application.g_f02(i) as the value and not the actual value of the field.
    I thought I could do 'select htmldb_application.g_f02(i) from dual' and then do an execute immediate statement to return the value but this returns an error saying something to the effect that the function does not exist. So without hardcoding the actual names is there a way to reference each of these columns dynamically?

  • RELEVANCY SCORE 3.18

    DB:3.18:List Boxes Query 3j


     
    Hi ,
     
    I am using two list boxes in a windows application.
     
    One for the list of table names and the other for the columns for those tables.
     
    in list box 1 when i select a table i should get the corresponding columns in list box 2. How should i do that. i have absolutely no clue. All i did so far was get the table names from the database and bind it to list box 1. now how shud i proceed for list box 2.
     
    thanks

    DB:3.18:List Boxes Query 3j

    My suggestion would be to handle the SelectedIndexChanged or SelectedValueChanged event, grab the new index or value which should be given in the arguments and update the second list box.

  • RELEVANCY SCORE 3.18

    DB:3.18:Dynamic Query Using User_Tab_Cols 7d


    Hello All

    I want to select some columns based of some criteria. I would like to get the columns names from the user_tab_cols as there are many columns and I do not want to type them.

    e.g.

    SELECT TABLE_NAME, COLUMN_NAME
    FROM user_tab_cols
    WHERE COLUMN_NAME like '%_type_status'

    and it gives me
    TABLE_NAME COLUMN_NAME
    A ABC_type_status
    A CCC_type_status
    B G_type_status

    and finally the quesry should be like

    SELECT A.ABC_type_status, A.CCC_type_status, B.G_type_status
    FROM A, B

    Any help?
    Regards

    DB:3.18:Dynamic Query Using User_Tab_Cols 7d

    select 'select ' || ltrim(extract(XMLAgg(XMLElement ("COLNAME" ,','||'A.'||column_name)) ,'COLNAME/text()') ,',') || ' from A'
    my_select
    from user_tab_cols
    where table_name = 'A'
    and column_id = 5 -- replace with your condtions
    order by column_id

  • RELEVANCY SCORE 3.18

    DB:3.18:Column Names Using Libname With Excel 87



    Hi,

    I am trying to import an excel file using libname on EG. It works fine, I can connect to the file and the using a data step I can just create a table. However, it creates SAS data sets with columns names that do not comply to SAS naming conventions. I get columns with names like 'sample ID 1'. How am I suppose to use these variable names in a SAS code?

    I am currently moving from display manager to EG and I am not how to solve this issue.

    thanks for your help

    Romain

    DB:3.18:Column Names Using Libname With Excel 87


    In SAS BASE you then need to specify the options to use the datasets from EG. Then to reference the variable, say sample id 1 you quote it and put an n as I indicated earlier.

    options validvarname=any;

    data want;

    set have;

    sample_id1='Sample ID 1'n;

    Run;

  • RELEVANCY SCORE 3.17

    DB:3.17:Resultset Jtable k9


    Following the tutorial at:
    http://java.sun.com/docs/books/tutorial/uiswing/components/table.htm

    I have got a resultset from a database and have following code:

    String[] columnNames;
    ResultSetMetaData md = rs.getMetaData();
    int columns = md.getColumnCount();
    // Get column names
    for (int i = 1; i = columns; i++) {
    HOW DO I ADD THE COLUMNNAMES TO THE String[] columnNames
    }

    Object[][] data;
    while (rs.next()) {
    Vector row = new Vector(columns);
    for (int i = 1; i = columns; i++) {
    row.addElement( rs.getObject(i) );
    }
    // add row to data
    HOW DO I DO THAT ?
    }

    PLEASE HELP

    DB:3.17:Resultset Jtable k9

    I would like to learn this for the same reason as Sun uses for using arrays in their tutorials.

  • RELEVANCY SCORE 3.17

    DB:3.17:Transposing A Table With Custom Arguments 7c



    I am trying to transpose a table with a known Label column name, but Transpose column names that are only known at runtime. I have been trying for hours to figure out how to do this, but the task is greatly complicated by JSL mistaking the Transpose command for the matrix Transpose function and he Columns() argument to it for the function that gets the names of all columns in the table. In the following code, the list columns is populated with the names of the columns I want to transpose.

    //Create the transpose expression

    transposeExpr = Expr(Transpose(Columns(), Label(:Wt or Rd)));

    //Pull the Columns argument expression out of it (this keeps me from having to create it myself and have it mistaken for the Columns() function)

    columnsExpr = Arg(transposeExpr, 1);

    For(i = 1, i = numColumns, i++,

    Insert Into(columnsExpr, Name Expr(As Column(colNames[i])));

    );

    Remove From(transposeExpr, 1);

    Insert Into(transposeExpr, Name Expr(columnsExpr), 1);

    cdt = Current Data Table();

    cdt Transpose(Name Expr(columnsExpr), Label(:Wt or Rd));

    However, this still doesn't appear to work because columnsExpr still evaluates to a list of names of all the columns in the current table, rather than the Columns argument with actual references to the table. (I think it interprets these references are arguments to Columns the function)

    Can anyone please explain what I am doing wrong?

    DB:3.17:Transposing A Table With Custom Arguments 7c


    1. Transpose( Columns() .... ) expects a bunch of column names separated by commas, as you would fill in manually. It does not expect the name of a list and doesn't know how to extract the info from the name of the list containing the column names of interest. The eval function bridges the gap. This is how I view the issue but someone else may have a more technically precise way of explaining it.

    2. Column() versus As Column: I'm not sure how they differ. The short examples in the docs make them seem interchangeable in function. I'd be interested someone can point to differences between them.

  • RELEVANCY SCORE 3.16

    DB:3.16:Get Column Names From Query 7j


    myDb.cmd=Select A.some,B.*,C.that From ATable A, BTable B, CTable C Where various conditions;
    mrRdr=myDb.cmd.ExecuteReader();
    I read the data and put it into a nice grid display.
    How can I also get the names of the columns?
    Thanks, Jon

    DB:3.16:Get Column Names From Query 7j

    dataReader.GetName(0) will give column Name.Nanda - Misys Software Solutions,Bangalore

  • RELEVANCY SCORE 3.15

    DB:3.15:Database Resultset 88


    Following the tutorial at:
    http://java.sun.com/docs/books/tutorial/uiswing/components/table.htm

    I have got a resultset from a database and have following code:

    String[] columnNames;
    ResultSetMetaData md = rs.getMetaData();
    int columns = md.getColumnCount();
    // Get column names
    for (int i = 1; i = columns; i++) {
    HOW DO I ADD THE COLUMNNAMES TO THE String[] columnNames
    }

    Object[][] data;
    while (rs.next()) {
    Vector row = new Vector(columns);
    for (int i = 1; i = columns; i++) {
    row.addElement( rs.getObject(i) );
    }
    // add row to data
    HOW DO I DO THAT ?
    }

    WOULD BE NICE TO GET THE CODELINES

    DB:3.15:Database Resultset 88

    Following the tutorial at:
    http://java.sun.com/docs/books/tutorial/uiswing/components/table.htm

    I have got a resultset from a database and have following code:

    String[] columnNames;
    ResultSetMetaData md = rs.getMetaData();
    int columns = md.getColumnCount();
    // Get column names
    for (int i = 1; i = columns; i++) {
    HOW DO I ADD THE COLUMNNAMES TO THE String[] columnNames
    }

    Object[][] data;
    while (rs.next()) {
    Vector row = new Vector(columns);
    for (int i = 1; i = columns; i++) {
    row.addElement( rs.getObject(i) );
    }
    // add row to data
    HOW DO I DO THAT ?
    }

    WOULD BE NICE TO GET THE CODELINES

  • RELEVANCY SCORE 3.15

    DB:3.15:Re: How To Find Out The Null Columns In The Table? 9z


    Hm,
    Thanks so musch for your instant reply.But,that is not my expectation. Basically, we don't know what are the columns has null values. But, we want to get those column names.

    Note: Same columns should be null for all the rows in the table . I am getting the data dynamically. So, just to indentify the names of columns those have null.

    Please help me.

    Regards,
    Vissu....

    DB:3.15:Re: How To Find Out The Null Columns In The Table? 9z

    Thanks so much Xtender , i am going to implement your logic.

    Regards,
    Vissu....

  • RELEVANCY SCORE 3.15

    DB:3.15:How To Pull Only Column Names From A Select Query Without Running It d9


    How to pull only column names from a SELECT statement without executing it? It seems there is getMetaData() in Java to pull the column names while sql is being prepared and before it gets executed. I need to get the columns whether we run the sql or not.

  • RELEVANCY SCORE 3.14

    DB:3.14:Is It Possible To Get The Values Of Certain Columns Based On Datatype ? 18


    Hi,

    Oracle 11 g
    I have the following table

    create table test_table (
    rating number,
    mark number,
    age number,
    names varchar2(500));

    insert into test_table (rating,mark,age,names) values(1,200,20,'Smith');
    insert into test_table (rating,mark,age,names) values(2,200,30,'Blair');
    insert into test_table (rating,mark,age,names) values(3,200,40,'Will');

    I need to find the values of all columns and also the names of columns that have the datatype as number

    I am half way into it.
    select column_name as PROCESS_NAME from user_tab_columns where table_name = 'TEST_TABLE' and DATA_TYPE='NUMBER';

    above query will give me the column names, but not sure how to dynamically assign these column names to the same sql to get the values of those columns,

    result I am looking is
    Rating mark age
    1 200 20
    2 200 30
    3 200 40

    Thanks
    _pete

    DB:3.14:Is It Possible To Get The Values Of Certain Columns Based On Datatype ? 18

    Hi !

    With PlSql something like this is possible

    SQL
    SQL set serveroutput on
    SQL
    SQL DECLARE
    2 v_sql VARCHAR2(4000) := 'select ';
    3 BEGIN
    4 FOR cur IN (SELECT column_name
    5 FROM all_tab_columns
    6 WHERE table_name = 'EMP'
    7 AND data_type = 'NUMBER'
    8 AND owner = 'SCOTT') LOOP
    9 v_sql := v_sql || ' ' || cur.column_name || ',';
    10 END LOOP;
    11
    12 v_sql := rtrim(v_sql, ',') || ' from emp';
    13 dbms_output.put_line(v_sql);
    14 END;
    15 /
    select EMPNO, MGR, SAL, COMM, DEPTNO from emp

    PL/SQL procedure successfully completed.

    SQL After constructing the SQL stmt you can dynamicaly execute it
    I have no real idea how to do this with SQL only

    T

  • RELEVANCY SCORE 3.14

    DB:3.14:Replication Question pp


    Hi,
    I am trying to set-up a transactional replication.
    1. Created a Publication with 1 table containing only the first four columns (out of 10 columns).
    2. When I create a subscription, how do I map the Publication Columns to Subscription columns? In mysubscriber DB, I need different column names. I don't get an option to map the columns ...
    How do I do it?? TIA.

    DB:3.14:Replication Question pp

    1. To create article with part of columns, please refer to Books On line, title To define a column filter for an article published in a snapshot or transactional publication
    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/repref9/html/504fd568-13ae-4dc4-88da-950c1ec1e8c1.htm
    2. Subscription can have table name different to published table name, but columns name has to be same.

    Thanks
    Yunjing

  • RELEVANCY SCORE 3.14

    DB:3.14:How To Make The Columns Narrower 33


    How do I reduce the width of columns?

    I have set up a group of words, i.e. first names and surnames, into three columns. Some surnames spill over to the next line. So I reduced the width of the space between the columns by dragging the margin along the ruler. However the lines of names are still
    too long for the sake of aesthetic as they take up the space up to the margins of a full page. I would like to shorten the lines by eliminating some empty spaces after the names in each column. In other words I would like to reduce the width of every column.

    How can I achieve that?

    DB:3.14:How To Make The Columns Narrower 33

    Thanks for your detailed response.

    I have downloaded your file. Could you please delete it from your Sky Drive as soon as possible and I shall delete mine at the same time. If you can help please quote the information in there in an inexplicit way. It was my fault I was too lazy to re-invent
    the names.

    I shall try and respond to yours as soon as possible.

  • RELEVANCY SCORE 3.13

    DB:3.13:Get The Total Columns And Column Names Of A Db Table? z9


    Hi

    Is there any way on how to get all the column names and the total number of columns on a DB table using Java?

    thanks!

  • RELEVANCY SCORE 3.13

    DB:3.13:Need How To Add Columns Dynamically To Crystal Report In .Net 8m


    Hi,
         im working on CR.NET. i have a problem where in i need to display subject names(ex- english,science ....)  of student as columns in report and under each subject their respective marks . i  query a database and  get these values as rows in dataset not as columns and  Crystal report requires  initially  to  specify the columns so that design can be done. and as subject 's r not fixed they may change depending on inputs for subjects in database  hence i cannot assume number of columns . i need to programmatically do all the stuff. plz send a solution ASAP.
    my query result
    student name | marks  | Subectname
    raghuram           78         english
    raghuram            34         physics
    raghuram            76         chemistry
    ................              ...         ..........
    Required Result  in Report
    studentname | english | Maths | physics | ......
    raghuram           78           66        32
     
     

    DB:3.13:Need How To Add Columns Dynamically To Crystal Report In .Net 8m

    Hi I have similar problem,
    I have following out put.
    Name Date1 Date2 Date3 Date4 Date5 ............... Daten..... Date z....
    Project1 2 3 2 5 6 ................... 8 ........... 1 ....
    Project2 2 3 2 5 6 ................... 8 ........... 1 ....
    Project3 2 3 2 5 6 ................... 8 ........... 1 ....
    Project3 2 3 2 5 6 ................... 8 ........... 1 .....
    .
    .
    .
    Project N.....................................................................................
    .
    .

    Name is the Name ofEmployee
    Dates are the dates in month that will depend on user selection i can be one day or month or any no of dates..
    Projects. name of projects done byemployee in that time range.
    all the data in the data base
    Please help me to create the report as above
    thank you.
    Gowrishankar .

  • RELEVANCY SCORE 3.13

    DB:3.13:Columns Not In The Same Order 7j


    Hi :

    I am getting the names of all columns in a table using the query :
    SELECT column_name FROM user_tab_columns WHERE table_name = 'MyTable'.

    There are 30 columns in this table and I am getting all those columns - But the order of columns is not the same as we get with a DESC command.
    How do I get the columns in the same order as I have created .

    I tried to use the 'Order By Column_name' but it returns the columns in alphabetical order.

    Any help is appreciated.

    Thanks
    Ram.

  • RELEVANCY SCORE 3.13

    DB:3.13:Use Label To Subset My Data jj



    I have a dataset with over thousands of columns and millions of records. I don't need all the columns (need all the rows) and want to subset my dataset by keeping columns that have specific labels. So, the subsetting is not based on column or var names.... it's based on their labels. Any idea how to do it efficiently?

    Thanks

    DB:3.13:Use Label To Subset My Data jj


    Try googling dictionary tables sas and you'll find a lot of references to them.

    SAS(R) 9.2 Language Reference: Concepts, Second Edition

    Sorry, I pointed you to the wrong table. It is the sashelp.vcolumn or dictionary.columns table instead.

    You can run a proc contents on this table to see the column names and even a proc print to see some of the data.

    Check

    proc sql;

    select name into :vlist separated by " "

    from dictionary.columns where libname ='SASHELP" and memname="CLASS" and upcase(label) contains "YOUR CRITERIA";

    quit;

    data want;

    set have (keep= vlist);

    run;

  • RELEVANCY SCORE 3.13

    DB:3.13:How To Convert Column Names As Rows dj


    Hi All,
    I want to get the columns names are in rows and i can get from one table by information schema. but i my query join more that two table from that i ll select the columns in different table , that i want to use as rows. for example
    select x.A, x.B ,y.A ,y.B, z.C , from x inner join y on x.id = y.id inner join z on z.id = y.id. where 1=0 that defined columns as rows i need.

    please any one give me the solution ..

    DB:3.13:How To Convert Column Names As Rows dj

    hello kasi17 .
    You must filter WHERE
    Example :
    table _Order
    IDOrder (PK)
    IDcustomer (FK)

    table _OrderDetail
    IDorder (PK two properties)
    IDproduct
    Count

    table_Customer
    IDCustomer (PK)
    nameCustomer

    This is result :

    Select A.Order, B.Count, C.nameCustomer

    from Order A inner join OrderDetail B

    on A.IDorder = B.IDorder inner join Customer C

    on C.IDcuscomer = a.IDcustomer

    Where C.IDcustomer = ABC1

  • RELEVANCY SCORE 3.13

    DB:3.13:How To Compare Names In One Column Against Names In Three Other Columns d1


    I need to compare names of potential award winners in column 1 against names in three other columns, B,C and D, to determine amount of award, if any. The number of names in each column if different (column A may have 5 names, column B 15 names, column
    C 10 names and column D 3 names. The result can be in column E indicating which column matched, if any, or I can add a column in between B, C and D and show a match in the new columns. I need to run this once a month. Thanks for any help.

    DB:3.13:How To Compare Names In One Column Against Names In Three Other Columns d1

    Thanks Rich,
    both methods worked and I'll be using the second one.

    Have a great day!

  • RELEVANCY SCORE 3.12

    DB:3.12:Columns In Finder Cut Off The First Part Of File Names, How To Restore Them kx


    Somehow I moved the cursor with my trackpad and now the first part of the column that has the file names has been cut off. I cannot see the beginning of the file names, just the last two or three letters. How do I get the first part of the file names back?

    DB:3.12:Columns In Finder Cut Off The First Part Of File Names, How To Restore Them kx

    Somehow I moved the cursor with my trackpad and now the first part of the column that has the file names has been cut off. I cannot see the beginning of the file names, just the last two or three letters. How do I get the first part of the file names back?

  • RELEVANCY SCORE 3.12

    DB:3.12:Csvde Unicode Extract Problem ja


    Hi,
    I'm using CSVDE to extract data from AD, but due to the content of the data I need to use unicode mode (-u).
    However, when I get the CSV file and open it, I just get 1 row per entry which is not separated into columns based on the attributes. All the data is present in the row, but not in columns instead its all present as a single line of text (although the attributes
    are separated by a comma). If I run it without -u, then I get a proper CSV file with the attribute names in separate columns.
    Is it possible to get CSVDE to generate the attribute names in separate columns? It is tough to do this manually since the DN names have lots of commas in it
    Thanks

    DB:3.12:Csvde Unicode Extract Problem ja

    Hi Mark,
    I'm using adfind for now to get the work done. I prefer using powershell too unfortunately thats not an option currently so I have to rely on older tools.
    I don't think I'll need help with this one for now, I'll look into it in more detail in my spare time. Thanks for all your help.

  • RELEVANCY SCORE 3.12

    DB:3.12:Dividing Two Calculated Fields 8d


    Hi Folks,

    I have an Requirement where in I have to Divide two Columns(calculated) in Custom Report. The Columns names are
    # Opportunities Created and # Opportunities Won
    both of the columns are Calculated and I am using "Count Distinct" aggregation rule so as to get the number.
    Now the issue arises when I have to create a column where i have to do Opportunity Conversion Rate (# Opportunities Created / # Opportunities Won)

    when I am trying to this conversion I am getting Error which states that an Integer calculation is performed on Non- Integer Columns

    How can I achieve this functionality??

    Thanks and Regards,
    Amit Koul

    DB:3.12:Dividing Two Calculated Fields 8d

    Hi Folks,

    I have met the requirement, I used column Tab in the to get the calculation done.

    Thanks and Regards,
    Amit Koul

  • RELEVANCY SCORE 3.12

    DB:3.12:Sql Query Parsing (Retrieve Tables And Columns Used In Query) 1s


    Hi,

    1. Is there any view in Oracle which can tell me, which tables and columns were used in the last ran query, no matter how complex the query is.

    2. Secondly I can get table names, used in stored procedures and views, using USER_DEPENDENCIES VIEW, however this System View does not return column names, used in that procedure / view, any idea please .

    Thanks and Regards,

    Luqman

    DB:3.12:Sql Query Parsing (Retrieve Tables And Columns Used In Query) 1s

    luqman123 wrote:
    Hi,

    1. Is there any view in Oracle which can tell me, which tables and columns were used in the last ran query, no matter how complex the query is.I don't believe so. You can look at V$SQL and retrieve the actual SQL text from there.

    2. Secondly I can get table names, used in stored procedures and views, using USER_DEPENDENCIES VIEW, however this System View does not return column names, used in that procedure / view, any idea please .Oracle added fine grained dependency tracking in 11g, but didn't expose any views to query this information. However, it has been reverse engineered a bit: About Oracle: DBA_DEPENDENCY_COLUMNS

  • RELEVANCY SCORE 3.12

    DB:3.12:How To Reference Column Names, If Using Select * 3k



    Hi,

    How do i reference column names for outputting data, when using select *, and not aware of column names (and number of columns) in advance.

    Even if i could get column names in other vars. I'm new to CF so question may be silly.

    getting column names:-

    cfquery datasource="RTW_ORA" name="cn"SELECT COLUMN_NAME FROM ALL_COL_COMMENTS WHERE TABLE_NAME = '#meas#' /cfquery

    getting data:-

    cfquery datasource="RTW_ORA" name="cd"SELECT * FROM #meas#/cfquery

    How to output all the data?

    Any help would be highly appriciated!

    Thanks,

    Tushar Saxena

    DB:3.12:How To Reference Column Names, If Using Select * 3k

    This is awesome! Thanks a million! and sorry for replying late as i was OOO.
    It's OK.

  • RELEVANCY SCORE 3.11

    DB:3.11:How Do I Merge Columns But Keep The Content In Both? m3


    I'm using Numbers '09.If I have first names in column A and last names in column B...how do I combine both into column A to look like this: Last Name, First Name (ex: Doe, John)?Thanks,Mark

    DB:3.11:How Do I Merge Columns But Keep The Content In Both? m3

    m,Glad that did it for you. I promised examples and only delivered one. The other would be:=CONCATENATE(B, ", ", A)That's the function approach.Short attention span, I guess.Regards,Jerry

  • RELEVANCY SCORE 3.11

    DB:3.11:Chart Web Part - Lookup Columns Corrupted 7c


    Hello,

    I am using the chart web part, and if I reference the lookup column, which is last names, it posts both the last names and the number, such as:

    42; #LASTNAME

    How do I not have it display that number, semicolon and #?
    Thanks,

    DB:3.11:Chart Web Part - Lookup Columns Corrupted 7c

    Thanks again for the response.

    Could you give me a little more details? Right now, I'm using chart web part, using a list as source, and the issue is that on the legend, it shows the value of the lookup column plus the ID and the #. My end goal is just to only have the value
    show.

  • RELEVANCY SCORE 3.11

    DB:3.11:Table And Column Names With Spaces kf


    I have a customer using SQL Server with spaces in their table names and column names. I see that with Oracle 8i that I can create tables and columns with spaces in the names. I use JDBC to communicate with the database. I SQL Server I place the table names and column names in brackets [] to avoid errors in the SQL parser. How do I do such things in Oracle, the brackets don't seem to work.

    Thanks,
    J

    DB:3.11:Table And Column Names With Spaces kf

    Try putting double quotes around the table/column names.
    For example,
    select "some column" from "some table"

  • RELEVANCY SCORE 3.11

    DB:3.11:Get Max Value From Every Columns In A Telerik Radgridview In Silverlight. zd



    How do I get the max value of every columns of a dynamically created RadGridView in Silverlight?
    Now knowing how many columns, the name of the columns or even the data type in them?
    And turn them red when found?

    Thanks

    DB:3.11:Get Max Value From Every Columns In A Telerik Radgridview In Silverlight. zd

    Hi,
    Please try to iterate through the collection like so:
    foreach (GridViewColumn column in this.GridName.Columns)

    {

    // work with each column

    }

    In the iterate method, you could try to put each column data into a array, then yo could select the max value of each column.
    Besides, you could access the GridName.Columns[i] directly. For more details on working with the GridView, I would recommend you to check online documentation
    http://www.telerik.com/help/silverlight/gridview-overview2.html

    Best Regards,
    Qimin Ding

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.

    Click
    HERE to participate the survey.

  • RELEVANCY SCORE 3.11

    DB:3.11:How To Reference Columns Of Array Dynamically? 7p


    I have developed a sql query with a dynamic number of rows and columns. I know I can reference the rows by using a ' for i in 1..htmldb_application.g_f01(i) loop' and this is fine. I know that with a query with a standard number of columns you could reference them as htmldb_application.g_f02(i), htmldb_application.g_f03(i) and so on. However, in my case, I have a dynamic number of columns and they are in fact named f02, f03, f04 and so on. I could have 10 or I could have 15 of these. My problem is that now to get the values associated with these columns I have to dynamically determine the names of these columns through a string (ie mstring := 'htmldb_application.g_f0'||colnum||'(i)'') For each row I loop through and build this string which references each of the columns in my array. The problem is that this returns htmldb_application.g_f02(i) as the value and not the actual value of the field.
    I thought I could do 'select htmldb_application.g_f02(i) from dual' and then do an execute immediate statement to return the value but this returns an error saying something to the effect that the function does not exist. So without hardcoding the actual names is there a way to reference each of these columns dynamically?

    DB:3.11:How To Reference Columns Of Array Dynamically? 7p

    I'm curious if you found a way around this?

    For now, I've got giant case statements to grab the item and row of interest. It's a real pain and not very scalable.

    Thanks,

    Matt

  • RELEVANCY SCORE 3.10

    DB:3.10:How To Give Alias Name For Group Of Columns. 1a


    The below is the query to get Columns. But, i need to make single alias name to all the column which i get. I need to get column names also event, domain, entity, bpdid. Above columns should be under single alias name like 'baseMessage'. Please advise on this.

    select (select decode(ICKD_CHR_KY1_ID,'I','New','D','Cancelled','U','Modified') from ICKD where ICKD_APLN_ID = 'CSTCOM' and ICKD_NUM_KY1_ID = 1438227010) event, 'Client' domain, 'CustomerCommunication'

    DB:3.10:How To Give Alias Name For Group Of Columns. 1a

    The below is the query to get Columns. But, i need to make single alias name to all the column which i get. I need to get column names also event, domain, entity, bpdid. Above columns should be under single alias name like 'baseMessage'. Please advise on this.

    select (select decode(ICKD_CHR_KY1_ID,'I','New','D','Cancelled','U','Modified') from ICKD where ICKD_APLN_ID = 'CSTCOM' and ICKD_NUM_KY1_ID = 1438227010) event, 'Client' domain, 'CustomerCommunication'

  • RELEVANCY SCORE 3.10

    DB:3.10:How Can I Get The Columns Names Related To A Uniqueconstraint c8


    I know that I can get all UniqueConstraints in a database by using
    select * from sysobjects where xtype='UQ'
    And by using the parent_obj column I can get the information of where those UniqueConstraints do belong. The problem is that UniqueConstraints might be related to several columns at once. How can I get the columns that a UniqueConstraint is related to and/or reverse engineer the UniqueConstraint itself and access the SQL script to create/modify the constraint, so that I can pick the related coılumns myself.

    Regards.Utku Ozan ANKAYA

    DB:3.10:How Can I Get The Columns Names Related To A Uniqueconstraint c8

    Thank you very much for the code. It works just fine.
    And Miloslav, also very much for your code too. It also worls but additionally it brings the PrimaryKey's UniqueConstarint as a UniqueConstraint as well.

    Thank you all very much for your support.

    Regards.Utku Ozan ANKAYA

  • RELEVANCY SCORE 3.10

    DB:3.10:How To Pass A List Of Ids To A Stored Procedure ? 13


    Hi All,
    My table has two columns customerID (int) and customerName
    I want to write a stored procedure that will get a list of integers and then return all the customers names associated with these IDs. How to do that ?
    Thanks

    DB:3.10:How To Pass A List Of Ids To A Stored Procedure ? 13

    My favored way (dependent on the number of items to be passed) is comma separated values, picked up in the proc like this:
    declare @IDs varchar(200)

    set @IDs = '1,2,3,4,5,6,7,8'

    declare @List table (ID int)
    while charindex(',',@IDs) 0
    begin
    insert into @List (ID) values(left(@IDs,charindex(',',@IDs)-1))
    set @IDs = right(@IDs,len(@IDs)-charindex(',',@IDs))
    end
    insert into @List (ID) values(@IDs)

    select * from @List

  • RELEVANCY SCORE 3.10

    DB:3.10:Names Under Columns In Excel Charthow To Change 9a


    Hello, I have an assignment due tomorrow and I'm pulling my hair out trying to understand how to change the text under the columns in a chart.

    DB:3.10:Names Under Columns In Excel Charthow To Change 9a

    Try Right clicking, or Control Click . wait for pop up Context Menu to pop up And choose Choice for Data. when that menu opens you should be able to to change Labels.

    Go to Hep menu and type in Change Chart Labels.

    see what it says.

  • RELEVANCY SCORE 3.10

    DB:3.10:To Get The Column Names Of A Table. How? dd


    I want to use the JDBC API to get the names of all columns of a table.

    But I didn't find any method for my purpose. Can you tell me how to do it? Thanks

    DB:3.10:To Get The Column Names Of A Table. How? dd

    DatabaseMetaData meta = connection.getMetaData();
    ResultSet rs = meta.getColumns(null, null, 'TABLENAME', '%')
    while (rx.next())
    {
    System.out.println(rs.getString(4);
    }For details see
    http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html#getColumns(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String)

  • RELEVANCY SCORE 3.09

    DB:3.09:Custom Adv Search: Displaying Internal Attribute Names Instead Of Labels jx



    Hi,

    When I do "Adv Search" of a custom document, it is showing the internal names (like "inv_dt") of some columns (attributes) instead of their labels (like "Invoice Date"). I also noted that those wrongly displayed columns belong to the subtype of the searched custom document. How can I get those columns' labels being displayed instead of their internal names? Should I do some thing in the display configuration in the DAR file going through Composer? Should I look into some XML configuration file(s)?

    Note:I moved my Webtop 5.3 (CS5.3, Tomcat and SQL Server Windows environment) customizations to Webtop 6.7 (CS 6.7, Tomcat and Oracle DB on AIX).

    Please share your knowledge and experience.

    Thanks.

    ta

    DB:3.09:Custom Adv Search: Displaying Internal Attribute Names Instead Of Labels jx


    Hello,

    It has to be configured in the search60 component (introduced in Documentum 6.0). The steps are detailed in the Documentum System Search Development Guide (the same procedure is also available in the WDK Development guide):

    http://powerlink.emc.com/km/live1/en_US/Offering_Technical/Technical_Documentation/Documentum_67_Search_Development.pdf

    Regards,

    Annette

  • RELEVANCY SCORE 3.09

    DB:3.09:Column Names jz


    Hi,I have an Excel data sheet that I need to read and select the pertinent rows to load into a dataset. The data will then be checked against a database and the new data will be added. I have several questions/problems, the first of which has to do with Column names:My Excel sheets have column headers, BUT the header names are not located in the first row, rather they are located in the 5th row of the sheet, always. I would ignore this issue altogether and simply use column position as a locator for the data, but the sheets do not always have the same number of columns (ie sometimes columns are missing). Therefore I need to know which columns contain which data. How can I specify the columns such that the correct data get inserted into the correct columns in the DataSet, and ultimately the database?I am using an OleDB connection to get the data from the Excel table, and the extended properties of HDR=No to indicate that the first row is not a header row and IMEX=1 to read the columns as strings. (If I don't specify IMEX=1 then I can't read all of the values in row 5 (ie the true column names) correctly - some are null.) Help!Carrie

  • RELEVANCY SCORE 3.09

    DB:3.09:Cannot Display All The Columns s1


    Hi

    I am having this weird problem , i gave some selected columns in my select query and data displayed with the given conditions perfectly then i added some more columns , around 30 coloumns to my select query(initially i just tested by selecting 6-10 columns names) , and my report does not display data for all the columns , its just displaying the data for columns i previously selected , do i need to do something to get all the columns, is there a limit in Apex that report should display only fixed number of columns ?or do i need to refresh any where in order to adapt the changes i have made in my select query ?

    i have logout and logged in , but it did'nt work..

    Could any body please let me know what could be the reason for this?

    Thank you

    DB:3.09:Cannot Display All The Columns s1

    Just found out that the other columns were selected as Not Display in report in actions -select columns...

  • RELEVANCY SCORE 3.09

    DB:3.09:Ssis Script Component - I Dont Have A Clue! kz


    In the script component there is a Script Transformation Editor.
    It shows available input columns. I can check them all, but how do they
    all get put in as Output Columns? The script component needs to read the input columns
    and output all of them. So, let's say if there's 100 input columns I need 100 output
    columns. How do I get all these input columns to show up as output columns. Do I manually
    add 100 output columns and manually type all the names? That would not be desirable. But
    is that how it's done and if so why?
    And what does Usage Type do? The choices are ReadOnly or ReadWrite. The setting
    doesn't seem to matter from what I can tell.
    The purpose of the package is to read a MySQL table and output a SQL Server table so I have an ADO.NET source and an ADO.NET destination. Some columns need to be checked for bad data and fixed before the data gets to the destination. Sounds simple enough
    huh?

    I read some crazy documentation at
    http://msdn.microsoft.com/en-us/library/ms137640(v=SQL.100).aspx
    which discusses Script Component Modes but I don't see any option
    in the SSIS Designer to choose a mode. I am using version 2008 which
    matches this document. The document is useless since it does not tell
    you how to choose a mode.. assuming such a feature even exists.

    DB:3.09:Ssis Script Component - I Dont Have A Clue! kz

    I have several set as read/write but the columns aren't available at the output. That's the whole problem.

    update: I deleted the script transformation and started over from the beginning. For some odd reason it seems to be passing all the columns through now. So at this point, I don't have any problems.

  • RELEVANCY SCORE 3.08

    DB:3.08:How To Separate 1st And Last Names In 1 Cell (In Numbers) To 2 Cells 7f


    I have about 1000 names in a numbers spreadsheet with information in separate columns such as phone numbers etc.

    But the names, 1st and last, are in 1 cell with a space between them. How do I separate them into 2 cells?

    Thank you so much for your help

    DB:3.08:How To Separate 1st And Last Names In 1 Cell (In Numbers) To 2 Cells 7f

    Look at :
    http://discussions.apple.com/thread.jspa?messageID=13109185

    Yvan KOENIG (VALLAURIS, France) jeudi 17 mars 2011 10:53:30

  • RELEVANCY SCORE 3.08

    DB:3.08:Comparing Names In Columns j1


    I have two columns of names. How do I in a 3rd column see what names are missing? I want to see what names are in Column A that are not in Column B and then I want to run it the other way B to A.
    Thanks
    Cheyenne

  • RELEVANCY SCORE 3.08

    DB:3.08:Rows And Columns s9



    After I have downloaded the PDF to excel how do I get the lines for the columns and rows?

    DB:3.08:Rows And Columns s9


    Good day,

    I'm not sure what you mean. Could you describe what has happened in some greater detail?

    Kind regards,

    David

  • RELEVANCY SCORE 3.08

    DB:3.08:Jtable Column Names ck


    Hi, how can I change the names of the columns of a JTable that gets its data from a database;

    DB:3.08:Jtable Column Names ck

    Thanks mate, but I cannot use this constructor since my table automaticaly gets its data (what you declare as rowData) from an external database.
    I found the solution to my problem to the next lines of code...

    JTable table = new JTable;
    TableColumnModel tcm = table.getColumnModel();
    TableColumn tc = tcm.getColumn(0);
    tc.setHeaderValue( "ABC" );

    thanks anyway

  • RELEVANCY SCORE 3.08

    DB:3.08:Converting Multiple Columns To Rows 1a


    i want to convert multiple columns to rows
    eg: product1 product1 product3
    1 2 3
    now if we have to have all the column names into 1 column and their respective values into another column, how do we do it

  • RELEVANCY SCORE 3.08

    DB:3.08:Missing Info In Formscentral Repsonses f7



    When I view responses in FormsCentral, the field names are missing on the top of the columns. How do i get them back?

    DB:3.08:Missing Info In Formscentral Repsonses f7


    Yup. That's exactly what I did - deleted them by accident. I Put them back manually also.

    Thanks for responding,

    Josh

  • RELEVANCY SCORE 3.08

    DB:3.08:Can Two Columns Have The Same Display Names But Different Underlying Names? xc


    I have two columns which are set up differently. But for a display purpose and different usage, they shouldshare the samedisplay names but not the underlying name. How may I set them up in SharPoint?

    DB:3.08:Can Two Columns Have The Same Display Names But Different Underlying Names? xc

    Hey PMA,
    In SharePoint Designer you can convert the list to a DataView web part. Once this is done the columns can have different actual names but the same display names. More information is available here:
    http://blog.pathtosharepoint.com/2008/08/24/your-first-data-view-web-part/
    http://www.sharepoint-tips.com/2007/05/sharepoint-designer-article-2-creating.html

    I hope that helps!Tom Molskow SharePoint Architect

  • RELEVANCY SCORE 3.07

    DB:3.07:How To Use Ctx_Ddl Package? 3p


    Hello,
    I have a table as below, and I want to index on Names Address columns.
    create table MyTable (id number primary key, names varchar2(20), address varchar2(80));

    How can I use the package CTX_DDL to create a index on many columns? Please show me the way I can assign my index on my table.
    begin
    ctx_ddl.create_preference('MyIdx','MULTI_COLUMN_DATASTORE');
    ctx_ddl.set_attribute('MyIdx', 'columns','names,address');
    end;

    Many thanks.

    DB:3.07:How To Use Ctx_Ddl Package? 3p

    please see my reply to your later question in this forum

  • RELEVANCY SCORE 3.07

    DB:3.07:How To Run A Loop For All Columns In Script Component Input Column Collection For Each Row fp


    Hi All,
     
    I want to run a loop for all the input columns in the script component. My requirement is, I have nearly 50 columns in the input columns list. For each row and for each column I need to do some operation. How Can I run a loop for each column. Please note in the script component I need to get the column names in the middle for some operations. Please see below.
     
    Process Each Input Row 

     For each column in Input column list  ....  ....  If column.Name Starts with Test then set NULL to the column value  ....  .... End Loop
    End Loop for each input row
     
    Can anybody tell me how can I do that.
     
    RegardsVenkat.

    DB:3.07:How To Run A Loop For All Columns In Script Component Input Column Collection For Each Row fp

    Here's a few other options:
    http://agilebi.com/cs/blogs/jwelch/archive/2007/10/20/address-columns-generically-in-a-script-task.aspx
     

  • RELEVANCY SCORE 3.07

    DB:3.07:How Do I Make Vista Folders Always Size All Columns To Fit px


    Our company uses long file names, and typically the files have similar names. Because of the default Vista view of file names it cuts off the last part of the file name, and I constantly have to right click and select "Size All Columns to Fit" in each
    folder I open.

    How can I make this a permanent default option?

    Please help! Thanks

    DB:3.07:How Do I Make Vista Folders Always Size All Columns To Fit px

    Look at this site.
    It worka for me.
    http://www.vistax64.com/tutorials/70819-windows-explorer-folder-view-settings.html

  • RELEVANCY SCORE 3.07

    DB:3.07:How To Find Table Names Using Column Names d3


    Hi,

    From which tables can I get the following columns in AR
    Unscheduled Revenue
    Revenue
    Line Amount
    Line Number
    and whats the way of finding out table name from column name

    Best Regards

    DB:3.07:How To Find Table Names Using Column Names d3

    914618 wrote:
    Hi,

    From which tables can I get the following columns in AR
    Unscheduled Revenue
    Revenue
    Line Amount
    Line Number
    and whats the way of finding out table name from column name

    Best RegardsPlease see old threads for similar topic/discussion -- https://forums.oracle.com/forums/search.jspa?threadID=q=Column+AND+Table+AND+NameobjID=c3dateRange=alluserID=numResults=15rankBy=10001

    You can also refer to eTRM website -- http://etrm.oracle.com/

    Thanks,
    Hussein

  • RELEVANCY SCORE 3.07

    DB:3.07:Update All Columns In Table d7


    HiI want to do something like this:
    UPDATE

     

    tblTableA SET B.* = A.* FROM tbTableB AS A INNER JOIN tblTableA AS B ON A.MyLink= B.MyLink WHERE B.UpdateMe = 1I won't know the column names but the columns from TableA and TableB will always be exactly the same.  I know I can't do B.* or A.*, but hopefully you get the idea.Any help on how I can do this?  Dynamic SQL the only way to do it?Cheers

    DB:3.07:Update All Columns In Table d7

    I thought you meant FROM is sometimes required for a DELETE statement as that is what we're talking about.  Which is why I posted the statement from MSDN about DELETE saying FROM is optional.Going round in circles here.  Cheers

  • RELEVANCY SCORE 3.07

    DB:3.07:Ssis Derived Columns 78


    I am trying to read the data from a flat file source. But, it is reading a single column as two columns and I want to bring the data together from 2 columns into 1 by using the derived columns option. But, when I try to map them, it gives me an error saying
    The columns cannot be matchedusing the names. try to match them appropriately from the list of available columns.
    My question is how do I do it manually ?

    DB:3.07:Ssis Derived Columns 78

    Not without more information.
    Basically, you just have to place a cast operator in front, like:
    (DT_DBTIMESTAMP)([col1] [col2])

    Talk to me now on

  • RELEVANCY SCORE 3.07

    DB:3.07:Add Columns To A Datagrid In C# am


    Hi all,
    I have a windows form with a datagridview in c#. I set the datasource using a dataTable. In this dataGridView there are no columns. when I set the datasource it dispalys the grid with database column names. Now I add two columns to the gridview using 'Columns'
    property. The problem I have is, the newly added columns display with empty values and table columns are displaying after the new columns. i.e. now the grid has four columns. I want to display my table details for manually added columns.
    How may I do this?
    Please help

    DB:3.07:Add Columns To A Datagrid In C# am

    HI all,
    Thank you for your help. This is very helpful.
    Best regards

  • RELEVANCY SCORE 3.07

    DB:3.07:Columns Validation In Ssis 93


    Hi,
    I am developing a SSIS package to import excel sheet. If mandotroy columns in excel sheet are missing values, I want to capture the names of columns, and log them in db.
    The part I am not sure is that How I can capture the names of the columns which fail the validation.
    Thanks,alexwang

    DB:3.07:Columns Validation In Ssis 93

    what did you do can you tellus?
    can we see any snap shot of your work or by any chance can we see the package? (without the confidential information off-cource)
    can we ?Sincerely SH -- Please kindly don’t forget to mark the post(s) that answered your question and/or vote for the post(s)

  • RELEVANCY SCORE 3.06

    DB:3.06:How To Remove The Column Alias Names ss



    Hi all,

    I am using teiid 7.6 with some patches applied.

    I have a SQL Select name, age, salary from employee.

    When I run this sql against teiid I get the following SQL in my custom translator

    Select g_0.name AS c_0, g_0.age AS c_1, g_0.salary AS c_2 from employee as g_0

    I do not want the alias names to be applied the columns. Is there any way that we can tell teiid not to add the Alias names to the columns?

    Thanks,

    Rakesh.

    DB:3.06:How To Remove The Column Alias Names ss


    Hi Steven,

    Our translator should support select expressions and inline views as there are many SQL's which gets executed through this translator.

    Also, I think we need to make changes in our translator to support this.

    The SQL which we get in the translator has some extra columns and we need to remove those columns from the SQL before passing it to our product which executes it and returns the results.

    My translator extends the ExecutionFactory. I have a regular expression which checks the SQL and removes the unnecessary columns from the SQL.

    Thanks,

    Rakesh

  • RELEVANCY SCORE 3.06

    DB:3.06:Ts4147 My Contacts Have Lost All The Names 9z


    how do i get names to my contacts

  • RELEVANCY SCORE 3.06

    DB:3.06:I Need To Join Multiple Columns With Different Names. m9



    Good afternoon, I have a sistuao and need the help of Lords. I need to join multiple columns with different names. How to do this? example: Column A (data 1, 2.3) Column B (figures 2,4,5) Column C (data 6.7) Column D (Data 8) results 1 2 3 4 5 6 7 8 How to do this in a Load? test: A, B, C, D The Results Resident Test;

    DB:3.06:I Need To Join Multiple Columns With Different Names. m9


    My colleague, Thank you for your attempt to help. I resolved my problem using the For command and Next See the post below: http://community.qlik.com/message/128861 # 128861 Either way thank you

  • RELEVANCY SCORE 3.06

    DB:3.06:Get Columns Names From Table And Pass Parameters Dynamically dj


    I am trying to figure out how to do this or if it is even possible. I believe it should be, I have about 20 different tables with different amounts of columns in each table. I.E. One table might only have 4 columns while another might
    have 30 columns. What I am trying to do is create 1 sub/funtion that will handle the select and import for all 20 different tables, unfortunately for me I can't seem to figure out how to write this.
    I know the select statement for getting the column names is :

    SELECT column_name FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = table

    DB:3.06:Get Columns Names From Table And Pass Parameters Dynamically dj

    Hi Tmac,
    Welcome to the MSDN Forum.
    Based on your description, it seems that you want to add dynamic columns in your insert statement. This means you will insert some data in column A, column B or column Cthe same table.
    If so, please take a look at this thread:
    Importing DataRows Column By Column
    In that thread, the columns will be chose on UI by user. So the sql statement willbe generated dynamically.
    This should be what you are looking for.
    Best regards,Mike Feng [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 3.05

    DB:3.05:Anyway To Change The Xml Element Name pz


    I grab my data from Answers and most of the time the actual columns are combinations of other columns (metrics). when I pull this into Publisher the names given to these columns (for lack of a better term) is the formula used to get this data in Answers. This leads to huge column names or xml element names. Usually too much to read easily. Is there someway to mask the column names to something usable.
    Example
    formula and how it shows up in Publisher:
    (Finance.TotalIncome-(Finance.operating_expense-Finance.CEOKickback-Finance.GenericCorruption))*(Finance.EnronFudgeFactor)
    Column Name I would rather have:
    NetProfit

    Now imagine have to do something with the way the formula is set. Or even just trying to setup a report when your fieldname is 1000 characters long but your column title 10characters.

    DB:3.05:Anyway To Change The Xml Element Name pz

    Unfortunately I am using Publisher 10.1.3.4 and BI/Answers 10.1.3.4

    And I just had my first serious problem with not being able to change the names.
    If two reports with the same metric formula (Column) are used in the same publisher report the first metric value will always be used.
    I am posting this as bug/how do I get around this.

  • RELEVANCY SCORE 3.05

    DB:3.05:How To Get Column Names And Sizes From Db px


    hai java guys
    how to get column names and sizes of columns from database

  • RELEVANCY SCORE 3.05

    DB:3.05:Create Tables Using Ssis Package... Please Help.. sc


    This is What I'm trying to do...1. Read the database and get table names and Attributes.2. Create table using those names and Attributes.
    for example:  There is a table called TabletobeCreated it contains 3 columns.
     ID, TableName and Column names
     
     This table contains 3 data records.  Then Loop 3 times to get table names and Column names, after that  create three tables.
     
    Is this possible using SSIS Package?
     
    If possible what tasks should I use..?
     
    Thanks in advance...

    DB:3.05:Create Tables Using Ssis Package... Please Help.. sc

    Thanks for your help.
     
    Actually problem didn't came up afterwards... I didn't do anything but restarted the computer....
    and the datatypes were same..and the databases were same....but it executed successfully.. 
     
    Then I changed my Int16 datatypes to the Int32 as you (Todd McDermid) instructed to hold values larger than 32767....
    And it did execute successfully.
     
    Since then its working without any problems....  
     
    Thanks again...!!!

  • RELEVANCY SCORE 3.05

    DB:3.05:How To Shred Column Names As Well As Data From The Xml d8


    Hi,
    I have a XML which has a header group with column names and a data group with the actual data belonging to those columns.
    I need to shred this xml intoa table with those column names and corresponding data.
    The column names and data do not share the same tags so there is no way to relate them to each other.
    keep in mind the column names are variable and can change.

    thanks in advance.

    DB:3.05:How To Shred Column Names As Well As Data From The Xml d8

    Thanks for the reply Sathya.
    for now i have found a workaround the problem by changing the way i am getting the data but i will come back to this and try your solution.
    it seems like it should work.

    Thanks a lot !

  • RELEVANCY SCORE 3.05

    DB:3.05:Show Tables And Column Names Of Views c1


    i have several thousand views in a database and needing analysis.

    it is ideal to list the tables and respective columns together used by a view.

    i have found a way to list all columns. how do i list the view name, table name and column name?

    thanks.

    DB:3.05:Show Tables And Column Names Of Views c1

    Sorry, I use "*" as short hand for ALL_, USER_, and DBA_. ALL_ views show all that you have access to. USER_ views show all that you own, and DBA_ (you need privileges to see these) show you everything in the database.

    Now, Saubhik,

    "USER_UPDATABLE_COLUMNS" ? I just learned something new. Thanks!

  • RELEVANCY SCORE 3.05

    DB:3.05:How To Add A Line Feed To Column Headers On A Csv k9


    I have a report that I want to produce in a CSV format (Comma Delimited). I have changed the necessary parameters and I do get CSV file, however, the columns names and the first line of data appear on the same line. There is no line feed at the end of the column names. My column names are printing in "Header Section" of the report. If I include the column names in the "Main Section" of the report then they repeat for every record. Any ideas??

    DB:3.05:How To Add A Line Feed To Column Headers On A Csv k9

    don't use the column names generated by oracle, instead, use a sql to generate these column_names
    example:
    query 1
    select 'NAME', 'Address', 'Phone'
    from dual;

    query2
    select name, address, phone
    from real_table;

  • RELEVANCY SCORE 3.05

    DB:3.05:Remove Duplicates In A Query 8j


    I have two columns...

    The first columns have machine names and the second column is the user who owns that machines

    I would like to run a query that deletes all the dups...keeping only one of them.
    So if you have four machine names and four of the same user names. I want it to find all the machine names and delete all except for one.

    How do I do that?

    I did a query wizard "find match" but it wont keep one of each.

    DB:3.05:Remove Duplicates In A Query 8j

    Duh! I was naming the query not the table. Back to basics! Thank you so much!

  • RELEVANCY SCORE 3.05

    DB:3.05:How To Do A Group By Count Across Columns In Sql c3


    I have an sql database that has multiple fields of names (user can put enter up to 10 names). I need to be able to get a count on how many times each name apepars but do it across all10 columns(the same name could appear in any of the columns).
    Isuppose I could create a temp table and writeseveral queriesto append each name to one field in the temp table and then do a count from that table but somehow I figure there's got to be an easier way. If anyone has an idea/code that will
    accomplish this I would be most grateful.

    Thanks.

    DB:3.05:How To Do A Group By Count Across Columns In Sql c3

    If you're using SQL Server 2005 or higher:

    ;with cteNames as (select Name, [NameColumn] from NamesTable

  • RELEVANCY SCORE 3.05

    DB:3.05:How To Compare The Names And Types Columns Of Two Tables? fz


    Assume I have two tables aaa and bbb

    How do I compare the columnnames and types of the two columns?

    It should not matter if one of them has e.g. an additional index.
    Furthermore it does not matter if the rows/row values differ.

    Peter

    DB:3.05:How To Compare The Names And Types Columns Of Two Tables? fz

    You have to use ALL_TAB_COLUMNS for this:

    SQL with t1 as
    2 (select column_name, data_type, data_length, data_precision, data_scale, nullable from all_tab_columns where table_name='EMP' and owner='MAXR'),
    3 t2 as
    4 (select column_name, data_type, data_length, data_precision, data_scale, nullable from all_tab_columns where table_name='EMP2' and owner='MAXR')
    5 Select a.column_name, a.data_type, decode(a.data_precision, null, '('||a.data_length||')', '('||a.data_precision||','||a.data_scale||')') length,
    6 b.column_name, b.data_type, decode(b.data_precision, null, '('||b.data_length||')', '('||b.data_precision||','||b.data_scale||')') length,
    7 a.nullable, b.nullable
    8 from t1 a full outer join t2 b on a.column_name=b.column_name;

    COLUMN_NAME DATA_TYPE LENGTH COLUMN_NAME DATA_TYPE LENGTH N N
    ------------ --------- ---------- ------------ --------- ---------- - -
    EMPNO NUMBER (4,0) EMPNO NUMBER (4,0) N N
    ENAME VARCHAR2 (10) ENAME VARCHAR2 (10) Y Y
    () NEWCOL NUMBER (22) Y
    MGR NUMBER (4,0) MGR VARCHAR2 (10) Y Y
    HIREDATE DATE (7) HIREDATE DATE (7) Y Y
    SAL NUMBER (7,2) SAL NUMBER (7,2) Y Y
    COMM NUMBER (7,2) COMM NUMBER (7,2) Y Y
    DEPTNO NUMBER (2,0) DEPTNO NUMBER (2,0) Y Y
    JOB VARCHAR2 (9) () Y

    9 rows selected.Max
    http://oracleitalia.wordpress.com

  • RELEVANCY SCORE 3.05

    DB:3.05:Resultset Jtable k8


    Following the tutorial at:
    http://java.sun.com/docs/books/tutorial/uiswing/components/table.htm

    I have got a resultset from a database and have following code:

    String[] columnNames;
    ResultSetMetaData md = rs.getMetaData();
    int columns = md.getColumnCount();
    // Get column names
    for (int i = 1; i = columns; i++) {
    HOW DO I ADD THE COLUMNNAMES TO THE String[] columnNames
    }

    Object[][] data;
    while (rs.next()) {
    Vector row = new Vector(columns);
    for (int i = 1; i = columns; i++) {
    row.addElement( rs.getObject(i) );
    }
    // add row to data
    HOW DO I DO THAT ?
    }

    WOULD BE NICE TO GET THE CODELINES.

    DB:3.05:Resultset Jtable k8

    Following the tutorial at:
    http://java.sun.com/docs/books/tutorial/uiswing/components/table.htm

    I have got a resultset from a database and have following code:

    String[] columnNames;
    ResultSetMetaData md = rs.getMetaData();
    int columns = md.getColumnCount();
    // Get column names
    for (int i = 1; i = columns; i++) {
    HOW DO I ADD THE COLUMNNAMES TO THE String[] columnNames
    }

    Object[][] data;
    while (rs.next()) {
    Vector row = new Vector(columns);
    for (int i = 1; i = columns; i++) {
    row.addElement( rs.getObject(i) );
    }
    // add row to data
    HOW DO I DO THAT ?
    }

    WOULD BE NICE TO GET THE CODELINES.

  • RELEVANCY SCORE 3.05

    DB:3.05:Cqwp - Fields To Display z1


    Hi,
    I would like to get more than one columns on my CQWP for a list. However when I enter the names of the columns in the list in
    Fields to display:
    Title: SupportName; BusinessName
    Only supportName column values are displayed, how do I get the rest of the columns???Sharepoint Dummy

    DB:3.05:Cqwp - Fields To Display z1

    Hi,
    Only the first non blank column value is displayed when youmap the multiple column names in the Fields to display slot.
    Check :
    http://www.sharepointblog.co.uk/2012/05/fields-to-display-in-content-query-web-part/Ashish Mishra MCTS, MCPD in SharePoint 2010

  • RELEVANCY SCORE 3.04

    DB:3.04:How Do I Filter Two Columns Of Names To See What Names Are The Same? c1


    I have two lists of names (one with 2,000+ names and one with 300+ names) I want make a column that shows the names that are not in both columns and the names that are. Is there an automated way of doing this? Basically, I have 2,000 friends on facebook and only 300 of them like my business page. I want to know which friends to market too and which friends to stop annoying Any help would be greatly appreciated!

    DB:3.04:How Do I Filter Two Columns Of Names To See What Names Are The Same? c1

    Thanks a ton! That's exactly what I wanted About 90% of my comp knowledge comes from people like you contributing to forums like this so thanks a ton!

  • RELEVANCY SCORE 3.04

    DB:3.04:How Can I Merge Columns So That The Numbers For The Same Names Are Automatically Consolidated 7k


    I have two columns- one with names and one with numbers corresponding to them, if there are duplicate names how can I merge them so that the numbers for the same names are automatically consolidated?

    DB:3.04:How Can I Merge Columns So That The Numbers For The Same Names Are Automatically Consolidated 7k

    Hi,

    By consolidating numbers, if you mean SUM(), then try this

    1. Select the two column dataset (including header row) and go to Insert Pivot Table Finish
    2. Drag Name to Row labels and Numbers to Data area

    Hope this helps.