• RELEVANCY SCORE 3.73

    DB:3.73:Copy Only Rows Based On Unique Value In One Column And Paste Them To Another Worksheet Where The Worksheet Name Equals Column Value zp




    I have multiple worksheets in one shared folder. There is one master worksheet but I need to break that out into separate worksheets based on each unique value in a column named ModCategory (column V). So if I were to determine the unique values in this
    column by using this piece of code:

    Columns("A:BO").Select
    Columns("A:BO").EntireColumn.AutoFit
    Range("V2").Select
    'extract a list of unique ModCategory in this column
    ws1.Columns("V:V").Copy _
    Destination:=Range("BQ1")
    ws1.Columns("BQ:BQ").AdvancedFilter _
    Action:=xlFilterCopy, _
    CopyToRange:=Range("BP1"), Unique:=True
    r = Cells(Rows.Count, "BP").End(xlUp).Row
    'set up Criteria Area
    Range("BQ1").Value = Range("V2").Value

    In the end what I would like to do is extract only the rows for each unique value found, copy those rows and columns (A:BO) to another worksheet within that same shared folder where first two characters of that worksheet equal the unique values found in
    the master worksheet. This would loop through until all the worksheets in that folder have been found and rows have been copied into each one.

    DB:3.73:Copy Only Rows Based On Unique Value In One Column And Paste Them To Another Worksheet Where The Worksheet Name Equals Column Value zp

    I assume that there are no empty cells in the column "ModCategory" and each unique value could be used as filename.
    I also assume that your headings are in the first row.

    Copy the code below into a normal module.

    Andreas.

    Option Explicit

    Sub Main()
    Dim R As Range
    Dim Items
    Dim i As Long, c As Long
    Dim WB As Workbook
    'Supress messages from "SaveAs" dialog
    Application.DisplayAlerts = False
    'Screen off, runs faster
    Application.ScreenUpdating = False
    'The current sheet must contain the column
    With ActiveSheet
    'Find the column "ModCategory"
    Set R = .Rows(1).Find("ModCategory", LookIn:=xlValues, LookAt:=xlWhole)
    If R Is Nothing Then
    MsgBox "Column ""ModCategory"" not found."
    Exit Sub
    End If
    'Get the column number
    c = R.Column
    'Build the unique items
    Items = UniqueItems(R.EntireColumn)
    'Be sure the filter is off
    If .FilterMode Then .ShowAllData
    'For each item except the header
    For i = 1 To UBound(Items)
    'Set the autofilter
    .Range("A1").AutoFilter c, Items(i)
    'Get the visible cells
    Set R = .AutoFilter.Range.SpecialCells(xlCellTypeVisible)
    'Create a new file with only one sheet
    Set WB = Workbooks.Add(xlWBATWorksheet)
    'Copy the cells
    R.Copy Cells(1, 1)
    'Save and close it
    WB.Close True, ThisWorkbook.Path "\" Items(i)
    Next
    End With
    Application.DisplayAlerts = True
    Application.ScreenUpdating = True
    End Sub

    Private Function UniqueItems(ByVal R As Range, _
    Optional ByVal Compare As VbCompareMethod = vbBinaryCompare) As Variant
    'Return an array with all unique values in R
    Dim Area As Range, Data
    Dim i As Long, j As Long
    Dim Dict As Object 'Scripting.Dictionary
    Set R = Intersect(R.Parent.UsedRange, R)
    If R Is Nothing Then
    UniqueItems = Array()
    Exit Function
    End If
    Set Dict = CreateObject("Scripting.Dictionary")
    Dict.CompareMode = Compare
    For Each Area In R.Areas
    Data = Area
    If IsArray(Data) Then
    For i = 1 To UBound(Data)
    For j = 1 To UBound(Data, 2)
    If Not Dict.Exists(Data(i, j)) Then Dict.Add Data(i, j), 0
    Next
    Next
    Else
    If Not Dict.Exists(Data) Then Dict.Add Data, 0
    End If
    Next
    UniqueItems = Dict.Keys
    End Function

  • RELEVANCY SCORE 3.29

    DB:3.29:Copying A Row From Worksheets Based On Value In Third Worksheet ms




    I have two worksheets "FileMakerPro" and "Skyward" with data in column A of both worksheets. The third worksheet "Unique" contains only the unique values found in column A of both worksheets. What I am trying to do in VBA is compare the value found in the
    first row of the "Unique" worksheet, find the matching value in either of the two other worksheets and then copy that matching rows contents and then replace the "Unique" worksheets rows values from the other worksheet. For example:

    If A1 of the Unique worksheet contains the number 250, and that number exists in the FileMakerPro worksheet, , replace the Unique!A1 with the row contents of FileMakerPro. Here is the code I have so far:

    Sub getAndCopyRows()
    Dim bottomD As Integer
    Dim c As Range
    Dim ws1 As Worksheet
    Dim ws2 As Worksheet
    Set ws2 = ThisWorkbook.Worksheets("Unique")

    For Each ws1 In Sheets(Array("FileMakerPro", "Skyward"))
    ws1.Activate
    bottomD = Range("A" Rows.Count).End(xlUp).Row
    For Each c In Range("A1:A" bottomD)
    For Each ws2 In Sheets
    If ws2.Name = c Then
    ws2.Activate
    c.EntireRow.Copy Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
    End If
    Next ws2
    Next c
    Next ws1
    End Sub

    Thank you for your help.

  • RELEVANCY SCORE 3.07

    DB:3.07:Display Only Unique (Distinct) Items In A Custom List View Based Upon A Field Using Xsl 91




    Good afternoon,
    I am trying to unlock the powers of xls formatting.
    At the moment I am trying to only display the first list item that contains a distinct value in a field.

    I created a custom list and added a field Filtered to it that.
    I used this:
    xsl:template

    match=/ xmlns:SharePoint=Microsoft.SharePoint.WebControls
    xmlns:__designer=http://schemas.microsoft.com/WebParts/v2/DataView/designer
    xmlns:asp=http://schemas.microsoft.com/ASPNET/20
    xsl:variable name=unique-list
    select=/dsQueryResponse/Rows/Row[not(@Filtered=following::Row/@Filtered)]

    /
    xsl:for-each select=$unique-list
    xsl:value-of select=@Filtered /
    /xsl:for-each
    /xsl:template

    DB:3.07:Display Only Unique (Distinct) Items In A Custom List View Based Upon A Field Using Xsl 91

    Hello,
    I may have been a little unclear in what I am trying to do, exactly.
    I have a data view of a list that displays a couple of columns from the list. However, most of the data is repeated (the columns with distinct values have been removed form this view of the list). I would like to display the list with no repeating data.
    I did manage to do that, using the xsl code above,but it broke the rest of the formatting, removed all of the columns and displayed the distinct/ unique values next to each other.

  • RELEVANCY SCORE 3.05

    DB:3.05:Conditionally Adding Rows mx


    I have cell A1 as a list of numbers. In row 8 there is start information that pertains to the value of A1. How could I conditionally add rows that have their own formatting below row 8 based on the value of A1?

    I.E- If A1 equals 5, then there would be 4 new rows added below row 8 with their own unique formatting. If A1 equals 10, then there would be 9 new additional rows.

    DB:3.05:Conditionally Adding Rows mx

    One method would be this macro.

    TapAlt+F11and when the VBE opens, immediately use the pull-down menus toInsert, Module. Paste the following into the new pane titled something likeBook1 - Module1 (Code),

    Sub mcrInsRowsA1()

  • RELEVANCY SCORE 3.02

    DB:3.02:Copy Only Visible Rows dk



    I have a sheet with a list (rows) of customers. Some rows are hidden because they are inactive. When I try to copy and paste the visible rows to another sheet it copies all rows (includingthe hidden rows). How do I prevent copying the hidden
    rows?

    DB:3.02:Copy Only Visible Rows dk

    Also on 2003 when pasting I have to paste using paste special 'xml spreadsheet'

  • RELEVANCY SCORE 2.99

    DB:2.99:Does Autonumberhash256 Create Unique Values Based On Its Composing Fields? 9c



    Hi,

    Does anybody know if the autonumberhash256 function returns unique values for the same input fields? Its the definition of hashing, I know, but I seem to get sequential values!

    I use it somewhat like this:

    I have two tables (one for BUDGET and one for SALES) I store in two qvd, and before I store them I create this concatenated PK in both tables (this is done in different qvw):

    autonumberhash256(MONTH_ID, STORE_ID, SUPPLIER_ID, BRAND_TYPE, CATEGORY_ID)as PK_BUDG
    When I load them in another qvw I need to find out what exists in one table that doesn't exist in the other:

    Budget_Temp:LOAD PK_BUDG,MONTH_ID,STORE_ID,SUPPLIER_ID,BRAND_TYPE,CATEGORY_IDFROM $(srcFile_Budgets) (qvd)WHERE NOT EXISTS (PK_BUDG); //everything that has budget but not sales

    This fetches 0 lines (vs not using autonumberhash256() and just concatenating the fields for the PK, which fetched about 5M rows). What happens is: the SALES table has two years of sales and the PK begins in 2008-01 whilst the BUDGET table has only 1 year and the PK begins in 2009-01. I've peeked the first lines of each table stored to qvd and I reallized the PK seems sequential (beginning in 1, 2, 3,...(...) for 2008-01 in sales qvd and beginning in 1, 2, 3,...(...) for 2009-01 in budget qvd).

    The sales table has about 130 million rows and the budget table has about 12 million rows so thats why it makes a huge difference when I use the autonumberhash!

    Anyone has any ideas why this happens? Shouldn't I get an unique value instead of a sequential one? I've searched the forum and got nothing about this.

    Thanks in advance,

    Marina Carvalho

    DB:2.99:Does Autonumberhash256 Create Unique Values Based On Its Composing Fields? 9c


    Hi,

    I already got feedback on this and it seems that the returned value will always be sequential unless the loading of the two tables is in the same qvw.

  • RELEVANCY SCORE 2.94

    DB:2.94:Filter Rows Based On Column Value Mdx a9



    I have this query.

    SELECT {
    [Buckets].[Header].members
    }
    on columns,
    {crossJoin([Customers].Members,[Account].members, [Measures].[Summary_Value])}
    ON rows
    FROM [CAPA]

    That returns the following results.

    I need to filter this so that only rows that have a value greater than 0 in the 10% cross age show up.

    DB:2.94:Filter Rows Based On Column Value Mdx a9

    Youcan get your result with Filter function. From your query I understand that 10% cross age is a member in Bucket dimension.
    So you have to use a query like this(i tested this on adventure works)
    select [Date].[Calendar Year].Members on 0
    ,Filter(
    CrossJoin([Product].[Category].Members,[Measures].[Sales Amount]),
    ([Date].[Calendar Year].[2006])100000
    ) on 1
    from [Adventure Works]
    HTH.

  • RELEVANCY SCORE 2.92

    DB:2.92:Tip: Unique Constraint On Part Of Table x9


    Here's a cute little trick I picked up from where it was hiding deep within one of the manuals:

    Consider a table where one column needs to be unique, but only part of the time based on some condition within the row. For example, col1 must be unique when its value is above 1000 but any number of rows can have the same value for col1 when it is 999 or less. Another example would be a flag column that determines that col1 must be unique. Don't ask me WHY you would do either of these things.

    Here's how to accomplish the first example (btw both examples require a PK on the table):
    CREATE TABLE junk(
    junk_key INTEGER NOT NULL,
    col1 INTEGER NOT NULL,
    CONSTRAINT pk_junk PRIMARY KEY(junk_key)
    );

    --The way we accomplish this is with a function-based index.
    CREATE UNIQUE INDEX idx_semiuniq ON junk(
    CASE WHEN col1=1000 THEN TO_CHAR(col1) ELSE '~' || TO_CHAR(junk_key) END);

    --The following statements should succeed:
    insert into junk values(1,1);
    insert into junk values(2,1);
    insert into junk values(3,1000);
    insert into junk values(4,1001);
    update junk set col1=1002 where junk_key=4;
    --The following statements should fail:
    insert into junk values(5,1000);
    update junk set col1 = 1001 where junk_key=1;

    The same strategy applies to the second example, except that in this case we'll need an additional column to indicate that col1 needs to be unique:

    CREATE TABLE junk( junk_key INTEGER NOT NULL,
    col1 INTEGER NOT NULL,
    uniq_flag CHAR(1) NOT NULL,
    CONSTRAINT pk_junk PRIMARY KEY(junk_key),
    CONSTRAINT ck_junk CHECK (uniq_flag IN ('Y','N'))
    );

    CREATE UNIQUE INDEX idx_semiuniq ON junk(CASE WHEN uniq_flag = 'Y' THEN TO_CHAR(col1) ELSE '~' || TO_CHAR(junk_key) END);

    --these should succeed:
    insert into junk values(1,1,'N');
    insert into junk values(2,1,'N');
    insert into junk values(3,1,'Y');
    insert into junk values(4,2,'Y');
    --these should fail:
    insert into junk values(5,2,'Y');
    update junk set uniq_flag='Y' where junk_key=2;

    Another way to accomplish this is with a "not exists" in a check constraint, but I think the function-based index will perform better especially when inserting or updating large numbers of rows.

    DB:2.92:Tip: Unique Constraint On Part Of Table x9

    Here's a cute little trick I picked up from where it was hiding deep within one of the manuals:

    Consider a table where one column needs to be unique, but only part of the time based on some condition within the row. For example, col1 must be unique when its value is above 1000 but any number of rows can have the same value for col1 when it is 999 or less. Another example would be a flag column that determines that col1 must be unique. Don't ask me WHY you would do either of these things.

    Here's how to accomplish the first example (btw both examples require a PK on the table):
    CREATE TABLE junk(
    junk_key INTEGER NOT NULL,
    col1 INTEGER NOT NULL,
    CONSTRAINT pk_junk PRIMARY KEY(junk_key)
    );

    --The way we accomplish this is with a function-based index.
    CREATE UNIQUE INDEX idx_semiuniq ON junk(
    CASE WHEN col1=1000 THEN TO_CHAR(col1) ELSE '~' || TO_CHAR(junk_key) END);

    --The following statements should succeed:
    insert into junk values(1,1);
    insert into junk values(2,1);
    insert into junk values(3,1000);
    insert into junk values(4,1001);
    update junk set col1=1002 where junk_key=4;
    --The following statements should fail:
    insert into junk values(5,1000);
    update junk set col1 = 1001 where junk_key=1;

    The same strategy applies to the second example, except that in this case we'll need an additional column to indicate that col1 needs to be unique:

    CREATE TABLE junk( junk_key INTEGER NOT NULL,
    col1 INTEGER NOT NULL,
    uniq_flag CHAR(1) NOT NULL,
    CONSTRAINT pk_junk PRIMARY KEY(junk_key),
    CONSTRAINT ck_junk CHECK (uniq_flag IN ('Y','N'))
    );

    CREATE UNIQUE INDEX idx_semiuniq ON junk(CASE WHEN uniq_flag = 'Y' THEN TO_CHAR(col1) ELSE '~' || TO_CHAR(junk_key) END);

    --these should succeed:
    insert into junk values(1,1,'N');
    insert into junk values(2,1,'N');
    insert into junk values(3,1,'Y');
    insert into junk values(4,2,'Y');
    --these should fail:
    insert into junk values(5,2,'Y');
    update junk set uniq_flag='Y' where junk_key=2;

    Another way to accomplish this is with a "not exists" in a check constraint, but I think the function-based index will perform better especially when inserting or updating large numbers of rows.

  • RELEVANCY SCORE 2.92

    DB:2.92:How To Generate A Unique Key Based On A Some String Value f1


    Hello every one,

    I am sorry , If I post this question in wrong group... I have a requirement to generate a unique key ( what every it may be alpha, numeric or alpha numeric) based on some String..

    For ex : String str = "AbCX" - Gives a unique key based on "AbCX" value..

    Is there any way we can get the unique value using Java ?

    Thanks

    DB:2.92:How To Generate A Unique Key Based On A Some String Value f1

    Friends,

    I found the answer for my question.. It is very simple.. String.hashCode() will return a Unique hash code value based on JVM ...

    Cheers

  • RELEVANCY SCORE 2.85

    DB:2.85:Select Statement Should Return Only One Rows zs


    Hello Folks,

    A select statement should return rows based on where condition. If no rows found in that select statement it should return only one row with any value. I am using oracle 8i, pls help me to find the solution for this.

    Thanks,Raghu.K

    DB:2.85:Select Statement Should Return Only One Rows zs

    small enhancement: use an UNION ALL
    why bother sorting when both statements are mutually exclusive

  • RELEVANCY SCORE 2.82

    DB:2.82:Copy A Range Of Cells Based On A Cell Value zd


    I need a macro that will copy and paste an X number of rows when I enter a number of rows.

    Example.

    My rangetocopyB5-G5. If I enter 5 in cell a1, I want the macro to run automatically as soon as I enter the 5 and hit enter.
    The macro would copy my range B5-G5 all the way to B10-G10. My range consist of constants and formulas.

    Hope someone can help.

    DB:2.82:Copy A Range Of Cells Based On A Cell Value zd

    ... BTW, what do you recommend I do to learn vba?

    I'm glad you got sorted out and thanks for the feedback. As far as learning VBA, you could try a book (beginner or intermediate depending upon your current skill level) or just learn from experience and example as you build your own macros. VBA as a scripting
    (e.g. non-compiled) language isn't too tough and can seem to follow logical flow pretty easily.

  • RELEVANCY SCORE 2.82

    DB:2.82:How Can I Filter And Copy Info In Rows Based On Certain Content In A Column dm


    I have a workbook, FHE_Statements.xlsx. it has weekly invoices to our customer. I need to copy certain data from this workbook to another. For example, on sheet 100017, from B16 thruH32; but I only need the information from the rows that have 1763 in column
    E. How do I do this??

    DB:2.82:How Can I Filter And Copy Info In Rows Based On Certain Content In A Column dm

    If you have a lot of different values in the column and need to create a lot of different workbooks the manual way Bob told you maybe is to much work.

  • RELEVANCY SCORE 2.80

    DB:2.80:Temporary Key Not Unique mm


    I have a datatbase with a primary key (int). I created an entity model and I am binding a web grid to a collection of entities. One requirement is that you can add multiple rows, and edit/delete any rows added as needed, before saving. The problem is that the temporary key is not unique. I have tried binding to the primary key field as well as the EntityKey, but in both cases the grid can't distinguish the added rows based upon the key and gets confused. How can I ensure that temporary keys are unique and the primary key field gets a unique, temporary, value?
     
    Since different entity types can be accessed through the same context, I am looking for a solution that will work for any entity type, not just entity types that happen to have a primary key of type int.

    DB:2.80:Temporary Key Not Unique mm

     
    You should add something about some automated temporary unique key for new entities to the v2 wish list.Not sure if it can be pulled off, but you can always ask! :-)
     
    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3391412SiteID=1

  • RELEVANCY SCORE 2.80

    DB:2.80:Trying To Appendpaste Unique Fields From One Table To Another In Access - Not Rows m8


    I have a number of tablescontaining a series ofmonthly data, and I want to add a set of new columns to each of these tables. In excel I would just copy and insert the columns, Access does not seem to have this feature. I tried the Append query, but it
    appends the data based on rows not columns.

    DB:2.80:Trying To Appendpaste Unique Fields From One Table To Another In Access - Not Rows m8

    Hi,
    Welcome to Microsoft Windows Vista Forums.
    The issue you posted is related to Office Application and would be better suited in the Office community. Please visit the link below to find a community that will offer the best support.
    http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

    Diana D D - Microsoft Support.
    Visit our Microsoft Answers Feedback Forum
    and let us know what you think.

  • RELEVANCY SCORE 2.80

    DB:2.80:Select Distinct In Form. j8


    Dear all,
    can i select the distinct rows in FORM.
    I want to only select the unique rows only.

    how can do it?

    thanks

    Muhammad Nadeem
    nadeem14375@gmail.com

    DB:2.80:Select Distinct In Form. j8

    Why is everybody so reluctant to base a block on stored procedure??

    What is better? Creating a view or a procedure??
    I guess if one just wants to query, view is fine.

  • RELEVANCY SCORE 2.79

    DB:2.79:Include Rows With Same Value In A Column cf



    Hi All - How can we include rows with same value in one of the column (for e.g. Name) in the straight table? The table is automatically removing such rows despite using a unique field (ID which is unique in source) as dimension?

    Thanks in advance for your time.

  • RELEVANCY SCORE 2.79

    DB:2.79:Many Questions For Things To Be Done On The Same Worksheet a8


    I have a worksheet in the following format

    Col 1
    Col 2
    Col 3
    Col 4

    A
    Value
    Formula
    Formula

    A
    Value
    Formula
    Formula

    A
    Value
    Formula
    Formula

    A
    Value
    Formula
    Formula

    A
    Value
    Formula
    Formula

    Copy A
    Copy Value
    Copy formula
    Copy formula

    Copy A
    Copy Value
    Copy formula
    Copy formula

    Copy A
    Copy Value
    Copy formula
    Copy formula

    Copy A
    Copy Value
    Copy formula
    Copy formula

    B
    Value
    Formula
    Formula

    B
    Value
    Formula
    Formula

    B
    Value
    Formula
    Formula

    B
    Value
    Formula
    Formula

    B
    Value
    Formula
    Formula

    B
    Value
    Formula
    Formula

    C
    Value
    Formula
    Formula

    C
    Value
    Formula
    Formula

    C
    Value
    Formula
    Formula

    C
    Value
    Formula
    Formula

    D
    Value
    Formula
    Formula

    D
    Value
    Formula
    Formula

    Here are my issues (Please note that my actual worksheet has 8000 rows)
    1) I want to add 15 blank rows after each change in value in Col1
    2) Copy values from Col 1 to newly inserted rows, copy values from Col 2 and copy formula for Col 3 Col 4
    3) Add section break after the newly inserted rows
    4) Be able to print the entire worksheet with page numbering as column header which shows Page 1 of ? with ? are the total number of pages fora particularsection only
    5) In the filter mode (which I do by each section only), I want to print the pages for that section only.
    Please ask me if this is not clear as I need it on an urgent basis.

    Thanks in advanceto all the Excel gurus

    Zia

  • RELEVANCY SCORE 2.75

    DB:2.75:Macro To Delete Rows Based On User Input 73


    Hi,

    Need help with a sheet. I need to delete all the rows on "Sheet1" that has a specific cell value that needs to be determined by an input box. I need the macro to prompt the user to enter the cell value they want to have deleted. The cell value can be
    a person, or it can bea date. I need to delete all the rows where that value is found in column A only.

    Any help would be appreciated.

    Thanks

  • RELEVANCY SCORE 2.75

    DB:2.75:User Written Code To Only Display Unique Rows (Based On Two Variables) 97



    A User Written transformation in DI Studio uses the following code:

    proc sql;
    create table work.oppspartkap as
    select polisenr, periode_yyyymm, oppspartkapital2 from _input;
    quit;

    data _output;
    set work.oppspartkap;
    by polisenr notsorted;
    if first.polisenr;
    run;

    After running it, and applying a filter so that it only displays rows with polisenr 1, the work table looks like this:

    I need to edit the user written code so that identical rows, such as the three highlighted ones, only appear once. Not sure whether I should use "distinct" somewhere, "group by" somewhere, or something else. Kindly advise me, thanks.

    DB:2.75:User Written Code To Only Display Unique Rows (Based On Two Variables) 97


    I'm not versed in DI studio, thus I'm not sure what your best route is. However, since you asked, a datastep at the end will do what you ask, namely:

    data _output;
    set data _output;
    by polisenr periode_yyyymm;
    if last.periode_yyyymm;
    run;

  • RELEVANCY SCORE 2.75

    DB:2.75:Displaying Row Values From Main Report To Subreport 7m



    I have a linked subreport. The main report has subreport links set, based on a column. When I click on any of the column value, it opens a subreport with corresponding values. Everything is working fine till this point. The column that is being set in links does not have unique values. I have to do 2 tasks:

    1. If the same value exists in 5 rows, I want the data for all 5 rows(filtered by that column) to be displayed in the subreport. This is done.

    2. I also the want the values of the row corresponding to the selected column value in the subreport. I am stuck here as I dont know how to get the values of a particular row in subreport when 5 other rows also exist.

    Please let me know if anyone has any idea. Thanks in advance..

    DB:2.75:Displaying Row Values From Main Report To Subreport 7m


    Thanks 4 ur reply..

    Actually when I need the values of that particular row of which i have selected the column to open the subreport, in my subreport the other column values are the first values that are stored in the database corresponding to the selected column, not the values that were in the row of main report. That row may correspond to 2nd 3rd or any other instance in the database but the value returned is always the first one.

  • RELEVANCY SCORE 2.74

    DB:2.74:Dynamic Reference Cursor Name 3s


    Is there way to change the name of the reference cursor dynamically?

    Need to return multiple cursors with different cursor names for for unique rows in a table based on a key field. And the Key field value should be the cursor name.

    For example the rows are

    Flag1 | Val 1 | Val 2 |
    Flag2 | Val 3 | Val 4 |
    Flag 3 | Val 5 | Val 6 |

    I need to return 3 cursors with the names Flag 1, Flag 2, Flag 3 with the respective values. These Flag names will change dynamically and the number rows with unique flag names will also change. Please update me if you have a solution for the above scenario.

    DB:2.74:Dynamic Reference Cursor Name 3s

    Is there way to change the name of the reference cursor dynamically?

    No.

    Need to return multiple cursors with different cursor names for for unique
    rows in a table based on a key field.
    There is NO valid technical reason for this request.

  • RELEVANCY SCORE 2.74

    DB:2.74:Help With Excel Macro That Creates New Workbooks Based On Unique Values In A Column xk


    I am using a macro that I found online. I would like some help to get it to work correctly and I also want to make some modifications to it.
    The problem:
    My source list has 29 unique values. The macro should create 29 new workbooks, saved in the same folder as the source file, each with only records associated with
    the unique value.

    However, each new workbook created contains the last row, 'total', and the row above it. The macro is intended to exclude ‘total’, so that part isn’t working. Perhaps more
    accurately, each new workbook created includes the last two rows of the master list. The second to the last line (including “total”) is a unique value and the macro should have created a new workbook, but it does not. There are 29 unique values in column A
    (excluding ‘total’) and I get 28 new workbooks.

    My work around right now is to add two new rows to list by typing an asterisk in the two cells, column A, just below the end of the list. Then what I get is the correct number
    of new workbooks with the correct data in each, but each unique list has two asterisks at the end – which is ok but not correct.

    Enhancements that would be nice.
    1. I have figured out how to rename the folder where the new workbooks go, but I would like help adding the creation date
    to the end of the folder name. Example of new folder name: AgRpt Split by Agencies_yymmdd
    2.I would like help adding the creation date to the file name of each new
    workbook. Example: “108000_yymmdd”
    Any help you can give would be greatly appreciated. I am using Excel 2007 at home and 2013 at work. Thank you.
    Here is the macro I downloaded. I can also send the file Excel file I am working with if that will help.
    Public Sub SplitToFiles()

    ' MACRO SplitToFiles
    ' Last update: 2012-03-04
    ' Author: mtone
    ' Version 1.1
    ' Description:
    ' Loops through a specified column, and split each distinct values into a separate file by making a copy and deleting rows below and above
    '
    ' Note: Values in the column should be unique or sorted.
    '
    ' The following cells are ignored when delimiting sections:
    ' - blank cells, or containing spaces only
    ' - same value repeated
    ' - cells containing total
    '
    ' Files are saved in a Split subfolder from the location of the source workbook, and named after the section name.

    Dim osh As Worksheet ' Original sheet
    Dim iRow As Long ' Cursors
    Dim iCol As Long
    Dim iFirstRow As Long ' Constant
    Dim iTotalRows As Long ' Constant
    Dim iStartRow As Long ' Section delimiters
    Dim iStopRow As Long
    Dim sSectionName As String ' Section name (and filename)
    Dim rCell As Range ' current cell
    Dim owb As Workbook ' Original workbook
    Dim sFilePath As String ' Constant
    Dim iCount As Integer ' # of documents created

    iCol = Application.InputBox(Enter the column number used for splitting, Select column, 1, , , , , 1)
    iRow = Application.InputBox(Enter the starting row number (to skip header), Select row, 6, , , , , 1)
    iFirstRow = iRow

    Set osh = Application.ActiveSheet
    Set owb = Application.ActiveWorkbook
    iTotalRows = osh.UsedRange.Rows.Count
    sFilePath = Application.ActiveWorkbook.Path

    If Dir(sFilePath \AgRpt Split by Agencies_yymmdd, vbDirectory) = Then
    MkDir sFilePath \AgRpt Split by Agencies_yymmdd
    End If

    'Turn Off Screen Updating Events
    Application.EnableEvents = False
    Application.ScreenUpdating = False

    Do
    ' Get cell at cursor
    Set rCell = osh.Cells(iRow, iCol)
    sCell = Replace(rCell.Text, , )

    If sCell = Or (rCell.Text = sSectionName And iStartRow 0) Or InStr(1, rCell.Text, total, vbTextCompare) 0 Then
    ' Skip condition met
    Else
    ' Found new section
    If iStartRow = 0 Then
    ' StartRow delimiter not set, meaning beginning a new section
    sSectionName = rCell.Text
    iStartRow = iRow
    Else
    ' StartRow delimiter set, meaning we reached the end of a section
    iStopRow = iRow - 1

    ' Pass variables to a separate sub to create and save the new worksheet
    CopySheet osh, iFirstRow, iStartRow, iStopRow, iTotalRows, sFilePath, sSectionName, owb.fileFormat
    iCount = iCount 1

    ' Reset section delimiters
    iStartRow = 0
    iStopRow = 0

    ' Ready to continue loop
    iRow = iRow - 1
    End If
    End If

    ' Continue until last row is reached
    If iRow iTotalRows Then
    iRow = iRow 1
    Else
    ' Finished. Save the last section
    iStopRow = iRow
    CopySheet osh, iFirstRow, iStartRow, iStopRow, iTotalRows, sFilePath, sSectionName, owb.fileFormat
    iCount = iCount 1

    ' Exit
    Exit Do
    End If
    Loop

    'Turn On Screen Updating Events
    Application.ScreenUpdating = True
    Application.EnableEvents = True

    MsgBox Str(iCount) documents saved in sFilePath

    End Sub

    Public Sub DeleteRows(targetSheet As Worksheet, RowFrom As Long, RowTo As Long)

    Dim rngRange As Range
    Set rngRange = Range(targetSheet.Cells(RowFrom, 1), targetSheet.Cells(RowTo, 1)).EntireRow
    rngRange.Select
    rngRange.Delete

    End Sub

    Public Sub CopySheet(osh As Worksheet, iFirstRow As Long, iStartRow As Long, iStopRow As Long, iTotalRows As Long, sFilePath As String, sSectionName As String, fileFormat As XlFileFormat)
    Dim ash As Worksheet ' Copied sheet
    Dim awb As Workbook ' New workbook

    ' Copy book
    osh.Copy
    Set ash = Application.ActiveSheet

    ' Delete Rows after section
    If iTotalRows iStopRow Then
    DeleteRows ash, iStopRow 1, iTotalRows
    End If

    ' Delete Rows before section
    If iStartRow iFirstRow Then
    DeleteRows ash, iFirstRow, iStartRow - 1
    End If

    ' Select left-topmost cell
    ash.Cells(1, 1).Select

    ' Clean up a few characters to prevent invalid filename
    sSectionName = Replace(sSectionName, /, )
    sSectionName = Replace(sSectionName, \, )
    sSectionName = Replace(sSectionName, :, )
    sSectionName = Replace(sSectionName, =, )
    sSectionName = Replace(sSectionName, *, )
    sSectionName = Replace(sSectionName, ., )
    sSectionName = Replace(sSectionName, ?, )

    ' Save in same format as original workbook
    ash.SaveAs sFilePath \AgRpt Split by Agencies_yymmdd\ sSectionName, fileFormat

    ' Close
    Set awb = ash.Parent
    awb.Close SaveChanges:=False
    End Sub

    DB:2.74:Help With Excel Macro That Creates New Workbooks Based On Unique Values In A Column xk


    Hi Luna,
    I've a workbook (WB1) that contains a sheet with specific information across anumber of columns. What I want to do is retrieve information from WB1 based on specific criterias in another workbook (WB2). In (WB2) I will input information into rows B2:C5.
    I will define these specific cells and to ensure user can onlyinput information to these cells in a specific manner (date format: YYYYMMDD). Based on this information I want a macro to find this information in WB1 in columns F:H and where it locates
    the information in any of the rowsof columns F:H retrieve that entire row into a new workbook.
    Is this possible?
    Appreciate your help.
    Regards,
    Ed

    Anything is possible but you need to start you own question. See forum guidelines on how to post.¯\_(ツ)_/¯

  • RELEVANCY SCORE 2.74

    DB:2.74:How Can I Copy Only The Rows With True Value To Other Sheet One Under The Ther With Vba 11


    Hi,

  • RELEVANCY SCORE 2.74

    DB:2.74:Filter Results 3f


    Hello,

    COL_ACOL_BCOL_CCOL_DCOL_E
    970251871990025018499CIKOLZOFTSMITH
    970251872990025018499JQDTLSMITH
    3058101077 890013483089GTGKUTJONES
    307978551 1590025286659AFFQDOE

    In my sample result set you can see that I have two rows with the same value for Col_A. I'd like to adjust my query so that I receive only one row for each Col_A value, based on the min value for Col_B.

    Any suggestions are appreciated......

    Thanks!
    Christine

    DB:2.74:Filter Results 3f

    I am so sorry! I missed the order by in your first posting and you are correct, your solution works perfectly! Thanks so much for your help.

    As for posting the code, as I explained in another reply - I just started with this company and was told that they are very sensitive to what's posted on forums, so I'm trying to be as discrete as possible while still posting enough information.

    Thanks again!!

  • RELEVANCY SCORE 2.72

    DB:2.72:How To Return Records Based On Only 1 Column Being Unique fk



    I have stored procedure. I would like it to return only rows where o.offergroupnumber are unique.
    When multiple rows have the same o.offergroupnumber, I am indifferent to which
    of these rows is returned as the 'distinct' row.

    DB:2.72:How To Return Records Based On Only 1 Column Being Unique fk

    Rereading the question, OP wants one row from each group by offergroupnumber.
    select null where rk = 1, hmm? Nice. You don't even have to ask what columns are unique to select and join!
    Josh

  • RELEVANCY SCORE 2.72

    DB:2.72:Value Set Return Value Problem pd


    Hi all,

    I have defined a new value set defined. The Value field for that value set is not unique in the value set query. But the ID field is unique.

    Example values:

    Value Meaning Id
    123 1231 1231
    123 1232 1232

    When I select the first record from that value set, it throws the following error:

    LEX-VALUE NOT UNIQUE
    --------------------------------------------------------------
    APP-FND-01564: ORACLE error 1422 in FDFGVD

    Cause: FDFGVD failed due to ORA-01422: exact fetch returns more than requested number of rows.

    The SQL statement being executed at the time of the error was: SELECT ID,AWBNO VALUE, ID DESCRIPTION FROM XXFDX_AWB_LOV_QUERY WHERE 1=1 AND AWBNO = :X and was executed from the file ERRFILE.

    ----------------------------------------------------

    After I select a value from those two, it is trying to execute the value set query based on the Value I selected, which is not unique.

    I was under the impression that ID field will be used to search in the WHERE clause.

    The simplest solution for this is, to have ID column as Value. But I do not want to dispaly ID ("1231" in this case) back to the user. I want to display only Value ("123").

    How can I achieve this?

    My Value Set is based on a VIEW and I can change the underlying query if needed.

    Appreciate your help.

    Thanks in Advance..

    DB:2.72:Value Set Return Value Problem pd

    Of course it will throw this error because one value (123) can have multiple ID.
    Another way of doing it is to use ID as value, and you put the value column as Additional Column.

    Check Oracle Application's Flexfield Guide Chapter 4 (Value Sets) for details :

    http://download-east.oracle.com/docs/cd/B25516_11/current/acrobat/115flexug.pdf

  • RELEVANCY SCORE 2.72

    DB:2.72:Ssis Use Lookup To Copy Only Unique Rows Error cc


    Hi, I am using the lookup function's error output to copy only the rows that are unique into a certain database.  However, and beyond my knowledge, out of 97,914 rows involved, 2 of them sneak throught the lookup and cause an error to crop up each time.  The rows do indeed have duplicates in the database, but I do not understand why the lookup does not find them, but the primary key (all columns are a primary key) does find them and errors when I try to insert a duplicate that has snuck through the lookup.  My investigation seems to yield that the rows are indeed exact duplicates, however there are many other duplicates that do not make it through the lookup, as the SSIS package is programmed to do.  Any help would be greatly appreciated,Tom

  • RELEVANCY SCORE 2.71

    DB:2.71:Select Rows Based On Multiple Criteria cc


    Hi,

    I'm writing a mcaro to select and copy an entire row(s) based on 3 columns:

    Column K must = "1" (string, not number)
    Cloumn AO must be blank (this part I have below)
    Column BD must equal one of the string values in a named range called RouteRange which could be 1 or 300 unique values (values will never be repeated in this range)

    I can select based on AO being blank with no issue

    LRw = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row
    Set ExtraOrderRange = ActiveSheet.Range("AO2:AO" LRw)
    Set ExtraOrderBlank = ExtraOrderRange.SpecialCells(xlCellTypeBlanks)

    If ExtraOrderBlank Is Nothing Then
    Else
    ExtraOrderBlank.EntireRow.Select
    End If

    It's the other 2 criteria Im pulling my hair out over. I can't figure it out

    Any help is greatly appreciated.

    Thanks

    DB:2.71:Select Rows Based On Multiple Criteria cc

    Hi Keith,

    This is what I came up with. I went with the AutoFilter for 2 of the criteria because they were very straightforward. If you have any suggestions on making it more efficient I'd appreciate it.

    Thanks for the help

    Dim AllRouteRange As Range, ws As Worksheet
    Dim RouteCopyRange As Range
    Dim RouteString As String

    Set SLBk = ActiveWorkbook
    Set ws = SLBk.ActiveSheet

    With ws
    LastRow = ws.Cells(Cells.Rows.Count, "A").End(xlUp).Row
    Set AllRouteRange = .Range("BD2:BD" LastRow)
    Selection.AutoFilter
    ActiveSheet.Range("$A$1:$BX" LastRow).AutoFilter Field:=11, Criteria1:="1"
    ActiveSheet.Range("$A$1:$BX" LastRow).AutoFilter Field:=41, Criteria1:="="

    For Each c In AllRouteRange
    If IsError(Application.Match(c.Value, RouteRange, 0)) Then
    If RouteCopyRange Is Nothing Then
    Set RouteCopyRange = c.EntireRow
    Else
    Set RouteCopyRange = Union(RouteCopyRange, c.EntireRow)
    End If
    End If

    Next
    If Not RouteCopyRange Is Nothing Then
    RouteCopyRange.EntireRow.Hidden = True
    End If
    .Range("A1:BX" LastRow).Select
    Selection.SpecialCells(xlCellTypeVisible).Copy SLSht.Range("A1")
    End With

  • RELEVANCY SCORE 2.70

    DB:2.70:Count Of Unique Text-Value Cells In One Column That Also Have Specific Text Values In Two Other Columns 9m


    I have a worksheet that has 28 columns, with data in almost 11,000 rows.

    Column D is "name" which is a text string
    Column X has text values of either Yes or No
    Column AA has a 4 character text string (e.g. ABCD - only 6 possible values in this column, representing business units)

    I need to count the number of unique values in D for each unique value in AA, e.g. ABCD has 5 unique names, EFGH has 30 unique names, etc. This is UniqueNamesPerBusinessUnit

    Next, I need to count the number of unique values in D that also have the value Yes in X, for each value in AA. This is UniquePositiveNamesPerBusinessUnit

    This will allow me to then get a "score" percentage of UniquePositiveNamesPerBusinessUnit/UniqueNamesPerBusinessUnit

    I'm more than willing to make intermediate calculations in separate cells - one for each business unit for UniqueNames and then UniquePositiveNames?

    I've tried samples that use matches within frequency, but only ever get #N/A values when copying the formula from the office site examples, even just to get a unique list of names, but I need to also consider the extra parameters of business unit, and then
    the Yes/No in column X, and at that point my eyes glaze over.

    Ideas?

  • RELEVANCY SCORE 2.70

    DB:2.70:Copy Rows From One View Object To Another 3z


    Hi

    i have Requirment i have to copy the one or more rows present in AdvanceTblRN(Vo rows) of Tab1 to another another Region's VO in another tab2 but it shd copy only which are checked in checkbox in that region and shd also insert the data to another EO based VO help me out

    DB:2.70:Copy Rows From One View Object To Another 3z

    Create one transient attribute in VO1 and attach this with one check box on front end,
    Iterate through the first VO Row and put the values in the second one.

    ANoop

  • RELEVANCY SCORE 2.70

    DB:2.70:Data Driven Performance Testing - Using Only Selected Rows mc


    In my case,
    I had a table with 100 rows. I am planning to use the same table for different web tests.
    Webtest1 deals with the data in 1-10 rows
    Webtest2 deals with the data in 11-50 rows...
    I mean based on a particular column value
    How can i handle this.

    DB:2.70:Data Driven Performance Testing - Using Only Selected Rows mc

    Hi Ravisangam,
    You can advance your data source manually to control what row each webtest or user gets. I have added the code snippet to advance the data source to the next row.
    this.MoveDataTableCursor(datasourcename,datatablename);
    MSDN on moving the cursor:
    http://msdn.microsoft.com/en-us/library/ms244194.aspx
    It is important to note that data sources work slightly different when executing on multiple agent test rig. I included a link to Sean Lumley's blog which describes the differences between the two. I hope that helps.
    Seans Blog :
    http://blogs.msdn.com/b/slumley/archive/2008/03/14/description-of-access-methods-in-data-sources.aspx
    Regards,
    Matt M.

  • RELEVANCY SCORE 2.70

    DB:2.70:Table With List Of Value Dependant On Another Column Value Which Is Never Changed By The User 83


    Good day!I am working with JDeveloper 11.1.2.4.I have an ADF Table which has 4 rows. Each row has a column with a unique value. The plan is to have an LOV column in the row show a different list of values based on the unique column value. I've setup the List Of Values to use a view criteria with a bind variable. When creating the LOV data source, I specify the unique column name for the bind variable value. However, it seems that the LOV doesn't change at all when selecting different rows.Is there a good way to handle this? I have done dependant LOVs in the past, but this is not quite the same as the user can only view the value that the LOV is dependant on.Any suggestions are greatly appreciated!BradW

    DB:2.70:Table With List Of Value Dependant On Another Column Value Which Is Never Changed By The User 83

    Soooo, I recreated my LOV exactly that same and now all is well. There must have been a small gotcha as I had been trying to manually tweak an LOV to use a different view. I am just happy it is working!!!Have a great day,BradW

  • RELEVANCY SCORE 2.70

    DB:2.70:Remove Message W/ Selector List Unique Prop Value sk



    Hi guys,Currently, I am trying to implement "Remove messages with selector" and "List unique property value" in my local copy of JBoss Messaging. I hope that these features can be also put in official JBoss Release. ;)Below is the explanation of the features."Remove Messages With Selector" is usable for operator that want to remove "certain" type of messages in destination.For example, remove messages with customer id's value 1000. This is happened becaused sometime a value become obsolete, and all messages related to it have to be removed from destination.List Unique Property Value is useful for listing unique value of a property. Sometime operator wants to know what kind of values available in destination, and acts based on the value received.For example, when we have three messages, each has property customer Id with value 1000, 2000, 1000 respectively. When users call list unique property customer Id, they will received a list contains values 1000, and 2000. Based on this, users know how many customer use the service.What's your opinion these features? If you are agree then I will create JIRA tasks and work on them.Thank you for your time reading this.Best Regards,Hendra

    DB:2.70:Remove Message W/ Selector List Unique Prop Value sk


    Sorry for triple posting@genman,I just checked the source, I think by simply creating message listener for "removing message with selector" can cause problem for scheduled delivery messages, or?May be I don't catch your idea. If I am wrong, could you explain again your idea to me.Thank you in advance.Best Regards,Hendra

  • RELEVANCY SCORE 2.70

    DB:2.70:Create Duplicate Rows fc



    Good day all,

    I have a question. I have a table of unique users with scores, these scores are 7, 3 and 1. I am trying to replicate the rows based on the score value. So if user A has 7 points, then i would like to show 7 lines with the same data and so forth. Please could anyone assist.

    Thank you in advance.

    Regards

    Kamiel

    DB:2.70:Create Duplicate Rows fc


    If doing this in load script, you can try this ...

    Data:

    Load RowNo() as RowId, * while iterno() = Score;

    load * inline [

    User, Score

    A,1

    B,2

    C,4

    D,18

    E,0];

    flipside

  • RELEVANCY SCORE 2.69

    DB:2.69:Copy Indexes Also While Creating Table 8k


    is there any way i can take exact structure of table including indexes and create another table. i don't need the data.
    create table emp_copy as select * from emp where 1=2.this query creates only structure. how to copy indexes of emp also. Emp table has lot of indexes,unique indexes and functional based indexes. how can i take them to empy_copy. iPlease advice the query to copy indexes too.

    DB:2.69:Copy Indexes Also While Creating Table 8k

    set long 100000
    select dbms_metadata.get_dependent_ddl('INDEX','EMP) from dual;

    How to find the DDL of any Specific Database Object (e.g TABLE,VIEW,SEQUENCE etc ?)
    http://hiteshgondalia.wordpress.com/oracle/database-oam/

  • RELEVANCY SCORE 2.69

    DB:2.69:How To Get A Unique Row In A Value Set j9


    How to get a unique row in a value set which is used in concurrent program.

    Example if a table contains 10 unique rows i need only one row to show.

    Thanks

    DB:2.69:How To Get A Unique Row In A Value Set j9

    If it is table data type...at the time of entering the column name put DISTINCT keyword infornt of it..it should solve your problem.

    Thanks
    Prudhvi
    www.erpschools.com
    www.oracleschools.com

  • RELEVANCY SCORE 2.68

    DB:2.68:Vba Excel - Count Rows With Unique Value mf


    Hi all,

    DB:2.68:Vba Excel - Count Rows With Unique Value mf

    what if I have dynamic range? e.g. not just a1:a5 but sometimes I need for range a1:a13 or a1:a1909 etc. Thanks.

    solved.

  • RELEVANCY SCORE 2.68

    DB:2.68:Query To Retrieve Unique Rows Based On Related Column Value ad


    Hi Guys,
    Please provide me directions for writing a SQL Query (or) Sample Query for below requirement.
    Suppose I am having a table with following rows:
    id NumberIsPrimary
    --- ------ ---------
    1 1234 0
    12345 0
    1 1235 1
    2 1237 0
    23223 0
    22312 0
    3 5678 0
    4 2312 0
    I want to write a Query to retrieve unique rows based on ID column by meeting following conditions:
    1) When there are duplicate rows with same ID, Need to check for IsPrimary Column and pickup the row with value IsPrimary==1.
    Example row satisfying above condition is row with ID=1.
    2) It is related to above condition, Where there are duplicate rows with same ID and If the IsPrimary column for all these rows IsPrimary == 0, Then we need to pickup the first row.
    Example row satisfying this condition is row with ID=2

    I am looking for following output after satisfying above conditions:
    id NumberIsPrimary
    --- ------ ---------
    1 1235 1
    2 1237 0
    35678 0
    4 2312 0
    Please provide me directions for writing a SQL Query (or) Sample Query for below requirement.

    Please don't forget to 'mark answer/propose answer' or 'vote as helpful' as appropriate.

    DB:2.68:Query To Retrieve Unique Rows Based On Related Column Value ad

    Try the below:

    create Table T11 (RowID int identity(1,1),id int, Number int, IsPrimary bit)

    Insert into T11 Values
    (1,1234,0),
    (1,2345,0),
    (1,1235,1),
    (2,1237,0),
    (2,3223,0),
    (2,2312,0),
    (3,5678,0),
    (4,2312,0)

    ;with cte
    AS
    (
    Select *,ROW_NUMBER()Over(PARTITION by id Order by IsPrimary desc, RowID asc) Rn From T11
    ) Select id,Number,IsPrimary From cte Where Rn=1

    Drop table T11

    Please use Marked as Answer if my post solved your problem and use
    Vote As Helpful if a post was useful.

  • RELEVANCY SCORE 2.67

    DB:2.67:Help Me Solve In Best Way Possible Without Creating Extra Variables 9z



    Hi,

    i just need to retain records where for every unique value of var1,

    if var2 hold values 'g' 'b' then should reatin rows with value 'g',

    else if it hold only 'g' all the rows, if only 'b' even all the rows should be retianed,

    i have enclosed the ouput which would help understand much better.

    data a;

    input var1 var2 $;

    datalines;

    1 g

    1 g

    1 b

    1 g

    2 b

    2 b

    3 g

    3 g

    ;

    run;

    o/p

    1 g

    1 g

    1 g

    2 b

    2 b

    3 g

    3 g

    Thanks!

    Sri..

  • RELEVANCY SCORE 2.67

    DB:2.67:Whats Wrong With This Vba Code To Copy Rows Based On Cell Value. I Need Your Advice cz


    Hi!

    DB:2.67:Whats Wrong With This Vba Code To Copy Rows Based On Cell Value. I Need Your Advice cz

    My bad - the second one requires that rng be declared outside of the first sub, to be public:

  • RELEVANCY SCORE 2.67

    DB:2.67:Conditional Deletion In Internal Table (Abap Routine) mk



    Hello Gurus,

    I am trying to delete selective rows based on the following conditions:

    As seen in the screenshot, the first column contains Handling Codes and the last column contains counter values.

    If a Handling Code contains MULTIPLE rows with counter value '0', ONLY ONE row must be displayed. It could be the first or last. (0000379651)

    If a Handling Code contains only a SINGLE row with counter value '0', it must be displayed. (0000379831)

    If a Handling Code contains MULTIPLE rows with counter value '1', ALL rows must be displayed. (0000379834)

    If a Handling Code contains MULTIPLE rows with counter values '1' and '0', ALL rows containing value '1' must be displayed and those containing '0' must be omitted. (0000380009)

    Plainly said all highlighted rows have to be deleted/suppressed.

    How can I achieve this in a routine which I am programming in an APD?

    Pls Help. Many Thanks.

    SD

    DB:2.67:Conditional Deletion In Internal Table (Abap Routine) mk


    Here is the exact code which works!!

    DATA: ls_source TYPE y_source_fields, ls_target TYPE y_target_fields. DATA: IT_XX_TAB1 TYPE STANDARD TABLE OF y_target_fields WITH NON-UNIQUE KEY CRM_OBJ_ID, IT_XX_TAB2 TYPE STANDARD TABLE OF y_target_fields WITH NON-UNIQUE KEY CRM_OBJ_ID. LOOP AT it_source INTO ls_source. MOVE-CORRESPONDING ls_source TO ls_target. IF ls_source-RSTT_COUNT = '0'. APPEND ls_source TO IT_XX_TAB1. ELSEIF ls_source-RSTT_COUNT = '1'. APPEND ls_source TO IT_XX_TAB2. ENDIF. ENDLOOP.* alle Stze mit dem Zhler = 1 bernehmen et_target = IT_XX_TAB2 .* Stze mit 0 bernehmen nur wenn kein Vorgangsnummer mit 1 vorhanden SORT IT_XX_TAB1 BY CRM_OBJ_ID. DELETE ADJACENT DUPLICATES FROM IT_XX_TAB1 COMPARING CRM_OBJ_ID. LOOP AT IT_XX_TAB1 INTO ls_target. READ TABLE IT_XX_TAB2 TRANSPORTING NO FIELDS WITH TABLE KEY CRM_OBJ_ID = ls_target-CRM_OBJ_ID. IF sy-subrc 0. APPEND ls_target TO et_target. ENDIF. ENDLOOP.

  • RELEVANCY SCORE 2.67

    DB:2.67:How To Update Multiple Rows In T1 With Unique Value From T2 p7



    Hi,
    having on mind update query with where clause:
    WHERE (SELECT LEFT(ColumnName,7) FROM tblName) = emp2.ColumnName
    error:
    Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , = , , = or when the subquery is used as an expression.
    The statement has been terminated.
    What am I suppose to change in WHERE clause....
    Note: there is always unique value in T2 while, in T1, there could be both, only one value to be updated or number of them that all need to be updated with that unique value from T2 (alias emp2)

    DB:2.67:How To Update Multiple Rows In T1 With Unique Value From T2 p7

    Hello,
    based on practical use of this update that looks simple, I would like just to draw attention of those that might be interested in this issue, to pay attention to following:
    In my case, it happen to be that second column i.e., columnB, was looking like this: A or B or C or...etc but, what was not visible by eyes when looking into values is, there was an empty space, in just some cases, which caused confusion when I analyzed
    final data that were away from this single table. Namely, instead of this format:
    001AMT1 I got this : 001 AMT1 ? (note empty space before A)
    Conclusion: LTRIM, RTRIM have to be employed when merging columns, among the rest, i.e., it is necessary to delete LEADING and TRAILING empty spaces that are not visible looking into column values....
    At least, this is my experience...

    Bye

  • RELEVANCY SCORE 2.67

    DB:2.67:Copy Rows Based On Data In A Cell cs


    i have a macro that copies a row based on a value. Is there a way I can have it copy these rows faster. I have thousands of rows that it has to go to in order to do this and it takes a while to run. If i were to do it manually, I would sort the sheet by
    the column i want the value from and then copy all the rows with that value. Is there a way to do this through a macro?

    DB:2.67:Copy Rows Based On Data In A Cell cs

    Perfect. With a little modification, it worked like a charm.

  • RELEVANCY SCORE 2.67

    DB:2.67:Selectbooleancheckbox Help Needed ck


    Hi all,

    I have to use Checkbox for each row of datatable with some unique value. I am able to generate the checkboxes based on the datatable, but could assing value based for each rows. Please provide any help in usage of check boxes for such case. Thanks in advance.

    Mruthyunjaya

    DB:2.67:Selectbooleancheckbox Help Needed ck

    perhaps this helps you:
    http://www.jenia.org/TestDataTools/

  • RELEVANCY SCORE 2.67

    DB:2.67:Update Table1 Based On Calculated Values From Table2 99


    HOW can I update Table1 based on calculated values from Table2? Sample tables:
    Table1:
    TAXOR SNAME SAND
    Alfisols ? ?
    Andisols ? ?

    Table2:
    TAXOR SNAME SAND
    Alfisols A 1.10
    Alfisols B 2.23
    Alfisols A 3.90
    Alfisols A 1.80
    Alfisols B 4.00
    Alfisols C 2.00
    Andisols E 1.10
    Andisols E 2.30
    Andisols F 1.00
    DESIRED RESULT FOR TABLE1:
    TAXOR SNAME SAND
    Alfisols A 2.505
    Andisols E 1.466
    Steps for calculating SNAME:
    Foreach unique TAXOR:
    - Count all unique values in SNAME
    - Get the largest among the values
    - e.g. A = 3; B = 2; C = 1 for Alfisols; so Alfisols' SNAME = A
    Andisols' SNAME: E = 2; F = 1; so Andisols' SNAME = E

    Steps for calculating SAND:
    FOR EACH UNIQUE TAXOR:
    - Alfisols average: (1.10 2.23 3.90 1.80 4.00 2.00) / number of rows of Alfisols
    - Andisols average: (1.10 2.30 1.00) / number of rows of Andisols
    I'm thinking of creating an array to store each unique value for SNAME. But there are over
    2,000 unique values! while total number of table2 rows is over half a million.
    I'm currently doing this in T-SQL since the tables are stored in SQL Server 2008. But there
    are over 100 fields to calculate; quite tedious to individual update the fields for each TAXOR.
    Is there a better way to update Table1 using C# and ADO.NET? I still have several tables to
    update having the same scenario. Any suggestion is very much appreciated.

    DB:2.67:Update Table1 Based On Calculated Values From Table2 99

    My pleasure! :-)

    Best Regards,
    Lingzhi Sun
    MSDN Subscriber Support
    in Forum
    If you have any feedback on our support, please contact
    msdnmg@microsoft.comPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

  • RELEVANCY SCORE 2.67

    DB:2.67:Color Report Rows Based On A Value In That Row s7


    I would like to Color report rows based on a value in that row.

    For examplle with the "EMP" table:

    I would like job=MANAGER to be red and job=CLERK to be green etc etc

    The other example I found only had the option of one color either the highlight or the default color.

    I am looking for a way to do multiple colors.

    DB:2.67:Color Report Rows Based On A Value In That Row s7

    ATD,

    Hi!
    This seems to be a simple fix, but for some reason I cannot get my row to change colors. Can you spot anything that I've missed?

    Source Query:
    select DISTINCT
    decode(gc.quarter_num, 1, 'red'
    , 2, 'green'
    , 3, 'yellow'
    , 4, 'aqua'
    , 5, 'gray') BG_COLOR
    , period_start_date
    , period_end_date
    from xxgl.gl_calendar gc
    where gc.period_start_date trunc(sysdate)
    order by period_end_dateI copied the Standard template to my own.
    ON Before Each Row I have:
    (I added the 2nd #BG_COLOR# to see if it would display the data value correctly)
    tr style="background-color:#BG_COLOR#;"#BG_COLOR#My report region is set to my new template. I thought maybe the td settings were overwriting, so I also removed the class reference from the Column Templates.

    When I display the page, nothing, all same background colors (white). The second #BG_COLOR# simply displays as #BG_COLOR# x #rows, before all the rows are displayed.

    Thanks,
    Janel

  • RELEVANCY SCORE 2.66

    DB:2.66:Grid Vs Datagrid ==Pivot { Database Rows As Column } Grouped By Unique Value In Row f1


    Data Model:
    A Document contains one are more Recordings and unique identifier.
    Document Template defines the tabular format of recordings defining sequence of Recordings.
    UI Design:
    Document1|Document2 ......{dynamic number of column}
    {Static number of rows
    as pertemplate } ----------------------------------------------------------------------------------
    RECORD1 Name: value of recording1 in doc1 | value of recording1 in doc2
    ----------------------------------------------------------------------------------
    RECORD2 Name: value of recording2 in doc1 | value of recording2 in doc2

    Database model :
    Each value in above tabular column is a row in the database and one item in observable collection.
    Question :
    Is this solution possible using a data grid? Give me directions ?
    My solution :
    Used grid layout , create dynamic rows based on count of recording on template .
    Generate columns based on distinct documents available.
    Bind items in Observable collection in textbox and add it as content to that column by setting Row Column attached property of the text.
    My problem:
    I have to write code for Column Header / Resizing etc... as Grid Layout does nt support these.
    Any suggesion are welcomed..

    DB:2.66:Grid Vs Datagrid ==Pivot { Database Rows As Column } Grouped By Unique Value In Row f1

    Hi Ming Xu,

    You solution works well and i understand the data transformation you are performing.
    As per your design, OriginalSampleData contains many attributes like record1,record2,record3.
    But in my problem domain , OriginalSampleData will contain only one attribute say VALUETEXT,I will have three objects of
    OriginalSampleData, which has to be pivoted by the document id?
    Click here to view my
    Data Model
    I need to use other attributes like cancelled to add image on datagrid cell. ?
    All i want to achieve is Every row \ object in the originalsampledata is datagrid cell ?

  • RELEVANCY SCORE 2.66

    DB:2.66:Urgent- Copy Rows Into A Separate Sheet Based On A Column Value aa


    Hello All,

  • RELEVANCY SCORE 2.65

    DB:2.65:Fetch Rows From Multiple Tables With Same Value In A Column 7k


    Hi,
    I get product details in a DataTablefrom a webservice thathas 4 columns.
    RowId (unique), ProductId,SubProductId, Price
    Iget a DataTable from webservice in batches.It can return only 5000 rows at a time. I pass Start RowId and End Row Id as parameters so that products within that range is returned in a datatable. Row Id is unique but same ProductIdcan
    be in multiplerows.
    If I call the webservice method three times, I get 3 Datatables with 5000 rows in each table.
    I want to get the rows with same Product Id from all the three tables and get the maximum price.
    Can I merge 3 table into one table and loop through orcan I use LINQ query to fetch data from multiple tables?

    How to store themax price of each product in a new table?
    Thanks
    Ashok

    DB:2.65:Fetch Rows From Multiple Tables With Same Value In A Column 7k

    Hi
    Thanks for your response. The web service is a third party web service and I can use the web methods exposed by them.
    The number of tables returned will be dynamic. I wil try to merge the tables and get the max price.
    Product Id is not passed as a parameter. The response datatable will have the details of all the products and I have to fetch the rows with same product id and get max price. I use the below code to get the data.

    int responsecount = objWebservice.GetProductDetailsReCCount(ProjectId);
    int loop = responsecount / 5000; //get the number of batches
    if (responsecount % 5000 != 0)
    loop = loop 1; // remainder is greater that 0 then increment the batch by 1
    int startrecordId = 0;
    int lastrecordid = 5000;



    for (int i = 0; i loop; i)
    {
    dataTable = objWebservice.GetProductDetailsPaged(startrecordId,Lastrecordid)
    startrecordId = dataTable.Rows[0][0]
    lastrecordid = dataTable.Rows[dataTable.Rows.Count - 1][0]
    }

  • RELEVANCY SCORE 2.65

    DB:2.65:Coloring Datagrid Rows Based On Value Inside Of Dataset pm


    HiI amdevelopingawindowsapplicationthatconnectstoasqldatabase.Ihaveadatagridthathasadatasourceofadataset.Iamtryingtocolortherowsofthedatagridbasedonavalueinsideofthedataset.IhavereadthearticleCustomizingtheWindowsFormsDatagridandIamhavingtroublefiguringoutwheresomeofthecodethathasbeenprovidedneedstogo.Anyassistancewouldbegreatlyappreciated.Thanks

    DB:2.65:Coloring Datagrid Rows Based On Value Inside Of Dataset pm

    hi, wheredoiputthiscodefrom.Anyparticulardatagridevent.Itriedtoputitinaprivatemethodsissays_myGrid(mygridINMYEXAMPLE)isDOESNOTCONTAINDEFINITIONFORROWS

  • RELEVANCY SCORE 2.65

    DB:2.65:Filter Row - Copy It - And Paste At The End Of Empty Row On Another Work Book. cd


    Hi all,

    I am using a macro to filter out records based on a value on one of the column in book 1.
    I will manually copy the filtered rows and paste in to another worksheet in book 2.
    Say on Day 1 I have copied 55 rows to book 2,
    on day 2 I will copy for eg. 65 rows and paste below the above copied rows on day 1.

    Since I am doing this every day, I need to find the last empty row and paste the filtered rows.
    Can macro help to find the last empty row and paste the filtered rows on to book 2.
    Please help.
    Thanks.
    NM.
    NM

  • RELEVANCY SCORE 2.65

    DB:2.65:Sql Query Based On Selected Items In Listview dm


    Hi, I wonder if it's possible in a sql query to select only the rows from my DB which are selected in my listview? Scenario = The user has selected a couple of items in the listview and when the user presses a button I want only those rows in a select query. Each row in the database table has a unique identity value.

    DB:2.65:Sql Query Based On Selected Items In Listview dm

    I found a way to get what I wanted and I thought I might post it here in case someone else will ever need this function aswell. In my SQL query I selected EVERYTHING from the table that is bound to the client like this - string GetData = SELECT Note, Signature, Date FROM Notes WHERE ClientID=@ClientID; And then to display only the rows that were selected in the listview I did it like this - try { con.Open(); adapter.Fill(dtSet, Notes); foreach (DataRowView objDataRowView in listview1.SelectedItems) { //Do something with the rows } However, it would've been more optimized to ONLY select the selected rows in the query.. less data to fetch - but this does the job! Michael

  • RELEVANCY SCORE 2.65

    DB:2.65:Attach Value To Every Row In Database Based On A Separate Row s7


    Hello,

    I have a database with 36 columns. Every time a form is submitted there are at least 26 rows associated with each form, with some forms having 28 rows, so the number of rows in not constant with each form. Is there a way to create a new column coded to read column "vcObjectName" so that if any row in that column equals "New York Target", grab the value from column "vcAnswerValue" which will have a value of either "Yes" or "No", then attach that Yes or No to every other row associated with that form that was submitted in a new column.

    The forms will be unique associated by a person's name and date submitted.

    Thanks,
    Phil

    DB:2.65:Attach Value To Every Row In Database Based On A Separate Row s7

    You guys are smarter than you think :)

    That worked....that's where it was failing at.

    Thank You!!!!

  • RELEVANCY SCORE 2.64

    DB:2.64:Query Duplicate Rows From Ms Access Database df


    Hi,
    I am developing an web application using ms access2010 database with php5.4. There is a table I am trying to display data from a table to php webpage where all columns are containing duplicate data except the ID. I want to display those information which
    are containing only the duplicate emails. I used the following query to retrieve data for unique Email like -
    SELECT DISTINCT Email, Name, Address, Phone from Cust_Table Where Id=132
    Here the field Name, Address and Phone also contain duplicate value but I want to retrieve rows based on eliminating the Emails. But the above query returns duplicate rows.
    Could anybody please tell the reason and the possible way to do what I want.

    DB:2.64:Query Duplicate Rows From Ms Access Database df

    Dear Zhang,
    Thanks again for replay.
    I tried your query but unfortunately the following error is coming-Warning: odbc_exec() [function.odbc-exec]: SQL error:
    [Microsoft][ODBC Microsoft Access Driver] Undefined function 'DISTINCT' in expression., SQL state 37000 in SQLExecDirect in .............. on line 126.
    And another thing is that I must filter the Id i.e. have to use the where clause to get distinct information for that specific Id.

  • RELEVANCY SCORE 2.64

    DB:2.64:Copy Rows From One Table To Another 71


    Hi together,i'm facing a problem while using procedures to copy different data from one table to another and hope that somebody can help me fast.For testing, i created two tables:CREATE COLUMN TABLE "ADAM_TEST"."TEST1" ("ID" INTEGER CS_INT NOT NULL , "VALUE" VARCHAR(255), PRIMARY KEY ("ID"));CREATE COLUMN TABLE "ADAM_TEST"."TEST2" ("ID" INTEGER CS_INT NOT NULL , "VALUE" VARCHAR(255), "STREET" VARCHAR (255) null, "ZIP" VARCHAR (255) null, PRIMARY KEY ("ID"));Here is my procedure:CREATE PROCEDURE _SYS_BIC.WRITE_TEST ( )LANGUAGE SQLSCRIPTASBEGINstatement = SELECT ID,VALUE FROM ADAM_TEST.TEST1;INSERT INTO ADAM_TEST.TEST2 (ID,VALUE) SELECT ID,VALUE FROM :statement ;END;Now i want to copy the rows (ID,VALUE) from Test1 to table Test2, but everytime i get an error:_SYS_BIC.WRITE_TEST: line 10 col 1: [301] (range 3) unique constraint violated exception: unique constraint violated: Table (TEST2).I read the manual from SAP and tried to find another discussion with a similar error, i also tried to change the query like make the last part:SELECT * FROM :statement;but nothing helps.If i delete the two additional rows (STREET,ZIP) from table definition and try the procedure, it works!So what's the error here? The table types are the same....Thanks a lot for your help.

    DB:2.64:Copy Rows From One Table To Another 71

    Just to add up you want to use this generic procedure to do the same ( Any schema and Any Table )SAP HANA: Generic Procedure using Arrays to Load delta data into Tables (You can use Delta Type = 'FULL' )Regards,Krishna Tangudu

  • RELEVANCY SCORE 2.64

    DB:2.64:Retrieve Rows za


    Hi Pals,

    how to retrieve similar rows from table A and table B based om a unique field.

    thanks in advance

    DB:2.64:Retrieve Rows za

    user633962 wrote:
    Hi Pals,

    how to retrieve similar rows from table A and table B based om a unique field.

    thanks in advanceSo, you have two tables A and B and you want to find rows that match based on a unique field in each of them?

    That's called a Join.

    select *
    from tableA join tableB on (tableA.uniquecolumn = tableB.uniquecolumn)If you mean something different, please post your database version, some sample data and your expected output.

  • RELEVANCY SCORE 2.64

    DB:2.64:Selecting Unique Rows Based On Multiple Criteria af


    Hi,
    I have a small problem in trying to get unique rows based on multiple fields. The query I have is as follows:

    select SN.UPC, SN.DESCRIPTION, SN.NewShelf, SO.OldShelf, SN.NewPosition, SO.OldPosition
    from SN inner join SO on SN.UPC = SO.UPC and SN.NewShelf SO.OldShelf
    where SN.NewShelf 0 and SO.OldShelf 0

    DB:2.64:Selecting Unique Rows Based On Multiple Criteria af

    can you provide sample data and explain more? I don't understand very well of what's your situation.This posting is provided AS IS with no warranties, and confers no rights.

  • RELEVANCY SCORE 2.64

    DB:2.64:Duplicate Rows Eliminate 87


    Hi, I am having a doubt how to eliminate duplicate rows and load only unique rows.
    I have a text file

    DB:2.64:Duplicate Rows Eliminate 87

    hi mmonline, Please close the thread if your query is answered.Hope this helps !! - Sudeep

  • RELEVANCY SCORE 2.64

    DB:2.64:How To Highlight Rows Based On A Cell, And Copy Original Row Down Same Number Of Rows f1



    Hi,

    M spreadsheet contains 5,000 rows and column F contains a number greater than two; identifying how many rows are needed. The above macro adds the correct number of additional rows (i.e., if columnF has the number 11 listed, the macro would add 10
    additional rows so there would be 11 rows - including the original row). This macro continues until it adds all necessary additional rows for each original row of the spreadsheet.

    What I need help with, is i want to highlight the newly insert rowswith any colour using the above macro and the original row remains the same.

    Thanks,

    Sub website()
    Dim lngStartRow As Long
    Dim lngEndRow As Long
    Dim m As Integer
    Dim n As Long
    With ActiveSheet
    'work from bottom up
    'set start row
    lngStartRow = Range("f" CStr(Application.Rows.Count)).End(xlUp).Row
    'set end row
    lngEndRow = 1

    'loop through all used rows in column E starting at bottom
    For n = lngStartRow To lngEndRow Step -1
    If IsNumeric(Range("f" CStr(n)).Value) Then
    'insert rows below
    For m = 2 To Range("f" CStr(n)).Value
    Rows(n).Copy
    Rows(n + 1).Insert
    Next m
    End If
    Next n
    End With
    End Sub

    DB:2.64:How To Highlight Rows Based On A Cell, And Copy Original Row Down Same Number Of Rows f1

    Insert the following above the line Next m:

    Cells(n + 1, "E").Value = Cells(n, "E").Value + _
    Range("F" n).Value - m + 1

  • RELEVANCY SCORE 2.63

    DB:2.63:Datagridviewcomboboxcolumns 7p


    I am using a DataGridView which has some DataGridViewComboBoxColumns these columns point to a different dataview. when I set the datasource using a filtered dataview all appears well but sometimes when the combo is changed, the datagrid view is populated
    with an incorrect value. This only seems to happen when the unfiltered data for the Combo contains multiple rows with the same value that would be assigned to the DisplayMember of the parent Datagridview.

    for example (simple example)

    a datagrid of customers
    name Country Shipping Town

    country Shpping town being combos based of foreign keys of dataview of the country and town tables. obviously the combo of shipping towns is filtered to only show those in the corresponding country. If table of shipping towns contains two entries for
    Torquay, one in England and one in Australia, when the customer whos country is England is presented with all of the Shipping Towns in England, if Torquay is selected the value returned to the parent datagridview is the key value for Torquay in AUSTRALIA even
    though the filtered dataview for the combo didn't even contain that value. this only happens if the dataview column used as the displaymember for the Combo contains duplicate values.
    because the grid is bound, the data being updated is incorrect, apart having to make all Shipping towns unique, can anyone help?

    DB:2.63:Datagridviewcomboboxcolumns 7p

    I am using a DataGridView which has some DataGridViewComboBoxColumns these columns point to a different dataview. when I set the datasource using a filtered dataview all appears well but sometimes when the combo is changed, the datagrid view is populated
    with an incorrect value. This only seems to happen when the unfiltered data for the Combo contains multiple rows with the same value that would be assigned to the DisplayMember of the parent Datagridview.

    for example (simple example)

    a datagrid of customers
    name Country Shipping Town

    country Shpping town being combos based of foreign keys of dataview of the country and town tables. obviously the combo of shipping towns is filtered to only show those in the corresponding country. If table of shipping towns contains two entries for
    Torquay, one in England and one in Australia, when the customer whos country is England is presented with all of the Shipping Towns in England, if Torquay is selected the value returned to the parent datagridview is the key value for Torquay in AUSTRALIA even
    though the filtered dataview for the combo didn't even contain that value. this only happens if the dataview column used as the displaymember for the Combo contains duplicate values.
    because the grid is bound, the data being updated is incorrect, apart having to make all Shipping towns unique, can anyone help?

  • RELEVANCY SCORE 2.63

    DB:2.63:Re: Master-Detail On One Table fk


    You can probably do it, but you would have to write your own code for the master-detail triggers. Block A1 could select only rows where Name is not null (and comment is null), and Block A2 could select only rows where Name is null (and comment is not null) for the same ID.

    You would need to enforce comment being not null on Block A2 input rows. And you would need to enforce unique rows in Block A1 where ID is unique where comment is null.

    I would not copy Name to each detail record. Name should only be entered on the row where comment is null.

    So... you can do it, but why not just create two tables, and keep life simple? Oracle works well with the two-table relationship, and you would be doing lots of extra work trying to mimic the process but using only one table.

    DB:2.63:Re: Master-Detail On One Table fk

    Hi Ashok!
    I want to enter job in the previous block field only and other details in detail block. It is posible when table havn't NOT NULL columns.
    Drop EMP_PK primary key and set EMPNO column nullable.
    Then add ALIAS for subquery:
    (select distinct job from emp ) emp_alias
    Set Column Name JOB item property = "emp_alias.job".
    Set emp_master block properties:
    DML Data Target Type = "table"
    DML Data Target Name = "EMP emp_alias"

  • RELEVANCY SCORE 2.63

    DB:2.63:How Can I Copy Only Certain Columns Of Visible Rows After Applying A Filter To Another Column Within The Data Range pc


    I've adapted the code below from another macro that was successful, however it's not working for me in my new macro, I believe, because of one small change.

    The original macro was intended to filter source data based on the criteria in one column, then copy all resulting visible data to another page (destination).
    However, for this application, I want to filter based on the value in column AF (column #32), but copy only the first 6 columns (A-F) of the resulting visible rows and paste thse values into the destination sheet. If I allow it to copy all columns, it works
    (that is, it does the copy of all 32 columns for the filtered rows and pastes them into my destination sheet). However, when I try to limit the copy to the first 6 columns (which is the only data I need to move), it's not copying anything.
    Can anyone help me either adapt this code or find another way to do what I want?
    Thanks!

    ' Find Last used row on download (source) page
    SourceSh.Select
    LRSource = Range("A" Rows.Count).End(xlUp).Row
    'Set filter range on ActiveSheet
    Set My_Range = Range("A15:AG" LRSource)
    My_Range.Parent.Select
    'Remove the AutoFilter
    My_Range.Parent.AutoFilterMode = False
    'Filter and set the filter field and the filter criteria :
    My_Range.AutoFilter Field:=32, Criteria1:="=C"
    With My_Range.Parent.AutoFilter.Range
    On Error Resume Next
    ' Set rng to the visible cells in My_Range without the header row
    Set rng = .Offset(1, 0).Resize(.Rows.Count - 1, 6) _
    .SpecialCells(xlCellTypeVisible)
    On Error GoTo 0
    If Not rng Is Nothing Then
    'Copy and paste the cells into DestSh below the existing data
    rng.Copy
    With DestSh.Range("A" LRDest + 1)
    .PasteSpecial xlPasteValues
    Application.CutCopyMode = False
    End With
    End If
    End With

  • RELEVANCY SCORE 2.63

    DB:2.63:Sort Xml cm


    I have an xml file that I need to add an additional
    sort by value (ascending). I want to sort IndexRate as well.Your help is greatly appreciated.I believe I need to sort uniqueRows because that's where I'm getting the data from ultimately, here's the code:
    private
    static
    string
    ConstructYieldTable(ListXElement

    rows)
    {

    StringBuilder
    sb = new
    StringBuilder

    ();

    // space above

    sb.AppendLine(

    LPAR PBCAMGTI=\[G]LP6\/LPAR

    );

    // this is bit convuluted but to explain:

    // the xml gives every cell (price yield unit) inside that node is

    // class, scenario, detail

    // the attr of scenario has what column it goes in

    // so first we want to get a distinct number of colums

    // by grouping based on the column %

    // so if we have, 1, 1, 1, 2, 2, 2, 3, 3, 3

    // this will result in 1, 2, 3 (the first element out of that group of course)

    ListXElement
    uniqueColumns = rows.GroupBy(row = row.Element(SCENARIO).Attribute(_PrepaymentSpeedValue

    ).Value).Select(speed = speed.First()).ToList();

     

    // now we want the number of unique ROWS, we have our unique column values

    // and we only need to test the first one

    ListListXElement
    uniqueRows = new
    ListListXElement

    ();

    bool
    isSingleRow = false

    ;

    // single row tables do not contain this attribute

    int

    maxDecimalPlace = 0;

    if
    (rows[0].Element(SCENARIO).Attribute(_IndexRate)
    == null

    )
    {

    isSingleRow =

    true

    ;
    uniqueRows.Add(rows);
    }

    else

    {

    // if it does have multiple rows

    // then we need to do some crazy selects based on the

    // stub percentage

    ListXElement
    rowEl = rows.GroupBy(row = row.Element(SCENARIO).Attribute(_IndexRate

    ).Value).Select(per = per.First()).ToList();

    Liststring
    rowPers = new
    Liststring

    ();

    foreach
    (var
    r in

    rowEl)
    {

    string
    per = r.Element(SCENARIO).Attribute(_IndexRate

    ).Value;

    if
    (per.IndexOf('.'

    ) == -1)
    {

    per =

    .0

    ;

    //MessageBox.Show(per);

    }

    if

    (!rowPers.Contains(per))

    {
    rowPers.Add(per);
    }
    }

    MessageBox

    .Show(rowEl.ToString());

    foreach
    (var
    p in

    rowPers)
    {

    // MessageBox.Show(p);

    if

    (p.Length maxDecimalPlace)

    {
    maxDecimalPlace = p.Length;
    }

    uniqueRows.Add(rows.Where(n = n.Element(

    SCENARIO).Attribute(_IndexRate

    ).Value == p).ToList());

    }
    }

    DB:2.63:Sort Xml cm

    hahaha, oh wellJohn Grove, Senior Software Engineer http://www.digitizedschematic.com/

  • RELEVANCY SCORE 2.62

    DB:2.62:Create And Display Table Columns On Weekly Basis Based On Rows 1j



    Hello all,

    Thanks in advance for replying my post.

    we have one example scenario, that we need to display table columns with week number and that based on date value in the table rows (note: the date value will see only we can bind rows on table).

    Will anyone has tried attempted this situation or any instruction please suggest to us.

    Thanks..

    DB:2.62:Create And Display Table Columns On Weekly Basis Based On Rows 1j


    Hi Robin,

    Your input helps me. Thanks a lot for solving my issue.

    -Ganesh

  • RELEVANCY SCORE 2.62

    DB:2.62:Data Block Problem 3k


    Hi all,

    Here's a simplified version of my problem.

    I have a data block which is based on a table. There are two columns (Col1 and Col2)
    displayed on the block. When i execute the query, it returns with two
    rows with duplicate values in Col1. How do i get rid of the duplicate col1 value in
    the block and only show 1 record?

    Basically i want to have distinct col1 values.
    I've also tried putting a group by col1 clause in the where clause but that doesn't work.

    Is there anything in the property palette of the data block i can set to only return
    unique col1 values?

    rgds

    DB:2.62:Data Block Problem 3k

    Hi all,

    Here's a simplified version of my problem.

    I have a data block which is based on a table. There are two columns (Col1 and Col2)
    displayed on the block. When i execute the query, it returns with two
    rows with duplicate values in Col1. How do i get rid of the duplicate col1 value in
    the block and only show 1 record?

    Basically i want to have distinct col1 values.
    I've also tried putting a group by col1 clause in the where clause but that doesn't work.

    Is there anything in the property palette of the data block i can set to only return
    unique col1 values?

    rgds

  • RELEVANCY SCORE 2.62

    DB:2.62:Dataset Rows Unique Value mj


    Hi. Is there a quick way to put unique value to column in a table? Assuming I want numeric values starting from 0.

    DB:2.62:Dataset Rows Unique Value mj

    dr.items(thecolumn) = Guid.NewGuid
    Success
    Cor

  • RELEVANCY SCORE 2.62

    DB:2.62:Dataflow Task Ado.Net Destination Error Output Not Getting All Error Rows p8


    Here's my situation. I have process that deletes old data from 5 related databases. Because of time and performance constraints I am deleting a maximum of 1000 rows per run. The process is like this:

    Load a shared staging table with the rows to be deleted - the rows processed previously are kept at this time.
    Call a child package to delete the rows from one database that has about 10 tables affected.

    Read the rows from the staging table into memory Loop over the object variable running stored procedures that delete the rows for that key value
    Mark the row as processed in the staging table
    Call a child package to delete rows from database 2

    Dataflow task that copies the rows from the source to another staging table Within a transcation Execute SQL Tasks that call SP's that delete from 48 tables by joining on the staging table
    Mark the rows as processed in the local staging table and in the shared staging table

    In parallel run 4 Dataflow Tasks that copy the data from the shared staging table into local staging tables in 4 small databases -
    this is where I am seeing a problem Each of these dataflow tasks has this flow:

    OLE DB Source RowCount to get the # of rows selected from the source ADO .NET Destination with any errors redirected to the error output RowCount on the error output to get a count of errored rows Script Component to get the error description from the error code ADO .NET Destination to log the error information

    There are 2 problems with Step 4:

    The error description is useless -
    error has occurred while sending this row to destination data source. I only get one row logged for an error and, using a linked server, I am checking for rows not inserted into the local staging tables I am seeing hundreds of rows not inserted, but getting
    only one row logged as error.

    I'd love to have a better error description, but I can live without that. The real issue is why aren't all the rows that are not inserted being logged?
    Here's some things I have tried.
    There is a unique constraint on the table so I specifically tried to resend 10 rows that would cause a unique constraint error and they ALL got logged.
    I ran a trace while running the process to try to see if I could get a better error message, but all I see is The statement has been terminated. And the last run I had traces on 2 of the databases and I only got the error on one, even though both
    had missing rows.
    I have checked the SQL Server logs and there are no errors there either.

    Any suggestions on what to look at next? I prefer to not change to an OLE DB Destination at this point. I should also not that I had been running this process multiple times per day without any errors for several days (17000 rows) before I started
    getting errors.
    Lastly, I can re-run the process just for the rows that did not transfer and thus far they have transferred without error, so it isn't unique constraint errors that are causing the problem.

    Jack Corbett MCITP: SQL Server 2008 Administration

    DB:2.62:Dataflow Task Ado.Net Destination Error Output Not Getting All Error Rows p8


    Hello Jack,
    it seems the reason for the The real issue is why aren't all the rows that are not inserted being logged? is in that you enabled a batch processing like you said to 1K rows, the remedy thus would be in using just a one row processing. Reason is when SSIS
    is processing a batch or records, if even one record within the batch errors out the entire batch gets disqualified.
    Now the error description error has occurred while sending this row to destination data source contains more verbiage than that and perhaps not the only one, most importantly it has
    an error number based on which you can deduce the root cause of the error.

    Arthur My Blog

    Arthur,
    Thanks for the answer, but you misinterpreted my mention of 1000 row batches. The entire process is working on 1000 rows out of 30000 that will eventually be purged. The destination components are not set to a batch size of 1000, but are processing
    each row individually. I can see this because each row creates an SQLBatch in the traces I am running. Also there are rows being inserted successfully until the error, which would process rows until the error is thrown and then stop so I might
    get 800 of 1000 transferred.Jack Corbett MCITP: SQL Server 2008 Administration

  • RELEVANCY SCORE 2.62

    DB:2.62:I Need To Insert A Varaible Number Of Rows Based On A Value In A Cell. am


    I need to insert a varaible number of rows based on a value in a cell. I have a worksheet that feeds a mail merge in word to create labels. however I can only get 1label to print per row in excel. Each row contains a quantity field and the value of this
    cell must determine how many duplicate labels need to print.So, I am thinking I need to look at each row, and if the Qty 1 insert Qty-1 rows and then copy the oringinal line down Qty-1 times (into inserted roes)this must happen for each row in the table.
    Any help to make this happen in vba would bevery appriciated. (please assume i am an idiot, and you may be pleasently supprised). Also if this easier to to do in Word, letme know, however the mailmerge template is company standard.

    DB:2.62:I Need To Insert A Varaible Number Of Rows Based On A Value In A Cell. am

    I need to insert a varaible number of rows based on a value in a cell. I have a worksheet that feeds a mail merge in word to create labels. however I can only get 1label to print per row in excel. Each row contains a quantity field and the value
    of this cell must determine how many duplicate labels need to print.So, I am thinking I need to look at each row, and if the Qty 1 insert Qty-1 rows and then copy the oringinal line down Qty-1 times (into inserted roes)this must happen for each row in the
    table. Any help to make this happen in vba would bevery appriciated. (please assume i am an idiot, and you may be pleasently supprised). Also if this easier to to do in Word, letme know, however the mailmerge template is company standard.

    I would do this in a "non destructive" fashion by putting theresult in a separate worksheet. So, suppose the number of labels you want for each row is in the first column and the data start with row 2 (row 1 being a header).
    Use the code below to delete an old worksheet named "Rows for Mailmerge", create a new worksheet by the same name, and put the repeated rows in this worksheet.
    Put the code below in a standard module and run the duplicateRows subroutine.

    Option Explicit
    Const cTempWSName As String = "Rows for Mailmerge"
    Sub deleteTempWS(WB As Workbook)
    On Error Resume Next
    Application.DisplayAlerts = False
    WB.Worksheets(cTempWSName).Delete
    Application.DisplayAlerts = True
    On Error GoTo 0
    End Sub
    Sub duplicateRows()
    Dim Rng As Range: Set Rng = Selection.CurrentRegion
    deleteTempWS ActiveWorkbook
    Dim NewWS As Worksheet: Set NewWS = ActiveWorkbook.Worksheets.Add()
    NewWS.Name = cTempWSName
    Dim FreeRow As Long: FreeRow = 1
    Rng.Rows(1).Copy NewWS.Cells(FreeRow, Rng.Column)
    FreeRow = 2
    Dim I As Long
    For I = 2 To Rng.Rows.Count
    Rng.Rows(I).Copy NewWS.Cells(FreeRow, Rng.Column).Resize(Application.Intersect(Rng.Rows(I), Rng.Columns(1)).Value)
    FreeRow = FreeRow + Rng.Rows(I).Columns("A").Value
    Next I
    End Sub

  • RELEVANCY SCORE 2.62

    DB:2.62:Select Data For One Customer Across Multiple Rows In A Table 91


    I am hoping you can help explain whether something is possible or not as I only have basic level sql.

    We have 2 tables, one containing a summary view of an order (OrderSummary) and one that details each line that made up that order (OrderDetailLines). I need to produce a summary based
    on orders with specific ranges of items (itemcodes) purchased within one order in a date range. Is it possible to run a single query that can identify orders which have multiple items codes when the data is held in rows?

    An examplewould be: Select any orderids whose order contains all of the itemcodes '111111', 333333','444444' and date is between '14 aug 2010' and '20 aug 2010'
    Return a breakdown by channel of the number of unique customers, unique orders and the value of the total orders

    I will attach a spreadsheet with example table data as it doesn't like me pasting it here :-)

    Thanks in advance

    DB:2.62:Select Data For One Customer Across Multiple Rows In A Table 91

    Thanks Naomi, if the cte option doesn't work I will take a look at the blog - may look anyway just so I understand the issue as it is a weird one.

  • RELEVANCY SCORE 2.62

    DB:2.62:Sum Values In Column B Where Unique Value In Column A 88


    Hi all,

    I need help with a SQL query but first let me give some background information. I have a view that lists a series of projects and all instances in which hours were billed to that project. Selecting all rows from this view returns 11, 490 rows but selecting unique project numbers from the table only returns 771 rows due to the fact that the view was created to list all instances in which hours were billed to each project. How can I create a SQL statement that will sum the cost for each project returning only the unique 771 rows? any help would be greatly appreciated. Thanks.

    DB:2.62:Sum Values In Column B Where Unique Value In Column A 88

    You assumed correctly Anurag. That works great. Thanks.

  • RELEVANCY SCORE 2.62

    DB:2.62:Jtable Cell Renderer ca


    Hi folks,
    I have a unique problem. I have to populate the column (say col 3)
    with different cell renderers based on conditions. If the value of the col 2 is some string value then i put a checkbox with a diff Text.Else the string value is different then i have to put a diff checkbox or a combo. can i put different cell renderers for a single column on diff rows of the same column. If so plz give me the Code. Help its urgent.

    Thanks in advance.
    Arpana

    DB:2.62:Jtable Cell Renderer ca

    Thanks i will try this code and check out. I think this is what i was looking for. Many thanks to u.

  • RELEVANCY SCORE 2.62

    DB:2.62:How To Prevent Duplicate Values Showing In Parameters List ms


    In reporting services 2005 I'm creating a parameter which is based on a query.  I have a table with many rows and trying to use one of the columns as my parameter value options.  However there are only 6 unique values in te 900 rows of data... my parameter list is showing parameter for every row, and not limiting to the unique values only.How do I make sure that the parameters displayed are only the unique values within the column?

    DB:2.62:How To Prevent Duplicate Values Showing In Parameters List ms

    Thanks - That worked awesome... took me a while to adjust and work out for my data but I got it!

  • RELEVANCY SCORE 2.61

    DB:2.61:Find Unique Values In The Same Column Across Many Tables 1x


    Hi Folks,

    I'd like to have a little help populating a column with data. I have Tables 1 through 16, each on a different sheet. Column D on every sheet is "Duration." Most of the durations on each sheet are the same, but some vary. In a summary on a separate worksheet,
    I would like to create a formula for column A that examines column D in each of the tables (1 through 16), and the values
    unique to each table into the column.

    So, Table 1 may have some rows with a duration of 70. Table 2 may have several rows of duration 70 and one of duration 60. In this instance, I would like to end up with "70" in two rows, and "60" in one. The first "70" occurring in Table 1, the second
    "70" occurring in Table 2, and the "60" also occurring in Table 2. Here's what I mean:

    Table 1:
    Column A .... Column D
    Audi 70
    Saab 70
    Porsche 70

    Table 2:
    Column A ... Column D
    Cheetah 70
    Lion 70
    Zebra 60

    Summary Table:
    Column A
    70 (all in table 1 are 70)
    70 (some in table 2 are 70)
    60 (some in table 2 are 60)

    I tried using SORT Advanced Copy to another location Unique items only, but I got an error: You can only copy filtered data to the active sheet. I guess because they're Tables they're filtered data? I'm hopelessly clueless, if anyone could help
    I'd be very grateful. Thanks in advance!

    Edit: it'd be even greater if this could indicate in the next column (B) which Table (1 through 16) each value came from. Just shooting for the stars :)

    Cheers,
    Sarah

  • RELEVANCY SCORE 2.61

    DB:2.61:Write Macro To Copy From Sheet1 To Sheet2 Based On Value Selected From Drop Down Menu In Sheet2 sm


    I am looking for help writing a macro in excel that will copy rows from sheet1 when a value is selected from a drop down menu on sheet2.
    The workbook is set up with sheet1 as a database with all of the information and I want to use sheet2 to select avalue (located in column A)from a drop down and have the rows matching the valueon sheet1 copied to sheet2. There are about 200 values in
    the drop down menu and each have different amounts of rows in sheet1.
    I am a novice when it comes to writing macros so any input is appreciated.

  • RELEVANCY SCORE 2.61

    DB:2.61:Generatedvalue Within Embeddedid c1


    My company has a table that has a primary key of 5 columns, one of which is an auto-generated sequence. This was not always an auto-generated sequence, and previously was only unique for any combination of the first 4 columns, not unique for the entire table. Therefore, the primary key of the table cannot be simply changed to this one sequence column. However, the column is part of the primary key, and it is unique for any rows forward.

    My entity based on this table has an embedded id which encompases the five columns, one of which is the sequence column. Is it possible for me to use a sequence generator to generate the value for this column within the embedded id?

    Ive tried putting the necessary sequence annotations in the embedded object, but they are ignored. I dont believe there is any place to put the sequence annotations within the AttributeOverrides of the entity object. Therefore, I'm guessing the only way to populate the column will be for me to manually retrieve the next sequence from the database and set it myself. Is this correct?

    Thanks!

    DB:2.61:Generatedvalue Within Embeddedid c1

    My company has a table that has a primary key of 5 columns, one of which is an auto-generated sequence. This was not always an auto-generated sequence, and previously was only unique for any combination of the first 4 columns, not unique for the entire table. Therefore, the primary key of the table cannot be simply changed to this one sequence column. However, the column is part of the primary key, and it is unique for any rows forward.

    My entity based on this table has an embedded id which encompases the five columns, one of which is the sequence column. Is it possible for me to use a sequence generator to generate the value for this column within the embedded id?

    Ive tried putting the necessary sequence annotations in the embedded object, but they are ignored. I dont believe there is any place to put the sequence annotations within the AttributeOverrides of the entity object. Therefore, I'm guessing the only way to populate the column will be for me to manually retrieve the next sequence from the database and set it myself. Is this correct?

    Thanks!

  • RELEVANCY SCORE 2.61

    DB:2.61:Fuzzy Lookup 91


    Hello,I used Fuzzy lookup to combine data from different data sources. There are no unique IDs. Joining using names, which do not typically match, but I have now a problem which is my destination table contain only matched rows what I need to destination table contain
    Matched rows based on similarity I did
    Non-matched rows
    Unique rows
    Any suggest will be greatly appreciatedVolcano
    DATA is the Focus, Business is the Target”

    DB:2.61:Fuzzy Lookup 91

    HiThe Fuzzy Lookup transformation uses fuzzy matching to return one or more close matches from the reference table.This transformation has one input and one output. Only input columns with the DT_WSTR and DT_STR data type can be used in fuzzy matching.Refer this links for additional info ...http://www.sqlteam.com/article/using-fuzzy-lookup-transformations-in-sql-server-integration-serviceshttp://msdn.microsoft.com/en-us/library/ms137786.aspxhttp://msdn.microsoft.com/en-us/magazine/cc163731.aspxDoes this help ?ThanksanliS

    Best Regards,anliSBICPlease remember to mark the correct replies as answers

  • RELEVANCY SCORE 2.61

    DB:2.61:Dynamic Lookup Issue 88



    I have a simple mapping as source - dynamic lookup - update strategy - target table.Both sauce target tables are Teradata tables with two columns only. The target one has UNIQUE PRIMARY INDEX defined on the key field.PowerCenter Designer is version 8.1.1 SP3. Dynamic lookup accesses target table to see if a source row need to be inserted or updated based on NewLookupRow's value.I did the following.1. Checked Dynamic Lookup Cache (on transformation)2. Checked Insert Else Update (on transformation)3. Selected "Treat source rows" as "Data driven" (on session)4. Set Update Strategy Expression value to "IIF(NewLookupRow = 1, DD_INSERT, IIF(NewLookupRow = 2, DD_UPDATE))"First time it worked OK when the target table is empty. When it ran again with the same source, it failed on each row because it tried to insert, not update, each row into the populated table.How ever, the log file stated clearly that the lookup returned exactly # of rows that matched the one in target table.I took off the update strategy transformation, and wrote the rows directly into a new target table with an extra field to hold the NewLookupRow value. I saw all values in NewLookupRow being 0, which means the PowerCenter Server neither update nor insert the rows in the cache.I truncated the new target table and deleted 6 rows from the old target table which was used for dynamic lookup and ran one more time, I then saw 6 rows with NewLookupRow =1, while the remains still being 0.Any idea about this issue please?By the way, I have developed more than 10 mappings with similar logic without any problem. This is the only one caused me lots of headache.Many, many thanks in advance for any inputs that may help me to resolve this critical issue.

    DB:2.61:Dynamic Lookup Issue 88


    I guess you could also try checking the option, Update as Update in addition to Insert else Update. It may solve your problem. I too encountered the same problem sometime back.

    Thanks

  • RELEVANCY SCORE 2.61

    DB:2.61:Datatable Filter Rows cx


    Hi, there is a way to filter datable rows based on a column value without requery the database?

    Regards
    Gianni

    DB:2.61:Datatable Filter Rows cx

    Hi,
    Take a look at the below thread.Hope this helps.
    http://swforum.sun.com/jive/thread.jspa?forumID=123threadID=48823

    Thanks,
    RK.

  • RELEVANCY SCORE 2.61

    DB:2.61:Composite Primary Key -- 3f


    Hi all,

    My table have 12 colums. Only one column can have unique value.Other 11 coulms dont have unique values.for these 11 columns can i create composite primary key.if suppose i created any performance problem occur.

    reason 1:Based on these 11 columns i should fetch that 1 colun value.
    reason 2:this table dont have any key, or index.

    Thanks in advance

    Naveenukumar S

    DB:2.61:Composite Primary Key -- 3f

    Hi all,

    i created function based index for that two null value colums. after i created the composite index for that 11 columns.

    My Doubt is :

    some time i will fetch the value 7 columns.some time 6 columns. that time what will be the performance status.

    or

    should i create the nonunique index for these one or 11 columns .which one give better perofrmance.

    Thanks in advance
    NAveen

  • RELEVANCY SCORE 2.61

    DB:2.61:How To Stop And Reject Duplicate Records Insert k1



    Hi i have target table

    which had already some data

    example

    emp id emp role date

    1 manager 01/01/2012

    2 manager 01/01/2012

    1 clerk 02/08/2012

    and if my loading has the value of

    emp id emp role date

    1 manager 01/01/2012 (duplicate)

    2 manager 01/01/2012 (duplicate)

    1 sales 01/05/2013 (orginal)

    primary unique indexes on my target table are emp id manager and date

    so how can i stop inserting the duplicate rows into my target table

    and to insert only unique values with the following primay unique indexes................

    DB:2.61:How To Stop And Reject Duplicate Records Insert k1


    Hi Kranthi,

    Did you do any lookup on target ? If not than how can you identify a row which is already in table using any sql override which joins the target table?

    Can you paste the mapping flow of yours so that we can have better idea.

    Regards

    Shirish

  • RELEVANCY SCORE 2.61

    DB:2.61:Copy Selected Rows To Clipboard From Swing Jtable ks


    Hello, I can copy table rows to clipboard by:
    jTable1.getTransferHandler().exportToClipboard(jTable1, getToolkit().getSystemClipboard(), TransferHandler.COPY);How can I copy only selected rows to clipboard? Please help..

    Thanks,

    DB:2.61:Copy Selected Rows To Clipboard From Swing Jtable ks

    As far as I know, there is no specific support for this action.
    So you have to manually collect the selected rows and transfer them with Clipboard.setContents(...).

  • RELEVANCY SCORE 2.60

    DB:2.60:Setting A Unique Value From More Than One Field 98



    Hi everyone,

    it's fairly easy to have a single field being unique in order to define a record as being unique in a table. But how to define a record being unique based on more than one field ? This key will not be used to create a relationship, only to ensure a record will not be created twice. Looking in the discussions I found out the suggestion of creating a calculation field whose content is the concatenation of the many fields needed to define a record as unique, but the thing is a calculation field can't be made unique, or I really missed something . This is for FMP 13.

    Thanks

    Gilles Plante

    DB:2.60:Setting A Unique Value From More Than One Field 98


    "John" might not be unique, "Smith" either, 4/15/1980 either, but what the OP needs is the combo of this 3 to be unique. Of course if all 3 are unique the combo will be, too, but it's not mandatory as per OP problem.

  • RELEVANCY SCORE 2.60

    DB:2.60:Integrity Constraint 'Unique' 11


    Integrity constraint 'unique' is meant to ensure that a column will always have unique value in each row. However, insertion of rows with null values for a column which has been declared as 'unique' is possible. Further, insertion of rows with null values in a column of another table declared as foreign key which references this column (declared as 'unique') also becomes possible! Why so? Will this be addressed?

    DB:2.60:Integrity Constraint 'Unique' 11

    This is the expected behaviour which does not need further addressing.
    If you do not want NULL values, either make that column list a primary key or define a NOT NULL constrant on them.

    You have just highlighted one of the differences between a primary key and a unique constraint.

  • RELEVANCY SCORE 2.60

    DB:2.60:Adding The Rows And Populating The Dropdown Values Dynamically Into The Wpf Datagrid 11


    Hi Bruce,You suggestion of using the Container works fine...But the problem is still i am getting the display value in the container...For me display value and member value are different.I should be able to get the member value in the converter. Rightnow i am getting only the display value, but the dislay value may not be unique for me

  • RELEVANCY SCORE 2.60

    DB:2.60:Conditional Display Of Linear Guage Based On Value Of Another Column kx



    I have a column that uses a linear guage. It contains percentage data in most rows but in some rows there is finance data which is not a percenatge.

    There is another column called 'indicator' which sometimes includes the value 'finance' and I want the guage to be visible only where the value of this field is not finance.

    Could anyone advise how I might do this?

    ThanksLeslie

    DB:2.60:Conditional Display Of Linear Guage Based On Value Of Another Column kx


    If you are using a straight table, then yes, in the chart properties, Presentation tab you have a "Conditional" for each column being displayed. If you are using a pivot table, then use some conditional to show the value or nothing depending on the case. A very basic example without knowing about your data model, assuming "Field" is a dimension in your would be

    Sum({ Field -= {'Finance'} } Sales)
    If "Finance" is the result of an expression labeled as "Indicator", then

    Sum(If([Indicator] 'Finance', Sales)) or If([Indicator] = 'Finance', null(), Sum(Sales))
    Depending on what you want to show.

    Hope this helps

  • RELEVANCY SCORE 2.60

    DB:2.60:Data Generator Fails With Unique Data z7


    I have a Data Bound Generator on a column that is defined with a Unique constraint. The data retrieves only 3 unique rows from another database, yet when data is generated for this table it fails with error: violation of the unique constraint on this table.
    I thought it may be due to the fact that Rows to Insert on this column was set to 50 and even though the data being entered should be unique it fails because it tries to insert 50 rows of data even though it can only retrieve 3 unique rows, thus causing duplicates.
    However, when I change Rows to Insert to only 3 rows, Data Generation Preview still shows 50 rows and Data Generation still fails with the same error ?

    DB:2.60:Data Generator Fails With Unique Data z7

    The sequential data bound generator produces values in the order specified by the query, you need to specify an ORDER BY clause, see http://blogs.msdn.com/gertd/archive/2007/09/04/data-bound-generator-vs-sequential-data-bound-generator.aspx
     
    -GertD

  • RELEVANCY SCORE 2.60

    DB:2.60:Macro- Apply Formula And Actions On Rows Which Contain A Specific Value jc


    Hi!
    I want to run some actions automatically on entire rows, based on the condition that it contains a specific value.

    I know nothing about creating codes in VB, have only worked on Macros using commands.
    I'm having trouble finding out how to record a macro to select only the specific rows.

    Please help!!

    DB:2.60:Macro- Apply Formula And Actions On Rows Which Contain A Specific Value jc

    based on the condition that it contains a specific value
    Does that mean...
    Check each cell in a row. If you find the value you're looking for in any cell of that row, perform an action on that row. [Example: Iterate through each cell in row 4 looking for the string this is it. If you find the string this is it change the interior
    color of the entire row to red.
    Or...
    Check if a certain cell in a row contains a value. If the value is found, perform an action on that row. [Example: Look in column 'F' of row 10. If there is a number there, and the number is greater than 100, delete the entire row.
    ..................................................................................................
    Do you want the code to fire as it is needed? [Example: You type this is it into a cell in row 4 and you want the row to automatically change to the color red after you do so.]
    Or...
    Do you want the code to only fire when you tell it to? [Example: If I press this button analyze my WorkSheet and turn all rows red that contain the string this is it.

  • RELEVANCY SCORE 2.60

    DB:2.60:Ordering Rows In Db Adapter 9d


    Hi ,
    We are using SOA suite 10g. In one ESB we have a DB Adapter which inserts into an interface table in oracle 10g database. (R12 EBS)
    Database Adapter's operation type is 'Perform an Operation on a Table/Insert or Update(Merge)'.
    XML payload has few rows.

    After inserting into interface table order of these rows are wrong. Is there a way to order rows based on
    a unique number before insertion. Each row has a unique ID number. Something Like (Order By...).

    Is there any other way to solve this problem.

    I created a File adapter and wrote the output to a txt file. Rows were in order in that File. Problem occurs only when inserting into the table.

    Thank You,
    sandaruwan.

    Edited by: sandaruwan on Nov 10, 2010 8:53 AM

    DB:2.60:Ordering Rows In Db Adapter 9d

    If you are inserting into an open interface table can't you use the insert, not the merge.

    Not sure I understand the issue, as in the database you can sort as part of your select statement. It will be the database that will bring back the rows in a different order based on the default sort order, e.g. if you inserted the same rows manually through sqlplus you cannot guarantee the order without a order by.

    Maybe if you could explain the issue you are facing to to the incorrect order?

    cheers
    James

  • RELEVANCY SCORE 2.60

    DB:2.60:Update Multiple Rows Based On Two Columns In Same Row aa


    I have a 1000 rows in a table I would like to update with a unique value. This unique value is a cocatenation of two columns in teh same row.

    Each row has a (i) date and a (ii) time and a (iii) date_time column. I would like to update the date_time (iii) column with a cocatenation of the (i) date and (ii) time columns.

    I know how I would update a single row but how can I update multiple rows with a cocatenation of each of the two columns - i.e put a different value into the date_time column for each row?

    DB:2.60:Update Multiple Rows Based On Two Columns In Same Row aa

    this?
    update table tab_name
    set date_time =date||time
    where your_condition

  • RELEVANCY SCORE 2.59

    DB:2.59:Copy And Pasting Rows In Excel Into A New Sheet Based On Cell Value dj


    I am trying to create a program that will copy a row based on the value in column P into another sheet in the same workbook. Column P can be:
    Design
    Production
    Process
    Safety
    Quality
    Purchasing

    I want the program to look at the Column P and if it says "design" then copy and paste that row into the sheet labeled "Design" and so on and so forth.

    Can anyone help me?

    DB:2.59:Copy And Pasting Rows In Excel Into A New Sheet Based On Cell Value dj


    Hello,

    I came across this post and found it very helpful, thank you. I'm wondering if I could trouble you to help me add additional VBA to run the code through a series of worksheets within the workbook. That is, how would I incorporate a loop to set the wsSource
    for each worksheet within the workbook?

    Thank you in advance.

    @pudgystummy

    Sub CopyColumnP_AllShts()

    Dim wsSource As Worksheet
    Dim wsDestin As Worksheet
    Dim lngDestinRow As Long
    Dim rngSource As Range
    Dim rngCel As Range
    Dim bolErrorZero As Boolean

    'On Error GoTo Err_Execute 'Optional code. Also see label at bottom

    Set wsDestin = Sheets("Final Report") '---**** Edit to your report sheet name

    For Each wsSource In Worksheets
    If wsSource.Name wsDestin.Name Then 'Excludes the destination worksheet from loop
    With wsSource
    'Following line assumes column headers in Source worksheet so starts at row2
    Set rngSource = .Range(.Cells(2, "Y"), .Cells(.Rows.Count, "Y").End(xlUp))
    End With

    'This code copies and paste the cells as is including formulas
    'For Each rngCel In rngSource
    ' If rngCel.Value 0 Then
    ' With wsDestin
    ' 'Following line assumes column headers in Destination worksheet
    ' lngDestinRow = .Cells(.Rows.Count, "Y").End(xlUp).Offset(1, 0).Row
    ' rngCel.EntireRow.Copy Destination:=wsDestin.Cells(lngDestinRow, "A")
    ' End With
    ' End If
    'Next rngCel


    'This code copies and paste values only without formulas
    For Each rngCel In rngSource
    bolErrorZero = False 'Initialize
    If IsError(rngCel.Value) Then
    bolErrorZero = True
    Else
    If rngCel.Value = 0 Then
    bolErrorZero = True
    End If
    End If

    If bolErrorZero = False Then
    With wsDestin
    'Following line assumes column headers in Destination worksheet
    lngDestinRow = .Cells(.Rows.Count, "Y").End(xlUp).Offset(1, 0).Row
    rngCel.EntireRow.Copy
    .Cells(lngDestinRow, "A").PasteSpecial Paste:=xlPasteValues
    End With
    End If
    Next rngCel
    End If
    Next wsSource

    MsgBox "All matching data has been copied."

    Exit Sub

    'Err_Execute: 'Optional code. See also the GoTo code above
    'MsgBox "An error occurred."

    End Sub

  • RELEVANCY SCORE 2.59

    DB:2.59:New Column, Copy Rows Sql Help kc


    DECLARE @temp TABLE
    (
    c_id int,
    rp_id int,
    value decimal(16,2),
    r_id nvarchar(255),
    ranking_id int
    )
    INSERT INTO @temp
    VALUES
    (2, 3,0.01, 82,1)
    ,
    (2, 1,5000, 82,2)
    ,
    (2, 2,1, 82,3)
    ,
    (2, 3,1, 82,4)
    ,
    (2, 1,5000, 82,5)
    ,
    (2, 2,1, 82,6)
    ,(2, 3,1, 82,7)
    ,
    (2, 1,2500, 82,8)
    ,
    (2, 2, 0.01,82,9)
    SELECT * FROM @temp
    c_id rp_id value r_id ranking_id
    2 3 0.01 82 1
    2 1 5000.00 82 2
    2 2 1.00 82 3
    2 3 1.00 82 4
    2 1 5000.00 82 5
    2 2 1.00 82 6
    2 3 1.00 82 7
    2 1 2500.00 82 8
    2 2 0.01 82 9
    Ranking ID is the unique identifier for this table.
    I need to add a new column called aftervalue. For my first 3 rows with values 0.01, 5000.00 and 1.00 they will be in the aftervalue column and the

    value column will be null, this is only for the first 3 rows. so the next three rows the value column will have the above three rows from aftervalue
    so basically it is comparing previous value and after values
    It must match up to the rp_Id. So for row 7 the rp_id is 3 and the value is 1.00 because for row 4 the rp_id 3 has the value 1.00, for row 8 the rp_id is
    1 is 5000.00 because for row 5 the rp_id 1 has value of 5000.00
    please help, results have to be in the format specified below

    c_id rp_id value aftervalue r_id ranking_id
    2 3 NULL 0.01 82 1
    2 1 NULL 5000.00 82 2
    2 2 NULL 1.00 82 3
    2 3 0.01 1.00 82 4
    2 1 5000.00 5000.00 82 5
    2 2 1.00 1.00 82 6
    2 3 1.001.00 82 7
    2 1 5000.002500.00 82 8
    2 2 1.00 0.01 82 9

    DB:2.59:New Column, Copy Rows Sql Help kc

    Thanks Paresh that worked.

    Limno, my db is sql server 2008 but I can see this is soo easy in 2012 - thanks though, I have marked it as helpful

  • RELEVANCY SCORE 2.59

    DB:2.59:Handing In A Parameter To A Stored Procedure And Returing Value 73


    I have a two part question really. The first part is about a stored procedure I have almost perfectly correct. This stored procedure below currently returns all the rows found in a table. I need to get only one value based on a unique value field in the table. The unique field is called descriptor. So I need to know what I do to modify the current SP to make it look for a unique descriptor value in that field and then hand back the resulting data the stored procedures generates. I am also looking for a code sample in VB.NET that would initiate the call with the correct descriptor parameter handed into the stored procedure and get back the result. My understanding is typically stored procedures generally return an integer to signify success or failure of it executing. Again I need to have the SP perform a query and then act on the data (as it does now) and then hand back the given result to VB. Apparently the VB call is subtlety different when you need a value back. Any help is much appreciated. Regards, Guy   The stored procedure is as follows: USE [Numbers] GO /****** Object:  StoredProcedure [dbo].[thenextnum]    Script Date: 09/22/2009 22:23:51 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO alter procedure [dbo].[thenextnum] as     begin     declare @t table (nextseq varchar(100))     update number_definition_table          set Current_Number=Current_Number+1      output    inserted.prefix_format          +(Case    WHEN inserted.leading_hyphen = 'NONE' then ''             ELSE inserted.leading_hyphen END             )             --+ inserted.leading_hyphen              +right(             replicate('0',inserted.Character_Count)                 +convert(varchar(50),inserted.Current_Number)                      ,inserted.Character_Count)                      +(Case    WHEN inserted.trailing_hyphen = 'NONE' then ''             ELSE inserted.trailing_hyphen END             ) into @t        select nextseq from @t     end

    DB:2.59:Handing In A Parameter To A Stored Procedure And Returing Value 73

    So, did my suggestion below help?Set @nextnum =  select nextseq from @tjfc

  • RELEVANCY SCORE 2.59

    DB:2.59:Xslt: Unique Nodes Only Based On Specific Attribute? 7k


    DB:2.59:Xslt: Unique Nodes Only Based On Specific Attribute? 7k

    Thank you Martin.My blog

    Whether you’re a construction worker, a forum moderator, or just someone that likes helping people. I think these

    guidelines can be helpful in keeping you helpful when being helpful.

  • RELEVANCY SCORE 2.59

    DB:2.59:Dynamic Lookup Issue 3d



    I have a simple mapping as source - dynamic lookup - update strategy - target table.Both sauce target tables are Teradata tables with two columns only. The target one has UNIQUE PRIMARY INDEX defined on the key field.PowerCenter Designer is version 8.1.1 SP3. Dynamic lookup accesses target table to see if a source row need to be inserted or updated based on NewLookupRow's value.I did the following.1. Checked Dynamic Lookup Cache (on transformation)2. Checked Insert Else Update (on transformation)3. Selected "Treat source rows" as "Data driven" (on session)4. Set Update Strategy Expression value to "IIF(NewLookupRow = 1, DD_INSERT, IIF(NewLookupRow = 2, DD_UPDATE))"First time it worked OK when the target table is empty. When it ran again with the same source, it failed on each row because it tried to insert, not update, each row into the populated table.How ever, the log file stated clearly that the lookup returned exactly # of rows that matched the one in target table.I took off the update strategy transformation, and wrote the rows directly into a new target table with an extra field to hold the NewLookupRow value. I saw all values in NewLookupRow being 0, which means the PowerCenter Server neither update nor insert the rows in the cache.I truncated the new target table and deleted 6 rows from the old target table which was used for dynamic lookup and ran one more time, I then saw 6 rows with NewLookupRow =1, while the remains still being 0.Any idea about this issue please?By the way, I have developed more than 10 mappings with similar logic without any problem. This is the only one caused me lots of headache.Many, many thanks in advance for any inputs that may help me to resolve this critical issue.

    DB:2.59:Dynamic Lookup Issue 3d


    Hi,I'm having exactly the same problem, using 8.1.1 SP3.NewLookupRow is never 2, when it should be update... Did you find the problem??I have checked the option "Insert else Update", after I tried to put update strategy before the lookup and check the option "Update else Insert", but none of this has solved the problem.Does anyone can help?

  • RELEVANCY SCORE 2.59

    DB:2.59:How To Extract Rows Based On Unique Entry pm


    Dear all,
    I have a querry whish is as follow :
    SELECT DISTINCT dbo.PropertyBasket.Id, dbo.Customer.Name, dbo.Customer.EmailAddress, dbo.PropertyBasket.PropertyId, dbo.PropertyBasket.RevisionDate
    FROM dbo.PropertyBasket INNER JOIN
    dbo.Customer ON dbo.PropertyBasket.CutomerId = dbo.Customer.Id
    WHERE (dbo.Customer.Name = N'calderara') OR
    (dbo.Customer.EmailAddress = N'serge.calderara@solatys.com')
    This querry returns follwoing data :

    But this si not what I want. As you can see I have 2 same ID value with same revision date but different property id.
    Is it possible to return only single records from Id field?
    regards
    serge
    Your knowledge is enhanced by that of others.

    DB:2.59:How To Extract Rows Based On Unique Entry pm


    try the below one
    With Cte
    as
    (
    SELECT ROW_NUMBER()Over( PARTITION by dbo.PropertyBasket.Id order by dbo.PropertyBasket.Id ) as row, dbo.PropertyBasket.Id, dbo.Customer.Name, dbo.Customer.EmailAddress, dbo.PropertyBasket.PropertyId, dbo.PropertyBasket.RevisionDate
    FROM dbo.PropertyBasket INNER JOIN
    dbo.Customer ON dbo.PropertyBasket.CutomerId = dbo.Customer.Id
    WHERE (dbo.Customer.Name = N'calderara') OR
    (dbo.Customer.EmailAddress = N'serge.calderara@solatys.com') )
    Select * from Cte where row = 1
    -----------------
    -----------
    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

  • RELEVANCY SCORE 2.59

    DB:2.59:Ultrasearch - Numbers Of Document Discovered, Fetched And Indexed ff


    I am using US 1.0.3.

    - I have a table data source mapped to a table with the following characteristics:
    PK is a composite of three columns
    table has a total of 970 rows
    the column TITLE which is of varchar2 is specified as the content column
    Of the 971 rows, 82 rows have NULL in TITLE column.
    Of the 971 rows, only 196 rows have unique TITLE.
    There is no attribute mapping

    - Here is the crawler summary:
    Document discovered: 381
    Document fetched: 381
    Document indexed: 196
    The rest are zeros.

    My questions are:
    (1) It seems US only indexes rows with unique value which explains why only 196 rows/documents are indexed. That is, rows with duplicate TITLE are not indexed. It seems to make sense. Is that correct?
    (2) But why only 381 documents/rows are discovered and fetched? I would think it would discovered all the rows with NON-NULL value in the TITLE column: 889 (i.e. 971 82).
    (3) In summary, how does US determine what rows to fetch and index?

    Thanks!

    C Cheung

    DB:2.59:Ultrasearch - Numbers Of Document Discovered, Fetched And Indexed ff

    I am using US 1.0.3.

    - I have a table data source mapped to a table with the following characteristics:
    PK is a composite of three columns
    table has a total of 970 rows
    the column TITLE which is of varchar2 is specified as the content column
    Of the 971 rows, 82 rows have NULL in TITLE column.
    Of the 971 rows, only 196 rows have unique TITLE.
    There is no attribute mapping

    - Here is the crawler summary:
    Document discovered: 381
    Document fetched: 381
    Document indexed: 196
    The rest are zeros.

    My questions are:
    (1) It seems US only indexes rows with unique value which explains why only 196 rows/documents are indexed. That is, rows with duplicate TITLE are not indexed. It seems to make sense. Is that correct?
    (2) But why only 381 documents/rows are discovered and fetched? I would think it would discovered all the rows with NON-NULL value in the TITLE column: 889 (i.e. 971 82).
    (3) In summary, how does US determine what rows to fetch and index?

    Thanks!

    C Cheung

  • RELEVANCY SCORE 2.59

    DB:2.59:Copy Selected Rows To Clipboard From Swing Jtable pp


    Hello, I can copy table rows to clipboard by:
    jTable1.getTransferHandler().exportToClipboard(jTable1, getToolkit().getSystemClipboard(), TransferHandler.COPY);How can I copy only selected rows to clipboard? Please help..

    Thanks,

    DB:2.59:Copy Selected Rows To Clipboard From Swing Jtable pp

    Hello, I can copy table rows to clipboard by:
    jTable1.getTransferHandler().exportToClipboard(jTable1, getToolkit().getSystemClipboard(), TransferHandler.COPY);How can I copy only selected rows to clipboard? Please help..

    Thanks,

  • RELEVANCY SCORE 2.59

    DB:2.59:Selecting Unique Rows z9


    Hi

    I have a table A with 5 columns (no primary key or unique). The are duplicate rows in it. I would like to create a table selecting only unique rows from the table A. Could someone help me how to do it?

  • RELEVANCY SCORE 2.59

    DB:2.59:Copy Row Based On Value Of A Cell jz


    I need a macro that will let me copy a row of data from one worksheet to another based on the value in one of the cells.
    My source worksheet looks like the following

    A
    B
    C

    1
    Apple
    Tree
    Red

    2
    Grape
    Vine
    Red

    3
    Orange
    Tree
    Orange

    I want to select only rows with the word tree in Column B and past the row into a new worksheet. The new work sheet should look like the following. I can't have blank rows for those that are skipped. My original file has 100k rows so I
    don't want to have any blank rows in the new file.

    A
    B
    C

    1
    Apple
    Tree
    Red

    2
    Orange
    Tree
    Orange

    jmk

    DB:2.59:Copy Row Based On Value Of A Cell jz

    Hans
    Thanks again - this method took only seconds to extract 9k rows from a 100k row file
    Really appreciate your help - your making me look good

    Jack

    jmk

  • RELEVANCY SCORE 2.59

    DB:2.59:Creating A Case-Sensitive Unique Key In Access 89


    Hello,
    How can I create a unique key for a table in MS Access that is case sensitive? So that columnA can contain david and David as the unique key to two different rows.
    Also, obviously, I would want joins to also be case sensitive, so that joining tableA to tableB, the value of david in tableA will only join with the value david in tableB, but will not join with David in tableB.
    I am using Acces 2007 and 2010.David

    DB:2.59:Creating A Case-Sensitive Unique Key In Access 89

    All,
    Thank you for your responses. I was NOT interested in how to do a case-sensitive join; frankly that is easy. I was interested in how to create a case-sensitive key such that a UNIQUE IDENTIFIER could be case-sensitive; join not required.
    And therefore a foreign key could also be case sensitive.
    MS Access cannot do this. You have to use SQL Server, and create the database while usingthe case-sensitive option (a collation sequence that isCS not CI, case-sensitive as opposed to case-insensitive). Be aware, however, that when
    you do this, column names and table names are case sensitive in addition to table content.
    First, create a new database using the CS option because by default on install SQL Express is likely case-insensitive. You do not need to reinstall SQL Server, just create a new database using CI in the collation sequence. Then, through ACCESS,
    you can upsize to SQL Server using the built-in utility. This will copy the database and contents from access to SQL Server.

    David

  • RELEVANCY SCORE 2.59

    DB:2.59:Non Unique Index pj


    Hi,
    How to find number of rows accessed per each non-unique index value ?

    Thanks in advance.

    DB:2.59:Non Unique Index pj

    Query the view v$sql_plan_statistics_all where object_name='EMP_IDX1'.

    Mohan

  • RELEVANCY SCORE 2.59

    DB:2.59:How To Make Only Some Rows Editable In Html Db. pd


    hi,

    I need some help

    i have a tabular form, in which i have to make some rows editable and some rows read only based on a column value.

    thanks in advance.

    DB:2.59:How To Make Only Some Rows Editable In Html Db. pd

    Maybe someone from Oracle can shed some light on this

    Carl? Marc? Any ideas?

    Thanks