Current Position:Home > Mod Function in Partition

Mod Function in Partition

Update:12-10Source: network consolidation
Advertisement
Hi,
Could someone explain me or send me syntax for using a MOD fucntion in partitioning a table.
Vishal

The Best Answer

Advertisement
bachc wrote:
The age of the thread is less important than the rating of google
True, as far as the date is concerned, but the relevance is. Your modulo operation has nothing whatsoever to do with the original question. The only thing that's the same is the word "modulo".
As far as what you're actually doing, it doesn't really make much sense. If you try to reverse the mathematical operation in your case you do not get back to the original number. Also, you do not need to use the formula node to simply do what the Quotient & Remainder function already does. 
  • Using AGO function with partitions Update:11-30

    I have a situation where we have logical sources with the same repository folder that are partitioned. We would like to use the AGO function but are getting the following error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058]

  • Mod Function in Partition Update:12-10

    Hi, Could someone explain me or send me syntax for using a MOD fucntion in partitioning a table. Vishalbachc wrote: The age of the thread is less important than the rating of google True, as far as the date is concerned, but the relevance is. Your mo

  • Using TRUNC function on partitioned column Update:11-30

    Hi All, I have a table as follows: STEP1 CREATE TABLE TEST_PARTITION EMP_ID VARCHAR2(10 BYTE), CREATE_DT DATE, EMP_RGN_NM VARCHAR2(2 BYTE), DSPTCH_CNT NUMBER PARTITION BY RANGE (CREATE_DT) SUBPARTITION BY LIST(EMP_RGN_NM) SUBPARTITION TEMPLATE( SUBPA

  • Error: Partition function can only be created in Enterprise edition of SQL Server Update:10-11

    By using the Generate Scripts option in SSMS, I've duplicated this DB seven times so far. I do this due to the 10 Gig limit on Sql Express 2012.  I was doing this again today. I generated the script, did a search/replace to provide a new DB name for

  • CREATING A LIST PARTITION WITH TO_CHAR FUNCTION Update:11-30

    i want to create a list partitions based on months like 1..12 so that data will go to its respective month partition irrespective of Month and year. i don't have a varchar2 field for month only rather i have got the insertion date column. can anybody

  • How to use partition by instead of group by? Update:10-11

    Hi, I am having trouble using partition by clause in following case, column other_number with null values contains 10 records in 'some_table' 5 records with date 11-01-2009, item_code = 1 5 records with date 10-01-2009, item_code = 2 This query retur

  • How to create a faster function? Update:11-30

    Dear all,  I am trying to create function which can replace certain words with hyperlink in sql. When I call the function as query in sql, its takes a very long time to execute the query, more than 2-3min. I assumed this is because, the tag_libary ta

  • Discoverer Analytic Function windowing - errors and bad aggregation Update:11-30

    I posted this first on Database General forum, but then I found this was the place to put it: Hi, I'm using this kind of windowing function: SUM(Receitas Especificas) OVER(PARTITION BY Tipo Periodo,Calculado,"Empresa Descrição (Operador)","

  • Question about table partitioning... Update:11-30

    Hello, all.  I'm using SQL 2012 Enterprise.  I have 8 very large tables (the largest two having 227M and 118M records, and the others between 11M-44M records).  For performance reasons, I'm considering partitioning the tables across multiple files/fi

  • LEAD with Partition Update:11-30

    Hi, I am stuck on a problem to implement LEAD/LAG with partition. Below is the example and expected Result create table trd(      key number,      book number,      prd_key number,      direction varchar2(2),      trdtime date,      price number) ins