Loading ...
Sorry, an error occurred while loading the content.
 

RE: [SQLQueriesNoCode] Re: Transfer Access Function to SQL Functi on

Expand Messages
  • Travis Truax
    ... This is not a good way to ask for help. This is the same format used by the kids that just want other people to do their homework. Travis- ... From:
    Message 1 of 1 , Dec 11, 2007
      >>I'm not looking for a "basically" response because this obviously
      >>doesn't help me. I'm looking for an "exactly" response so I can paste
      >>it in the function properties and use it.

      This is not a good way to ask for help. This is the same format used by the
      kids that just want other people to do their homework.

      Travis-

      -----Original Message-----
      From: jerome3141 [mailto:jerome3141@...]
      Sent: Tuesday, December 11, 2007 10:23 AM
      To: SQLQueriesNoCode@yahoogroups.com
      Subject: [SQLQueriesNoCode] Re: Transfer Access Function to SQL Function


      The info I provided is exactly how it is written in the MS Access
      Database Module, and is working. The Access program is using pass-
      through tables from a SQL DB, and the queries are a mixture of pass-
      through SPs and some local queries. I'd like to make this on the SQL
      side to inprove response time and reduce the load on the Access DB.

      Commrate is the table that the function is reading through.
      rs!rate is the returned value when the search answers "true" between
      the "low" and "high".

      I'm not looking for a "basically" response because this obviously
      doesn't help me. I'm looking for an "exactly" response so I can paste
      it in the function properties and use it.

      Thanks again,

      --- In SQLQueriesNoCode@yahoogroups.com, "John Warner" <john@...>
      wrote:
      >
      > You haven't told us anything about the data here. What is commrate?
      What
      > is rs!rate? What is markup. From what I can see I'd say no this
      can't be
      > done, but then I can't see much.
      >
      > John Warner
      >
      >
      > > -----Original Message-----
      > > From: SQLQueriesNoCode@yahoogroups.com
      > > [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of jerome3141
      > > Sent: Monday, December 10, 2007 10:13 PM
      > > To: SQLQueriesNoCode@yahoogroups.com
      > > Subject: [SQLQueriesNoCode] Transfer Access Function to SQL
      Function
      > >
      > > I'm trying to change some Access queries and functions over to
      the SQL
      > > database hoping to get faster results. Below is the Access
      function.
      > > Can anyone assist me in changing this to a SQL function? Then how
      will
      > > I deploy this function in the SQL SP?
      > >
      > > Function GetMarkup(Markup As Double) As Double
      > > Dim rs As DAO.Recordset
      > > Set rs = CurrentDb.OpenRecordset("commrate")
      > > While Not rs.EOF
      > > If Markup >= rs!Low And Markup < rs!High Then
      > > GetMarkup = rs!rate
      > > End If
      > > rs.MoveNext
      > > Wend
      > > End Function
      > >
      > >
      > > Thank you in advance.
      >





      Yahoo! Groups Links
    Your message has been successfully submitted and would be delivered to recipients shortly.