function foo() { bar = false; while(bar) { writeoutput("
" & "
"); } } //bar = ""; // baz = ""; /* Multiline comment with function() calls in it for fun */
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go /* +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Name: ps_report_commitment_sent Created by: JPG Date: 10/18/2005 Purpose: Used to generate NLS Closing website Commitment Sent report Modification History =============================================================================================== Rev # Initials Date Purpose =============================================================================================== #001 JPG 10/18/2005 Create +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ */ ALTER PROCEDURE [dbo].[ps_report_commitment_sent] @reporting_entity_id uniqueidentifier, @entity_id_customer uniqueidentifier, @start_date datetime=NULL, @end_date datetime=NULL AS BEGIN SET NOCOUNT ON DECLARE @colorder varchar(4000) SET @colorder = 'Order#|loan#|date_ordered|loan_officer|buyer|state|status' -- Order of columns for report SELECT DISTINCT dbo.f_return_hot_link('ORDER', ob.ORDER_ID, 0, '') AS a_nls_order_num, ol.loan_number as b_loan_number, ob.datetime_created as c_date_ordered, RTRIM(ISNULL(voelo.full_name,'No Loan Officer Specified'))as d_loan_officer, @colorder AS _colorder, FROM order_basic ob WITH(NOLOCK) LEFT OUTER JOIN v_order_entity_simple voelo WITH(NOLOCK) ON ob.order_id = voelo.order_id AND voelo.u_id_order_entity_type = '66CB46AE-8FEA-493B-991D-313ADFB1E609' --'Loan Officer' AND voelo.sort_order = 1 AND voelo.system_status = 1 WHERE ob.entity_id_customer = @entity_id_customer AND DATEDIFF(d,@start_date,ob.datetime_created)>=0 AND DATEDIFF(d,ob.datetime_created,@end_date)>=0 AND DATEDIFF(d,ob.datetime_created,@end_date)<=100 AND ob.entity_id_order_company = @reporting_entity_id ORDER BY c_date_ordered, g_status ENDset ANSI_NULLS ON set QUOTED_IDENTIFIER ON go
Username:
Embedded Image