Showing posts with label functions. Show all posts
Showing posts with label functions. Show all posts

Friday, March 30, 2012

Max no. of parameters in functions

Hi,
Can anybody tell me the max no of parameters that we can use in a single
UDF?
Thanks!!BOL:

A function can have a maximum of 1,024 parameters.|||BOL:

A function can have a maximum of 1,024 parameters.
Thanks a lot Sean.|||Hi,
Can anybody tell me the max no of parameters that we can use in a single
UDF?
Thanks!!Half of me shudders every time I see a post about SQL Server's maximum capacity, and the other half tingles with excitement at the future potential consulting income.|||anybody ever made a UDF with that many no of parameters ?|||anybody ever made a UDF with that many no of parameters ?|||anybody ever made a UDF with that many no of parameters ?

Plz listen,don't blame me for that,I found the question in an online test for the MCDBA 70-229 exam (Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition).:D

and the other half tingles with excitement at the future potential consulting income.

Batman is an experienced person and has all the future insights which protect him from danger. :D ;)|||not blaming you for anything ... i was just thinking aloud ;)|||not blaming you for anything ... i was just thinking aloud ;)
yea,there you are,I too was running in that same road a few hours ago.:D :D|||I am a late riser ... mostly go out on evening walks :D

Wednesday, March 7, 2012

Math in a column

Can't I perform Math functions in deriving a column?
Check out the following SQL which DOES NOT work...
SELECT GEN.loan_num,
MKT.yield_prem,
MKT.yield_fee,
GEN.ysp_to_wire,
GEN.loan_amt,
(MKT.yield_fee =
(GEN.loan_amt *
(MKT.yield_prem/100)))
FROM DataTrac.dbo.GEN,
DataTrac.dbo.MKT
--WHERE GEN.loan_num = '2000013699'
WHERE GEN.file_id = MKT.file_id
AND NOT (MKT.yield_fee =
(GEN.loan_amt *
(MKT.yield_prem/100)))
Let me know.
Thanks.
wnfisbaCan you show DDL, sample data, desired results, and what "DOES NOT work"
means? Do you get an error message? If so, what is it?
Please read http://www.aspfaq.com/5006
"wnfisba" <wnfisba@.discussions.microsoft.com> wrote in message
news:486F6FD7-6217-41B3-B4E6-1DC92410B90D@.microsoft.com...
> Can't I perform Math functions in deriving a column?
> Check out the following SQL which DOES NOT work...
> SELECT GEN.loan_num,
> MKT.yield_prem,
> MKT.yield_fee,
> GEN.ysp_to_wire,
> GEN.loan_amt,
> (MKT.yield_fee =
> (GEN.loan_amt *
> (MKT.yield_prem/100)))
> FROM DataTrac.dbo.GEN,
> DataTrac.dbo.MKT
> --WHERE GEN.loan_num = '2000013699'
> WHERE GEN.file_id = MKT.file_id
> AND NOT (MKT.yield_fee =
> (GEN.loan_amt *
> (MKT.yield_prem/100)))
> Let me know.
> Thanks.
> wnfisba|||In the SELECT list, the last expression is a problem
SELECT ...,
(MKT.yield_fee =
(GEN.loan_amt *
(MKT.yield_prem/100)))
I don't know what you want this to be, but perhaps you are just
assigning the name yield_fee to the calculated amount? If so,
consider:
yield_fee =
(GEN.loan_amt *
(MKT.yield_prem/100)))
Roy
On Wed, 22 Feb 2006 13:37:30 -0800, "wnfisba"
<wnfisba@.discussions.microsoft.com> wrote:

>Can't I perform Math functions in deriving a column?
>Check out the following SQL which DOES NOT work...
>SELECT GEN.loan_num,
> MKT.yield_prem,
> MKT.yield_fee,
> GEN.ysp_to_wire,
> GEN.loan_amt,
> (MKT.yield_fee =
> (GEN.loan_amt *
> (MKT.yield_prem/100)))
>FROM DataTrac.dbo.GEN,
> DataTrac.dbo.MKT
>--WHERE GEN.loan_num = '2000013699'
>WHERE GEN.file_id = MKT.file_id
>AND NOT (MKT.yield_fee =
> (GEN.loan_amt *
> (MKT.yield_prem/100)))
>Let me know.
>Thanks.
>wnfisba

Math functions

Good Afternoon LAdies & Gents

I was hoping you could assist me with this problem (more of a how-to)
I have a Database with 4 Tables and I need to incert some mathamatical functions to get totals, averages, percentages etc.

here is my problem

I have the following Tables

tblPrice, field(s) mfg_price, discount_price, ltc_price
tblCustomer, field(s) cpny_name, contact, address, phone, date
tblProduct, field(s) crt, server, notebook,
tblInventory, field(s) StockID, cust_num

I need to be able to combine the contact name from tblCustomer, with the product purshased from tblProduct, in addition with calculationsC my Post 2 u'r other Query http://dbforums.com/showthread.php?postid=2986841#post2986841 n start looking @. Grouping SUM() etc,

GW

Math functions

Hi,
How to find the list of SQL math functions in SQL Server 2005?

Thanks

KaiHi,

Got BOL installed ?

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/46495a2e-81d0-4677-9d72-9db083cd1023.htm

You havent ?

http://msdn.microsoft.com/library/e...asp?frame=true

HTH, jens Suessmeyer.

--
http://www.sqlserver2005.de
--|||Thanks.

Kai
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1143827343.530294.311400@.e56g2000cwe.googlegr oups.com...
Hi,

Got BOL installed ?

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/46495a2e-81d0-4677-9d72-9db083cd1023.htm

You havent ?

http://msdn.microsoft.com/library/e...asp?frame=true

HTH, jens Suessmeyer.

--
http://www.sqlserver2005.de
--