RE: [SQLQueriesNoCode] Re: Transfer Access Function to SQL Functi on
>>I'm not looking for a "basically" response because this obviouslyThis is not a good way to ask for help. This is the same format used by the
>>doesn't help me. I'm looking for an "exactly" response so I can paste
>>it in the function properties and use it.
kids that just want other people to do their homework.
From: jerome3141 [mailto:jerome3141@...]
Sent: Tuesday, December 11, 2007 10:23 AM
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.
--- In SQLQueriesNoCode@yahoogroups.com, "John Warner" <john@...>
> You haven't told us anything about the data here. What is commrate?
> is rs!rate? What is markup. From what I can see I'd say no thiscan't be
> done, but then I can't see much.Function
> 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
> >the SQL
> > I'm trying to change some Access queries and functions over to
> > database hoping to get faster results. Below is the Accessfunction.
> > Can anyone assist me in changing this to a SQL function? Then howwill
> > I deploy this function in the SQL SP?Yahoo! Groups Links
> > 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.