hello
i have the following view in sql server and i want to change the data type of runout to numeric(18,2)
but it doesn't work
can you say me please how to do this?
thankl you
ALTER VIEW [dbo].[View_3]
AS
SELECT dbo.v_numberofpnverbrauch.numberofpnforverbrauch, dbo.[v_numberofpnfordiff<0].numberofpn AS [fordiff<0],
dbo.v_numberofpnforeachdisponent.numberofpn AS foreachfehlteil, dbo.v_numberofpnverbrauch.Disponent,
dbo.v_numberofpnforeachdisponent.Fehlteil_Code_Bezeichnung,
cast(dbo.[v_numberofpnfordiff<0].numberofpn / dbo.v_numberofpnverbrauch.numberofpnforverbrauch AS runout as numeric(18,2))
FROM dbo.[v_numberofpnfordiff<0] INNER JOIN
dbo.v_numberofpnverbrauch ON dbo.[v_numberofpnfordiff<0].Disponent = dbo.v_numberofpnverbrauch.Disponent INNER JOIN
dbo.v_numberofpnforeachdisponent ON dbo.v_numberofpnverbrauch.Disponent = dbo.v_numberofpnforeachdisponent.Disponent
GROUP BY dbo.v_numberofpnverbrauch.numberofpnforverbrauch, dbo.[v_numberofpnfordiff<0].numberofpn, dbo.v_numberofpnforeachdisponent.numberofpn,
dbo.v_numberofpnverbrauch.Disponent, dbo.v_numberofpnforeachdisponent.Fehlteil_Code_Bezeichnung
GO