QUERY HELP - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

QUERY HELP

Author

Topic

pnpsql
Posting Yak Master

246 Posts

Posted - 2012-08-27 : 07:58:43

TBL_TAX

ID DATEFROM TAX1 TAX2 TAX3
1 '01-01-1900' 10 2 3
2 '01-04-2012' 11 4 1
3 '01-06-2012' 12 2 2

CREATE PROCEDURE GETVALUE
(@PDATE DATETIME ,
@PTAX1 NUMERIC(5,2) OUT ,
@PTAX2 NUMERIC(5,2) OUT ,
@PTAX3 NUMERIC(5,2) OUT )

AS

BEGIN

/*
WHEN @PDATE = '05-MAR-2012'
THE VALUES IN @PTAX1 = 10 , @PTAX1 = 2 AND @PTAX3 = 3

WHEN @PDATE = '07-AUG-2012'
THE VALUES IN @PTAX1 = 12 , @PTAX1 = 2 AND @PTAX3 = 2

*/

END

challenge everything

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-08-27 : 08:21:15

[code]CREATE PROCEDURE GETVALUE
(@PDATE DATETIME ,
@PTAX1 NUMERIC(5,2) OUT ,
@PTAX2 NUMERIC(5,2) OUT ,
@PTAX3 NUMERIC(5,2) OUT )

AS

SELECT TOP (1)
@PTAX1 = TAX1,
@PTAX2 = TAX2,
@PTAX3 = TAX3
FROM
TBL_TAX
WHERE
DATEFROM <= @PDATE
ORDER BY
DATEFROM DESC;
GO[/code]

pnpsql
Posting Yak Master

246 Posts

Posted - 2012-08-28 : 00:34:22

can it be done via function

challenge everything

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources