Professional Web Applications Themes

how can I do this, in t-sql? - Microsoft SQL / MS SQL Server

tried to update the column using a query but, it doesn't seem to like it. update sched_org_avail_fact a set a.shift_avail_time_sssss = (select b.end_time_sssss-b.start_time_sssss from sched_shift_dim a where a.shift_key = b.shift_key) thanks! alex ivascu...

  1. #1

    Default how can I do this, in t-sql?

    tried to update the column using a query but, it doesn't seem to like it.

    update sched_org_avail_fact a
    set a.shift_avail_time_sssss = (select b.end_time_sssss-b.start_time_sssss
    from sched_shift_dim a
    where a.shift_key = b.shift_key)

    thanks!

    alex ivascu


    alex Guest

  2. #2

    Default Re: how can I do this, in t-sql?

    update sched_org_avail_fact a set
    a.shift_avail_time_sssss = (
    select b.end_time_sssss - b.start_time_sssss
    from sched_shift_dim b -- <<==== b not a
    where b.shift_key = a.shift_key -- (I like this way better)
    )

    Bye,
    Delbert Glass


    "alex ivascu" <com> wrote in message
    news:#phx.gbl... 
    b.end_time_sssss-b.start_time_sssss 
    b.shift_key) 


    Delbert Guest

  3. #3

    Default Re: how can I do this, in t-sql?

    I did it that way, and get the following error:

    Server: Msg 170, Level 15, State 1, Line 1
    Line 1: Incorrect syntax near 'a'.

    Any other ideas?

    Alex Ivascu


    "Delbert Glass" <com> wrote in message
    news:phx.gbl... [/ref]
    it. 
    > b.end_time_sssss-b.start_time_sssss 
    > b.shift_key) 
    >
    >[/ref]


    alex Guest

  4. #4

    Default Re: how can I do this, in t-sql?

    I goofed.


    update sched_org_avail_fact set
    shift_avail_time_sssss = (
    select b.end_time_sssss - b.start_time_sssss
    from sched_shift_dim b
    where b.shift_key = sched_org_avail_fact.shift_key
    )


    or


    update sched_org_avail_fact set
    shift_avail_time_sssss = (
    select b.end_time_sssss - b.start_time_sssss
    from sched_shift_dim b
    where b.shift_key = a.shift_key
    )
    from sched_org_avail_fact a

    Bye,
    Delbert Glass

    "alex ivascu" <com> wrote in message
    news:phx.gbl... [/ref]
    > it. 
    > > b.end_time_sssss-b.start_time_sssss 
    > > b.shift_key) 
    > >
    > >[/ref]
    >
    >[/ref]


    Delbert Guest

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