This still not works for me!!Quote:
[Only registered and activated users can see links. Click Here To Register...]
!!! there is no record in this [_RefRentItem] table !!! .... how fix this? :)
I did this:
Srry Guys delete _ExistsServiceOffRentItem db and execute this new one
Code:
PHP Code: /****** Object: StoredProcedure [dbo].[_ExistsServiceOffRentItem] Script Date: 09/13/2011 12:03:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE procedure [dbo].[_ExistsServiceOffRentItem] as if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) ) begin return -1 end GO