---
title: "visa schema, problem"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/171306-visa-schema-problem"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Vinnaren"
published: "2008-05-07T10:54:49.000Z"
updated: "2008-05-07T18:54:48.000Z"
replies: 7
views: 510
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/171306-visa-schema-problem"
---

# visa schema, problem

## #1 — Vinnaren, 2008-05-07T10:54Z

Har följande:

```
	SELECT (c.FirstName+' '+c.LastName) AS Name,
	(SELECT TOP 1 (ms.FromTime+'-'+ms.ToTime) FROM Schedule AS ms INNER JOIN [Status] AS s ON s.StatusId = ms.StatusId WHERE ms.ChildId = c.ChildId AND YEAR(ms.Date) = @Year AND DatePart(ww, ms.Date) = @Week AND DATEPART(dw, ms.Date) = 2) AS Monday

	FROM Child AS c
```

 

När Monday är null så vill jag istället för att returnera null returnera s.Name, skulle även s.Name vara null ska saknas returneras i Monday.

Hur löser man detta??

Tacksam för all hjälp  :stud

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

## #2 — Peter S, 2008-05-07T11:01Z

```
(SELECT TOP 1 coalesce(ms.FromTime+'-'+ms.ToTime,coalesce(s.Name,'saknas')) FROM Schedule AS ms INNER JOIN [Status] AS s ON s.StatusId = ms.StatusId WHERE ms.ChildId = c.ChildId AND YEAR(ms.Date) = @Year AND DatePart(ww, ms.Date) = @Week AND DATEPART(dw, ms.Date) = 2) AS Monday
```

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

## #3 — Vinnaren, 2008-05-07T11:14Z

tack, men resultatet blir detsamma. Monday innehåller null   :r

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

## #4 — Peter S, 2008-05-07T14:34Z

Iiih! Inlägget är uppdaterat :)

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

## #5 — Vinnaren, 2008-05-07T17:11Z

tack, men det blir fortfarande null :(

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

## #6 — Peter S, 2008-05-07T18:24Z

Hm, så här då:

```
(SELECT TOP 1 case when ms.FromTime is null or ms.ToTime is null then coalesce(s.Name, 'saknas') else ms.FromTime+'-'+ms.ToTime end FROM Schedule AS ms INNER JOIN [Status] AS s ON s.StatusId = ms.StatusId WHERE ms.ChildId = c.ChildId AND YEAR(ms.Date) = @Year AND DatePart(ww, ms.Date) = @Week AND DATEPART(dw, ms.Date) = 2) AS Monday
```

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

## #7 — LarsG, 2008-05-07T18:47Z

```
coalesce((select ...),'saknas')
```

Om subselecten inte hittar någon post så returnerar den null

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

## #8 — Vinnaren, 2008-05-07T18:54Z

tack, nu fungerar den :D

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/171306-visa-schema-problem