---
title: "uträkning i flera steg i sp"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/67414-uträkning-i-flera-steg-i-sp"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Dino"
published: "2003-02-06T13:10:36.000Z"
updated: "2003-02-06T13:38:24.000Z"
replies: 4
views: 180
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/67414-uträkning-i-flera-steg-i-sp"
---

# uträkning i flera steg i sp

## #1 — Dino, 2003-02-06T13:10Z

Har en SELECT som retunerar tex 

summa
\----------
3596
1924
4223
12
46
9534
591

Och en annan SELECT som retunerar tex 3

Hur skall jag göra för att dela varje summa i "summa" med 3. Vill att allt detta skall ske inom en sp.

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

## #2 — LarsG, 2003-02-06T13:15Z

Det borde väl gå att få ihop i en fråga

```
select summa/(select antal from t where pk = 4711) from t2
```

ungefär.

Du får nog delge lite mer detaljer.

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

## #3 — Dino, 2003-02-06T13:22Z

Koden

```
SELECT SUM(dbo.g_qualitypoints.gq_points) AS summa
FROM g_qualitypoints INNER JOIN
          world_qualities ON 
          g_qualitypoints.gq_q_id = 
          world_qualities.qua_id INNER JOIN
          g ON g_qualitypoints.gq_glad_id = 
          gglad_id
WHERE (g_qualitypoints.gq_glad_id IN
             (SELECT glad_id
              FROM g
              WHERE (glad_team_id = 1))) AND 
             (world_qualities.qua_category = 'combat')
GROUP BY world_qualities.qua_part
```

 
Retunerar tex:
summa 
\---------- 
3596 
1924 
4223 
12 
46 
9534 
591 

```
SELECT COUNT(glad_id) AS antal
FROM g
WHERE (glad_team_id = 1)
```

 
Retunerar tex: 3

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

## #4 — LarsG, 2003-02-06T13:34Z

```
SELECT SUM(dbo.g_qualitypoints.gq_points)/
 (select count(*) from g 
where glad_team_id = g_qualitypoints.gq_glad_id) AS antal
FROM g
WHERE (glad_team_id = 1)
 AS summa
FROM g_qualitypoints INNER JOIN
          world_qualities ON 
          g_qualitypoints.gq_q_id = 
          world_qualities.qua_id INNER JOIN
          g ON g_qualitypoints.gq_glad_id = 
          gglad_id
WHERE (g_qualitypoints.gq_glad_id IN
             (SELECT glad_id
              FROM g
              WHERE (glad_team_id = 1))) AND 
             (world_qualities.qua_category = 'combat')
GROUP BY world_qualities.qua_part
```

Typ.

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

## #5 — Dino, 2003-02-06T13:38Z

Jo det funkade fint. Tack. :)

Red/ Kunde göra så här med.

```
DECLARE @antal int
SET @antal = (SELECT COUNT(glad_id)
FROM g
WHERE (glad_team_id = 1))

SELECT SUM(g_qualitypoints.gq_points)/(@antal) AS summa
...
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/67414-uträkning-i-flera-steg-i-sp