Hiyas,
I just have a kind of whiney question today, wondering if anyone can enlighten me on why I can't do something, or maybe if there is a workaround.
I want to use getdate in a function. I...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20788751.html
Can it be done? How?
I have created the following function to convert an oddly (customer) formatted date time string into a real datetime data type. The problem is, if the OldDate is incomplet...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21415085.html
Does Sybase 12.5.3 support user defined functions? I'm looking to imbed a couple function calls in a view to resolve some of the columns much the same way as I'm using pl/sql functions in Oracle. ...
http://www.experts-exchange.com/Database/Sybase/Q_21716390.html
Zones:
SybaseDate Answered: 01/31/2006 Grade: A Views: 0
Hello!
I am trying to create a function to call in a view and it will be able to change my data. The syntax I use for it is one I use a lot in queries, and I think it will be easier if I create a...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2285...
I am trying to create a UDF. My code is attached.
For each row retrieved by the SELECT statement there will be 2 values.
What is the corret syntax to access both retrieved values? What sh...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23508838.html
Zones:
SQL SyntaxDate Answered: 06/23/2008 Grade: A Views: 144
I can usually figure out ways to do most things in excel and while the solutions may not be elegant they work.
This has me stumped
I am tring to program a function for using within the excel ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Hi,
I need to create a UDF that returns a resultset. It can't just be a view because filtering occurs 'before' the resultset is returned. Its performing a match on a map table, then returning th...
http://www.experts-exchange.com/Database/Oracle/Q_23555959.html
Zones:
OracleDate Answered: 07/21/2008 Grade: B Views: 22
I am trying to create a User Defined Function in SQL Server 2005.
I have a table Tbl_Data_Call_Variables. The fields are:
Apps_Cat_ID
Q01_Data
Q02_Data
Q03_Data
v
v
Q60_Data
The UDF n...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23912814.html
Zones:
SQL SyntaxDate Answered: 11/18/2008 Grade: A Views: 0
Hi all,
I am getting this error when I tried to build the a User defined Function. The code and error message is as follows:
CODE:
CREATE FUNCTION fnIsVowel
(
...
http://www.experts-exchange.com/Database/DB2/Q_23132499.html
Zones:
DB2,
SQL SyntaxDate Answered: 02/03/2008 Grade: A Views: 0
I have a UserDefinedFunction
IsPhoneNumber
Which works great in a query like
Select *
FROM Customer
WHERE
IsPhoneNumer(Customer.PhoneNumbr) = 0 -- Valid Phone Number
What i'm needing...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23149039.html
