Quote:
Originally Posted by gandras16
!!! there is no record in this [_RefRentItem] table !!! .... how fix this? 
|
This still not works for me!!
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
But it still gives me the same error