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
Showing posts with label functions. Show all posts
Showing posts with label functions. Show all posts
Friday, March 30, 2012
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
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
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?
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
--
Subscribe to:
Posts (Atom)