iVend Database Database : usp_InvInventoryItem_Condition User Defined Function

Creation Date

12/14/2015 3:17 PM

Encrypted

Ansi Nulls

Parameter

Direction

Description

Data Type

Size

@RETURN_VALUE

Return Value

VarWChar

1073741823

Database Object

Object Type

Description

Dep Level

CfgSiteInformation

Table

Stores the site information. Enterprise always has the site id as 1. System Table Warning : Should not be modified directly

1

RtlStore

Table

Contains the details of Stores defined in the system.

1

CREATE FUNCTION [dbo].[usp_InvInventoryItem_Condition]()

RETURNS nvarchar(max)

AS

BEGIN

            -- Declare the return variable here

            DECLARE @condition nvarchar(max)

            -- Add the T-SQL statements to compute the return value here

            Select   @condition = WarehouseKey From dbo.RtlStore Inner Join CfgSiteInformation On RtlStore.SiteId = CfgSiteInformation.SiteId

            -- Return the result of the function

            RETURN 'dbo.InvInventoryItem.WarehouseKey =' + @condition

END