Real _ExistsServiceOffRentItem

09/14/2011 05:10 formatme#1

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

there u go

09/14/2011 05:15 Lupin*#2

Error # 1 [Only registered and activated users can see links. Click Here To Register...]

Error #2 [Only registered and activated users can see links. Click Here To Register...]

do you have an i dea how to fix this?

and btw where do we add this queries in wich database

09/14/2011 05:20 formatme#3

its not connecting 2 ur database

09/14/2011 05:22 Lupin*#4

you have any idea how to fix this please?

09/14/2011 05:33 rushcrush#5

Quote:

Originally Posted by formatme

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

there u go

hmm sorry for this Q
but i forget this table for?
need to so you cant get error?
i really dont remember xD