SELECT * FROM MY_DATA WITH (NOLOCK) IF @@ROWCOUNT>=1 BEGIN SELECT * FROM MY_DETAIL WITH (NOLOCK) END ELSE BEGIN SELECT 'NO RECORDS' END
declare @count varchar(50) select @count=count(1) from MY_DATA WITH (NOLOCK) IF @count>=1 BEGIN SELECT * FROM MY_DETAIL WITH (NOLOCK) END ELSE BEGIN SELECT 'NO RECORDS' END
SELECT * FROM MY_DETAIL WITH (NOLOCK) WHERE EXISTS (SELECT MAX(1) FROM MY_DATA WITH (NOLOCK) )
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)