---
title: "insert i sp"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/116028-insert-i-sp"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "doggelito"
published: "2004-11-16T12:03:29.000Z"
updated: "2004-11-16T12:30:45.000Z"
replies: 1
views: 188
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/116028-insert-i-sp"
---

# insert i sp

## #1 — doggelito, 2004-11-16T12:03Z

tjena, får inte till denna!

```
ALTER    PROCEDURE upProduct_Insert
	@CategoryId int, 
	@ArticleNr varchar(20), 
	@Fullname varchar(100), 
	@Notes varchar(4000), 
	@Price money, 
	@Pricecategory varchar(1000), -- '1,2,3'
	@PricecategoryValue varchar(4000) -- '10,20,30'

AS

	Set nocount On

	Declare @Identity as integer

	Insert Into Product
		(CategoryIDno, ArticleNr, Fullname, Notes, Price)
	Values
		(@CategoryId, @ArticleNr, @Fullname, @Notes, @Price)

	Select @Identity = @@Identity

	Create table #tmp1 (value varchar(400))
	Insert Into #tmp1 (value)
	Select value From fn_split(@Pricecategory, ',')

	Create table #tmp2 (value varchar(400))
	Insert Into #tmp2 (value)
	Select value From fn_split(@PricecategoryValue, ',')

Select @Identity
Select value From #tmp1 
Select value From #tmp2	

go
upProduct_Insert 32,'123', 'fsdfsd', 'fsdfsdfasee', 599, '1,2,3', '10,20,30'
```

se bifogad bild för resultat av de 3 selecterna
av dessa vill jag göra en insert i en ny tabell med 3 kolumner och med följande resultat:
30   1   10
30   2   20
30   3   30

hur ser denna insert ut? går den att göra?

Bilagor:

- [resultat.gif](https://www.webforum.nu/a/4969.gif)

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

## #2 — doggelito, 2004-11-16T12:30Z

kom på´t!
la till en identity på inserterna i tmp-tabellerna :)

```
	Create table #tmp1 (IDno int IDENTITY(1,1) NOT NULL, value varchar(400))
	Insert Into #tmp1 (value)
	Select value From fn_split(@Pricecategory, ',')

	Create table #tmp2 (IDno int IDENTITY(1,1) NOT NULL, value varchar(400))
	Insert Into #tmp2 (value)
	Select value From fn_split(@PricecategoryValue, ',')

	Insert Into Product_Pricecategory 
		(ProductIDno, PricecategoryIDno, Notes)
	Select @Identity, t1.value, t2.value From #tmp1 t1 Inner Join #tmp2 t2 on t1.IDno = t2.Idno
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/116028-insert-i-sp