ALTER PROCEDURE [dbo].[spCustomers_GetCustomers]
@idCurUser  uniqueidentifier,
@idOwnerBranch uniqueidentifier = '11111111-1111-1111-1111-111111111111'
AS
BEGIN
	SET NOCOUNT ON;
	IF @idOwnerBranch = '11111111-1111-1111-1111-111111111111'
		BEGIN 
		SELECT * FROM vwCustomers ;
		END
	ELSE
		BEGIN
		SELECT * FROM vwCustomers WHERE idOwnerBranch = @idOwnerBranch;
		END
	
EXEC spLog_AddRecord @idCurUser, "SELECT", "vwCustomers";

END

Public Function GetCustomers(CurrentUser As CCurrentUser, Optional ByVal IDCurrentUserBranch As String) As ADODB.Recordset
  Dim rs As ADODB.Recordset
  Dim cmd As New ADODB.Command
    cmd.CommandText = "spCustomers_GetCustomers"
    If IsMissing(IDCurrentUserBranch) Or IDCurrentUserBranch = vbNullString Then
      Set rs = App.DBCore.ExecuteCommand(cmd)
    Else
      Set rs = App.DBCore.ExecuteCommand(cmd, cmd.CreateParameter("@idOwnerBranch", adGUID, adParamInput, , IDCurrentUserBranch))
    End If
  Set GetCustomers = rs
End Function