Professional Web Applications Themes

from oracle (pl/sql) to sql server (t-sql) - Microsoft SQL / MS SQL Server

Hi. How can I modify this statement to work in sql server? MOD((TRUNC(a.sql_date) - TRUNC (d.dts_start_day_ref)),d.days_in_schedule)+1 Thanks!!! Alex Ivascu...

  1. #1

    Default from oracle (pl/sql) to sql server (t-sql)

    Hi. How can I modify this statement to work in sql server?

    MOD((TRUNC(a.sql_date) - TRUNC
    (d.dts_start_day_ref)),d.days_in_schedule)+1

    Thanks!!!

    Alex Ivascu


    alex Guest

  2. #2

    Default Re: from oracle (pl/sql) to sql server (t-sql)

    What does this line of code do?
    Try posting as pseudocode or describe it.

    --
    Dean Savovic
    www.teched.hr


    "alex ivascu" <com> wrote in message
    news:040a01c34a67$8e402040$gbl... 


    Dean Guest

  3. #3

    Default Re: from oracle (pl/sql) to sql server (t-sql)

    There is no function that returns modulo of division.

    You can always use stadard mathematical procedure:

    declare a int
    ,b int

    select a = 15
    , b = 6

    select 15 - (a / b) * b

    --
    Dean Savovic
    www.teched.hr


    "alex ivascu" <com> wrote in message news:0caa01c34adf$350d1c80$gbl... [/ref]
    > server? 
    > >
    > >
    > >.
    > >[/ref][/ref]


    Dean Guest

  4. #4

    Default Re: from oracle (pl/sql) to sql server (t-sql)

    thanks, Dean.

    However, I found a modulo in sql server, but now am having
    trouble making it work with datetime datatypes.

    (a.sql_date - d.dts_start_day_ref)%
    days_in_schedule+1=day_of_schedule

    sql_date is datetime
    dts_start_day_ref is datetime
    days_in_scheduler is int
    day_of_schedule is int

    thanks for any help!!!

    alex ivascu
     
    news:0caa01c34adf$350d1c80$gbl... [/ref][/ref]
    message 
    >> server? [/ref]
    >
    >
    >.
    >[/ref]
    alex Guest

Similar Threads

  1. LoadVars on Oracle Web Server
    By Maegas in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: January 26th, 05:51 PM
  2. Postgresql, SQL server and Oracle. Please, help
    By Nadia Kunkov in forum PostgreSQL / PGSQL
    Replies: 2
    Last Post: January 25th, 09:20 PM
  3. Replies: 1
    Last Post: August 1st, 03:14 PM
  4. Replies: 0
    Last Post: June 24th, 03:58 PM
  5. Cannot log into Oracle Management Server.
    By Frank Jiang in forum Oracle Server
    Replies: 3
    Last Post: December 31st, 11:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139