By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
declare @var float(38);
set @var =(1000.000 / 1271.11);
select 1271.11*@var, @var;
select round(1271.11*@var,9);
select round(1271.11*@var,10);
| (No column name) | (No column name) |
|---|---|
| 999.999999999584 | 0.7867139744 |
| (No column name) |
|---|
| 1000 |
| (No column name) |
|---|
| 999.9999999996 |
declare @var decimal(20,10);
set @var =(1000.000 / 1271.11);
select 1271.11*@var, @var;
select round(1271.11*@var,9);
select round(1271.11*@var,10);
| (No column name) | (No column name) |
|---|---|
| 999.999999999584 | 0.7867139744 |
| (No column name) |
|---|
| 1000.000000000000 |
| (No column name) |
|---|
| 999.999999999600 |
CREATE TABLE stagetest(
id int null,
[month] [varchar](255) NULL,
[year] [float] NULL,
CA_resp [float] NULL,
CA_spen [money] NULL,
TX_resp [float] NULL,
TX_spen [money] NULL,
PA_resp [float] NULL,
PA_spen [money] NULL);
INSERT into stagetest
values(1, 'jan', 2022,222,450,111,450,444,550);
--ID, month,year, market, resp ,spen
-- 1 jan 2022 CA 222 350
-- 1 jan 2022 TX 111 450
-- 1 jan 2022 PA 444
SELECT
id,
[month],
[year],
'CA' market,
ca_resp Resp,
ca_spen Spen
from stagetest
union all
SELECT
id,
[month],
[year],
'PA',
pa_resp,
pa_spen
from stagetest
union all
SELECT
| id | month | year | market | Resp | Spen |
|---|---|---|---|---|---|
| 1 | jan | 2022 | CA | 222 | 450.0000 |
| 1 | jan | 2022 | PA | 444 | 550.0000 |
| 1 | jan | 2022 | TX | 111 | 450.0000 |