Search - Joel Lipman .Com

1. T-SQL example of Case-Sensitive Soundex: / Transact-SQL /; ... the default values which we found we could do with the built-in SOUNDEX function. How? Lets assume the following, we have a table containing: StudentID StudentDetail Soundex ----------------- ...; Created on 10 October 2012
2. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... OR REPLACE PROCEDURE sp_get_studentdetails_from_ad ( p_STUDENT_ADNAME IN varchar2, l_CURSOR OUT sys_refcursor ) IS BEGIN -- going to declare variables that are to be returned in SSRS ...; Created on 19 January 2012
3. Basic Oracle Stored Procedure Structure: / Oracle PL/SQL /; ... [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [stored_procedure_name ]; Example CREATE OR REPLACE PROCEDURE sp_get_studentdetails_from_ad ...; Created on 16 January 2012
4. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... values" to =IIF(LTrim(Parameters!StudentADAccount.Value)="", Parameters!StudentReference.Value, First(Fields!S_STUDENTREFERENCE.Value, "StudentDetails")) should work: Apparently not because ...; Created on 19 July 2011