Real _ExistsServiceOffRentItem

formatme · 09/14/2011, 05:10

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

Lupin* · 09/14/2011, 05:15

Error # 1

Error #2

do you have an i dea how to fix this?

and btw where do we add this queries in wich database

formatme · 09/14/2011, 05:20

its not connecting 2 ur database

Lupin* · 09/14/2011, 05:22

you have any idea how to fix this please?

~~rushcrush~~ · 09/14/2011, 05:33

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