Guest User

Untitled

a guest
Dec 18th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. SET ANSI_NULLS ON
  2. GO
  3.  
  4. SET QUOTED_IDENTIFIER ON
  5. GO
  6.  
  7.  
  8.  
  9. CREATE procedure [dbo].[_ExistsServiceOffRentItem]
  10. as
  11.  
  12. if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
  13. begin
  14. return -1
  15. end
  16.  
  17.  
  18. GO
Add Comment
Please, Sign In to add comment