Home > Default > Mod Function in Partition

Mod Function in Partition

December 10Hits:6
Advertisement
Hi,
Could someone explain me or send me syntax for using a MOD fucntion in partitioning a table.
Vishal

Answers

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. 

Read other 8 answers

Tags:

Related Articles

  • Using AGO function with partitionsNovember 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 PartitionDecember 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 columnNovember 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 ServerOctober 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 FUNCTIONNovember 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?October 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?November 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 aggregationNovember 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...November 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 PartitionNovember 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

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.422 s.