---
title: "Sökning"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/82933-sökning"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "SteveP"
published: "2003-07-28T15:33:31.000Z"
updated: "2003-07-29T11:52:43.000Z"
replies: 1
views: 146
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/82933-sökning"
---

# Sökning

## #1 — SteveP, 2003-07-28T15:33Z

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
```

Permalänk: https://www.webforum.nu/p/82933

## #2 — aasah, 2003-07-29T11:52Z

Kan du ange hur tabellerna ser ut?

Permalänk: https://www.webforum.nu/p/1123021

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/82933-sökning