projects log
{ts '2025-07-03 12:58:50'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 13:24:30'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 13:25:30'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


	order by projectName
		
		
		 offset 0 rows fetch next 20 rows only
	
	)

	
	, projects_result as (
		select ( select count(*) from projects_data ) as totalCount, 
			   
		       ( select * from projects_return for json auto, include_null_values ) as data
		)


	select * from projects_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER

{ts '2025-07-03 13:36:31'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 13:36:40'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 13:39:53'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 13:56:50'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 13:56:55'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 13:57:17'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 13:58:25'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 14:00:39'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 14:01:06'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 14:01:33'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 14:05:27'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 14:06:41'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 14:11:39'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 14:11:45'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 14:14:29'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 14:14:43'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 14:21:45'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 14:22:27'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return

{ts '2025-07-03 14:23:53'} SQL
declare @ownerId int = 207 ;
    declare @ownerType varchar(3) = 'MFR' ;

    with projects as (

        select p.projectId,
                p.projectName, 
                p.startDate,
                p.endDate,
                nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId,
                m.firstName + ' ' + m.lastName as projectOwnerFullName

        from tbl_WRK_Projects p with (nolock)

        left outer join tbl_FSPRO_Members m with (nolock)
           on m.ownerId = p.ownerId
           and m.fsl_tablecode = p.ownerType
           and m.fspro_userId = p.projectOwnerUserId

        where p.ownerId = @ownerId
        and p.ownerType = @ownerType

        
        and p.projectId in ( -1 )
        

    )

    


, projects_mappedData as (

	select *
		
	  from projects

)

, projects_preData as (

	
	select *
	  from projects_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, projects_data as (

		select * 
		        
		  from projects_preData
		  

	)



	, projects_return as (
		select * from projects_data
		where 1 = 1


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

	
	select * from projects_return