Upsizing Queries with Functions from .mdb

[Mantle51]

Hello agin!

I have queries in an Access db that contain several "home-made" functions in the WHERE clause. Is it at all possible to upsize these to SQL server?

Thanks...........Mickey

 

[SQLSister]

YOu will have to recreate them in SQL server as user-defined functions. Be aware that UDfs are performance hogs and it might be better to actually put the code in the queries than run a UDF.

Questions about posting. See faq183-874

 

[Mantle51]

Not sure what you mean by "put the code in the queries" Every line of code from a function will reside in the SQL statement? If that's so, how does that work and where would I put it - in the WHERE cluase?

Thanks

 

[philhege]

You have to translate the VBA statements to comparable T-SQL statements, but that's the way it works. If they're in the WHERE clause in Access, they need to be in the WHERE clause in SQL.

SQLSister, I've had pretty good luck with some nasty UDFs. Do you have any links to discussion about UDF performance?



Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Pity the insomniac dyslexic agnostic. He stays up all night, wondering if there really is a dog.