Repository navigation

SQL

Public

About

No description, website, or topics provided.

0 stars

1 watching

Report repository

Name		Name	Last commit message	Last commit date
CTE.sql		CTE.sql
CashierProcessDayAlgorithm.sql		CashierProcessDayAlgorithm.sql
Date.sql		Date.sql
ETL_Cash_Dashboard.sql		ETL_Cash_Dashboard.sql
ETL_reloadUAT_PS_fromProd.sql		ETL_reloadUAT_PS_fromProd.sql
FindDBcolumns.sql		FindDBcolumns.sql
FindDBcolumns.txt		FindDBcolumns.txt
GetDesc.sql		GetDesc.sql
GetLoanDLQ_12month_extract.sql		GetLoanDLQ_12month_extract.sql
GetMonthYear.sql		GetMonthYear.sql
Get_sprocs.sql		Get_sprocs.sql
IS_850_dataValidation.sql		IS_850_dataValidation.sql
LinearCount.sql		LinearCount.sql
LinearCount.txt		LinearCount.txt
Loop_12month_extract.sql		Loop_12month_extract.sql
Pivot_DynamicColumns.sql		Pivot_DynamicColumns.sql
Pivot_PS_state.sql		Pivot_PS_state.sql
ProdVersion_PS_state.sql		ProdVersion_PS_state.sql
README.md		README.md
SSRS_report_usage.sql		SSRS_report_usage.sql
SSRScalendar.sql		SSRScalendar.sql
SSRSfolders.sql		SSRSfolders.sql
TemplateIDwithStepsCrosswalk.sql		TemplateIDwithStepsCrosswalk.sql
TieBreaker.sql		TieBreaker.sql
TieBreaker_LM.sql		TieBreaker_LM.sql
ToolsForLocatingDataElements.docx		ToolsForLocatingDataElements.docx
Type.sql		Type.sql
UATtoProd_import.sql		UATtoProd_import.sql
VBA.txt		VBA.txt
addComputedColumns.sql		addComputedColumns.sql
cashMTD_MonetaryMetrics.sql		cashMTD_MonetaryMetrics.sql
charindexStringParse.sql		charindexStringParse.sql
charindexStringSearch.sql		charindexStringSearch.sql
checkImports.sql		checkImports.sql
checkPS_MaxLoanDate.sql		checkPS_MaxLoanDate.sql
clientCode.sql		clientCode.sql
collapseDupesWithNullsToOneRow.sql		collapseDupesWithNullsToOneRow.sql
convertTimeToSecondsThenTohhmmss.sql		convertTimeToSecondsThenTohhmmss.sql
daily_transfers_import.sql		daily_transfers_import.sql
dateDesc.sql		dateDesc.sql
dates_rowNumber() Over_CTE.sql		dates_rowNumber() Over_CTE.sql
dbo.sp_Timeline_Matrix_Aging.StoredProcedure.sql		dbo.sp_Timeline_Matrix_Aging.StoredProcedure.sql
dynamic select		dynamic select
dynamic select.sql		dynamic select.sql
dynamicallyGen6ConsecutiveMonths.sql		dynamicallyGen6ConsecutiveMonths.sql
etl.sql		etl.sql
exec_PIF_SCI_OLLOW.sql		exec_PIF_SCI_OLLOW.sql
fix_PortfolioSummaryTables.sql		fix_PortfolioSummaryTables.sql
get12Months.sql		get12Months.sql
getAllProcsWithColumn.sql		getAllProcsWithColumn.sql
getAllTablesWithColumn.sql		getAllTablesWithColumn.sql
getAspNetUsers.sql		getAspNetUsers.sql
getBusinessDay.sql		getBusinessDay.sql
getBusinessDay.txt		getBusinessDay.txt
getClientDLQ.sql		getClientDLQ.sql
getDataDictionary.sql		getDataDictionary.sql
getDate_NotHolidayNotWeekend.sql		getDate_NotHolidayNotWeekend.sql
getDelinquency_Snapshot_Totals.sql		getDelinquency_Snapshot_Totals.sql
getDynMonths.sql		getDynMonths.sql
getEscrow_Day_PriorDay_Month_PriorMonth.sql		getEscrow_Day_PriorDay_Month_PriorMonth.sql
getEscrow_EscrowAdv_EscrowDisb.sql		getEscrow_EscrowAdv_EscrowDisb.sql
getLoTypeDescription.sql		getLoTypeDescription.sql
getLoanType.sql		getLoanType.sql
getLoansByUPB_range.sql		getLoansByUPB_range.sql
getMaxLoanDate.sql		getMaxLoanDate.sql
getQuarters.sql		getQuarters.sql
getServerInfo.sql		getServerInfo.sql
getState.sql		getState.sql
getTransactionPayment.sql		getTransactionPayment.sql
get_template_and_lm_stepcode_Descriptions.sql		get_template_and_lm_stepcode_Descriptions.sql
importTestData.sql		importTestData.sql
incrementWhile.sql		incrementWhile.sql
ivr_patindex.sql		ivr_patindex.sql
link.sql		link.sql
loanDetail_DrillThrough.sql		loanDetail_DrillThrough.sql
loansWithoutValidLoanNumber.sql		loansWithoutValidLoanNumber.sql
localDB.sql		localDB.sql
loginLogout.sql		loginLogout.sql
myReportingTables.sql		myReportingTables.sql
myStuff.sql		myStuff.sql
paymentTransByTransCode.sql		paymentTransByTransCode.sql
populateCurrMthWithPriorMth.sql		populateCurrMthWithPriorMth.sql
portfolio_summary_rpt_.sql		portfolio_summary_rpt_.sql
recommendation systems		recommendation systems
refreshLocal.sql		refreshLocal.sql
reload_DS_indexes.sql		reload_DS_indexes.sql
removeDups.sql		removeDups.sql
reportServerStats.sql		reportServerStats.sql
rowRank.sql		rowRank.sql
rowcounts.sql		rowcounts.sql
sd vb2.sql		sd vb2.sql
sd.sql		sd.sql
sd1.sql		sd1.sql
searchDB.sql		searchDB.sql
sp_BorrowerPaymentHabits_allVersions.sql		sp_BorrowerPaymentHabits_allVersions.sql
sp_abandonmentRate.sql		sp_abandonmentRate.sql
sqlText.sql		sqlText.sql
sqlxml		sqlxml
state_cd_name.sql		state_cd_name.sql
time.sql		time.sql

Repository files navigation

SQL code samples

About

No description, website, or topics provided.

0 stars

1 watching

Report repository

Releases

Packages

Contributors

Languages