user log
{ts '2024-10-09 08:53:04'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                firstName, lastName, 
                organization,
                address1, address2, 
                city, state, zipCode,
                phone, cellPhone
                email, 
                title, 
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 78
-- MSC
-- 135328

{ts '2024-10-09 08:53:41'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                firstName, lastName, 
                organization,
                address1, address2, 
                city, state, zipCode,
                phone, cellPhone
                email, 
                title, 
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 08:55:42'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 08:58:03'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 08:58:57'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:01:27'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:03:18'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:07:03'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:07:12'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:09:00'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:09:07'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:14:44'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:15:57'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:22:06'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:22:19'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:45:50'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:46:13'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:46:30'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:53:35'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328

{ts '2024-10-09 09:55:03'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;
    declare @fspro_userId int = ?;


    with data as (
        select  fspro_userId, ownerId, fsl_tablecode, 
                nullif( firstName, '' ) firstName, nullif( lastName, '' ) lastName, 
                nullif( organization, '' ) organization,
                nullif( address1, '' ) address1, nullif( address2, '' ) address2, 
                nullif( city, '' ) city, nullif( state, '' ) state, nullif( zipCode, '' ) zipCode,
                nullif( phone, '' ) phone, nullif ( cellPhone, '' ) cellPhone,
                nullif( email, '' ) email,
                nullif( title, '' ) title,
                staffMember, loginEnabled
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and fspro_userId = @fspro_userId
    )


    
, data_preData as (

	
	select *
	  from data 
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		       , count(*) over() as fseRowCount 
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by lastName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount,
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 21
-- MSC
-- 135328