|
| | | Forum Guru
 
Group: Forum Members
Last Login: 9/8/2008 5:20:14 PM
Posts: 51, Visits: 183 |
| We've been using a product (PSQL) for awhile that let's us import all of our Point data into an SQL database for reporting/dashboards. Since we moved to PDS (PSQL still help with certain reports), we've really ramped up our reporting via ASP and ASP.NET. I feely admit I'm a novice at SQL and web integration, but I've been pushing myself very hard to get up to speed.
What kinds of things have the community in general been doing?
Here are a couple pieces of our stored procedures that may be helpful:
Get status of a loan:
Create function [dbo].[Custom_Status]
(
@Status int
)
returns nvarchar(14)
as
begin
declare @ret nvarchar(14)
select @ret = 'Status'
select @ret = case
when @Status = 1 then 'Opened'
when @Status = 2 then 'Submitted'
when @Status = 3 then 'Approved'
when @Status = 4 then 'CTC'
when @Status = 5 then 'Documents'
when @Status = 6 then 'On Hold'
when @Status = 7 then 'Recorded'
when @Status = 8 then 'Closed'
when @Status = 9 then 'Suspended'
when @Status = 10 then 'Denied'
when @Status = 11 then 'Cancelled'
else Null
end
return @ret
end
in your select statment, this would get the Status, basically if f6022 is something other than the standard 11 statues use the Custom Status field: ISNULL(dbo.Custom_Status(f.f6022), f.f6024)
We have a significant amount of Stored Procedures that do things from select the most current Loan for a borrower for mailings to showing sales what their earnings rankings are for the month.
I'm really curious what other types of things people are doing.... |
| |
|
|