---
title: "Ta ut ett annat värde om det finns"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/157346-ta-ut-ett-annat-värde-om-det-finns"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Dino"
published: "2007-02-19T10:22:04.000Z"
updated: "2007-02-19T10:29:23.000Z"
replies: 2
views: 237
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/157346-ta-ut-ett-annat-värde-om-det-finns"
---

# Ta ut ett annat värde om det finns

## #1 — Dino, 2007-02-19T10:22Z

SQLServer 2005

Vill ta ut alla från Snippets där Snippets.LanguageId = @languageid, men om det skulle finnas en post i AppSnippets där AppSnippets.SnippetsId = Snippets.Id och AppSnippets.AppId = @appid, så skall AppSnippets.Value returneras istället för Snippets.Value.

```
CREATE TABLE [Snippets] (
	[Id] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL ,
	[LanguageId] [int] NOT NULL ,
	[Key] [varchar] (50) NOT NULL ,
	[Value] [nvarchar] (1000) NOT NULL ,
	CONSTRAINT [PK_Snippets] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [AppSnippets] (
	[SnippetsId] [int] NOT NULL ,
	[AppId] [int] NOT NULL ,
	[Value] [nvarchar] (1000) NOT NULL ,
	CONSTRAINT [PK_AppSnippets] PRIMARY KEY  CLUSTERED 
	(
		[SnippetsId],
		[AppId]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

INSERT INTO [dbo].[Snippets]([LanguageId], [Key], [Value]) VALUES(1,'aaa','defaultstring_aaa')
INSERT INTO [dbo].[Snippets]([LanguageId], [Key], [Value]) VALUES(1,'bbb','defaultstring_bbb')
INSERT INTO [dbo].[Snippets]([LanguageId], [Key], [Value]) VALUES(1,'ccc','defaultstring_ccc')

INSERT INTO [dbo].[AppSnippets]([SnippetsId], [AppId], [Value]) VALUES(2,1,'customstring_bbb')
```

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

## #2 — LarsG, 2007-02-19T10:25Z

```
select coalesce(AppSnippets.value,Snippets.Value),
     <otherColumns>
   from Snippets left join AppSnippets 
   on AppSnippets.SnippetsId = Snippets.Id
   and AppSnippets.AppId = @appid
 where Snippets.LanguageId = @languageid
```

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

## #3 — Dino, 2007-02-19T10:29Z

Klockrent som vanligt. Tackar så mycket.

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/157346-ta-ut-ett-annat-värde-om-det-finns