CREATE PROCEDURE [QuickTeam].[usp_GetWorkSheetById] 

	@WorkSheetId bigint

AS

BEGIN

	SET NOCOUNT ON;

	--select * from  [QuickTeam].[WorkSheet] where WorkSheetId=@WorkSheetId

	select ws.*,wv.VersionCode from  [QuickTeam].[WorkSheet] as ws

	left join [QuickTeam].[WorkSheetVersion] wv on ws.CurrentVersionId=wv.VersionId

	 where ws.WorkSheetId=@WorkSheetId

END