Jag får ej några önskade resultat tillbaka från denna SP'n... nån som ser nåt som verkar fel ?
@VarUser INT,
@VarSerial INT,
@VarClient INT,
@VarCurrentStatus INT,
@VarReceivedDate DATETIME
AS
SET NOCOUNT ON
Declare @WhereString VARCHAR(800)
Select
tblPostlist.PostListID,
tblPostlist.Serial,
tblPostlist.CurrentStatusList,
tblPostlist.ActionDate,
tblPostList.OrgID,
tblPostlist.PostTypeID,
tblPostlist.ContactID,
tblPostlist.SerialNumber,
tblPostlist.ReceivedDate,
tblPostlist.SentDate,
tblPostlist.Sender,
tblPostlist.SentFrom,
tblPostlist.SentTitle,
tblPostlist.FileRefNo,
tblPostlist.OfficeList,
tblPostlist.Notes,
tblPostlist.SubClient,
tblPostListType.PostTypeID,
tblPostlistType.[Description],
tblOrganisations.OrgID,
tblOrganisations.OrgShortName
from
tblPostlist
Left outer join tblPostListType on tblPostlist.PostTypeID = tblpostListType.PostTypeID
Left outer join tblOrganisations on tblOrganisations.OrgID = tblPostList.OrgID
SET @WhereString = 'WHERE '
IF @VarUser IS not NULL
Set @WhereString = @WhereString + 'tblPostList.ContactID = ' + @VarUser + ' AND '
IF @VarSerial IS not NULL
Set @Wherestring = @WhereString + ' tblPostList.Serial = ' + @VarSerial + ' AND '
IF @VarClient IS not NULL
Set @WhereString = @WhereString + 'tblPostList.OrgID = ' +@VarClient + ' AND '
IF @VarCurrentStatus IS not Null
Set @WhereString = @WhereString + 'tblPostList.CurrentStatusList = ' + @VarCurrentStatus + ' AND '
IF @VarReceivedDate IS not NULL
Set @WhereString = @WhereString + 'tblPostList.ReceivedDate = ' + @VarReceivedDate + 'AND'
GO