Professional Web Applications Themes

help with where criteria in sql statment - Microsoft SQL / MS SQL Server

hi i have an sql statment that is run in excelwhich works fine but if i want to change the where criteria of the statment i have to go into the code and change it there what i would like to do is link the where criteria to a cell on one of the worksheets this is my attempt "WHERE(FORM_XD.TEAM=" & Worksheets("Sheet1").Range("A1").Value & ")" but it does not want to work below is the full select statement "SELECT TRUNC(FORM_XD.DAY_OF_WEEK), TO_CHAR(FORM_XD.DAY_OF_WEEK,'HH24:MI'), FORM_XD.TEAM, FORM_XD.TALK, FORM_XD.SALES, FORM_XD.WAIT" & Chr(13) & "" & Chr(10) & "FROM EASY.FORM_XD _FORM_XD" & Chr(13) & "" & Chr(10) ...

  1. #1

    Default help with where criteria in sql statment

    hi i have an sql statment that is run in excelwhich works fine but if
    i want to change the where criteria of the statment i have to go into
    the code and change it there
    what i would like to do is link the where criteria to a cell on one of
    the worksheets
    this is my attempt
    "WHERE(FORM_XD.TEAM=" & Worksheets("Sheet1").Range("A1").Value & ")"
    but it does not want to work
    below is the full select statement

    "SELECT TRUNC(FORM_XD.DAY_OF_WEEK),
    TO_CHAR(FORM_XD.DAY_OF_WEEK,'HH24:MI'), FORM_XD.TEAM, FORM_XD.TALK,
    FORM_XD.SALES, FORM_XD.WAIT" & Chr(13) & "" & Chr(10) & "FROM
    EASY.FORM_XD _FORM_XD" & Chr(13) & "" & Chr(10) & "WHERE
    (FORM_XD.TEAM=" & Worksheets("Sheet1").Range("A1").Value & ")" &
    Chr(13) & "" & Chr(10) & "ORDER BY
    TRUNC(FORM_XD.DAY_OF_WEEK)"

    hope someone can help

    aneurin
    aneurin Guest

  2. #2

    Default Re: help with where criteria in sql statment

    I think the query which you are using has syntaxes of ORACLE database.
    TRUNC/TO_CHAR equivalent of SQL server is CONVERT function whereby you can
    change the format of date fields, and to explicitly converts an expression
    of one data type to another.

    --
    -Vishal

    "aneurin" <aneurinntlworld.com> wrote in message
    news:a287c0a5.0307101143.525ab267posting.google.c om...
    > hi i have an sql statment that is run in excelwhich works fine but if
    > i want to change the where criteria of the statment i have to go into
    > the code and change it there
    > what i would like to do is link the where criteria to a cell on one of
    > the worksheets
    > this is my attempt
    > "WHERE(FORM_XD.TEAM=" & Worksheets("Sheet1").Range("A1").Value & ")"
    > but it does not want to work
    > below is the full select statement
    >
    > "SELECT TRUNC(FORM_XD.DAY_OF_WEEK),
    > TO_CHAR(FORM_XD.DAY_OF_WEEK,'HH24:MI'), FORM_XD.TEAM, FORM_XD.TALK,
    > FORM_XD.SALES, FORM_XD.WAIT" & Chr(13) & "" & Chr(10) & "FROM
    > EASY.FORM_XD _FORM_XD" & Chr(13) & "" & Chr(10) & "WHERE
    > (FORM_XD.TEAM=" & Worksheets("Sheet1").Range("A1").Value & ")" &
    > Chr(13) & "" & Chr(10) & "ORDER BY
    > TRUNC(FORM_XD.DAY_OF_WEEK)"
    >
    > hope someone can help
    >
    > aneurin

    Vishal Parkar Guest

Similar Threads

  1. Using an IF statment within an ItemTemplate
    By David Lozzi in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: March 16th, 08:34 PM
  2. I want to display Income Statment...
    By Ather Ali Shaikh in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: September 8th, 03:17 PM
  3. For Statment question
    By K-Parker in forum Macromedia Flash
    Replies: 3
    Last Post: December 12th, 09:17 AM
  4. how to tidy this if statment
    By LeeD in forum Macromedia Director Lingo
    Replies: 7
    Last Post: September 4th, 03:29 PM
  5. IF statment wont work
    By Wayne Snyder in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: June 30th, 12:29 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