• 0

[SQL Server 2012] Create view with variables


Question

Hey guys.

I'm tryin to create a view but I'm using a variable to use in an union with other view, but I can't create the view properly.

My code is the this one:

 

CREATE VIEW QRFACTNCNETA2 AS
DECLARE @IVA INT
SET @IVA=0
SELECT 
DOCUMENTO=
CASE
WHEN D.SERIE='N' THEN 'Nota de Credito'
WHEN D.SERIE='NR' THEN 'Nota de Credito'
END,
CONCAT(d.SERIE,'-',d.NNOT) AS NO_DOCUMENTO,
d.FECHA, 
-d.SUBTOTAL AS SUBTOTAL,
IVA AS IVA,
IVA AS IVAMN,
d.TC, 
d.MONEDA, 
(-D.SUBTOTAL*D.TC) AS SUBTOTALMN, 
d1.NOCLIENTE, 
d1.RAZONSOCIAL,
d2.NOVENDEDOR,
d2.NOMBRE
FROM
    dbo.NOTAS d
    INNER JOIN dbo.CLIENTES d1 ON (d.CLIENTE=d1.NOCLIENTE)
	INNER JOIN dbo.VENDEDOR d2 ON (d1.NOVENDEDOR=d2.NOVENDEDOR)
	WHERE D.NNOT NOT LIKE '0' AND (D.APLICADA=1 OR D.SALDO>0)

I'm using the variable twice time, because in the other view I have 2 type of IVA (normal IVA and IVAMN)

I read that I can use a procedure or a parameter, but I can't get it well, In other example I saw this one, but I can't addapted it to mine:

 

CREATE view v_variables
	AS
		Declare @b DATE
	SET @B=CAST(DATEADD(DD,-7,GETDATE()) AS DATE)
SELECT *
FROM VIEWTABLE
WHERE NAMEDATE>=@b

And they addapted it as this way:

CREATE VIEW v_variables
	AS
	WITH dts AS(
	SELECT CAST(DATEADD(DD,-7,GETDATE()) AS DATE) AS P)
SELECT V.NAME
	  ,V.NAMEDATE
FROM VIETABLE V
CROSS APLY dts d
WHERE V.NAMEDATE>=d.P

 

I tried to apply on my own code, but I can't do it, because I didn't know what put inter the "SELECT CAST" if I need the variable equals 0.

 

Can anybody help me or guide me how I have to do it, please?

Sorry for my poor englis.

Regads.

Edited by tetsu-kun

1 answer to this question

Recommended Posts

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • AMD thinks Ryzen Threadripper 9000 wipes the floor with Intel by Sayan Sen At Computex 2025 earlier this year, AMD revealed its new Zen 5-based Ryzen Threadripper 9000 series with up to 96 cores, comprising the PRO 9000WX series and 9000 series chips. At the time though the company did not share performance numbers but given the specs, we had a fairly good idea of their capability. For those who may not be familiar with Ryzen Threadripper, it is AMD's desktop CPU lineup meant for workstations and HEDT (high-end desktop) builds and is placed between the mainstream Ryzen and the server EPYC lineups. With the launch expected to happen next month, performance numbers for the Ryzen Threadripper 9000 are now out. Before diving into the performance details, AMD has also shared a recap of some of the platform details and the compatible sTR5 socket. These new premium chips support up to 8 channels of DDR5-6400 memory and up to 128 PCIe 5.0 lanes for I/O. AMD also promises over 7000 MT/s of DDR5 support with EXPO. The specs of the Ryzen Threadripper 9000 lineup are given below: Processor SKU Cores Threads Base Clock (GHz) Boost Clock (GHz) L3 Cache (MB) Memory Channels PCIe Lanes TDP (W) AMD Ryzen Threadripper PRO 9995WX 96 192 2.5 5.45 384 8‑channel DDR5‑6400 ECC 128 PCIe Gen5 350 AMD Ryzen Threadripper PRO 9985WX 64 128 3.2 5.4 384 8‑channel DDR5‑6400 ECC 128 PCIe Gen5 350 AMD Ryzen Threadripper PRO 9975WX 32 64 3.2 5.4 384 8‑channel DDR5‑6400 ECC 128 PCIe Gen5 350 AMD Ryzen Threadripper PRO 9965WX 24 48 3.2 5.4 384 8‑channel DDR5‑6400 ECC 128 PCIe Gen5 350 AMD Ryzen Threadripper PRO 9955WX 16 32 3.2 5.4 384 8‑channel DDR5‑6400 ECC 128 PCIe Gen5 350 AMD Ryzen Threadripper PRO 9945WX 12 24 3.2 5.4 384 8‑channel DDR5‑6400 ECC 128 PCIe Gen5 350 AMD Ryzen Threadripper 9980X 64 128 3.2 5.4 256 4‑channel DDR5‑6400 92 PCIe Gen5 350 AMD Ryzen Threadripper 9970X 32 64 3.2 5.4 256 4‑channel DDR5‑6400 92 PCIe Gen5 350 AMD Ryzen Threadripper 9960X 24 48 3.2 5.4 256 4‑channel DDR5‑6400 92 PCIe Gen5 350 AMD has compared the 96-core 9995WX against the previous-gen 7995WX (images below), also with the same core configuration, and the 64-core 9980X, against Intel's 60-core Xeon W9-3595X. While Xeon has generally been associated with Server CPUs, the Xeon W chips are designed to be used in workstations. AMD follows a similar naming, too, wherein the W in the WX is meant to indicate workstation, and the non-W Threadripper is for HEDT. AMD claims up to 26% faster throughput on the newer 96-core 9995WX compared to the 7995WX. Meanwhile, against the Intel Xeon w9-3595X, AMD expects utter dominance from its 9980X with up to 108% faster performance. Even the lowest gain, says the company, is 22% over the Intel chip, and that is still very significant. AMD also compared the AI performance of the 9995WX vs the Xeon w9-3595X. The company promises up to 49% faster LLM processing, but keep in mind that the figures given include a GPU as well. Besides AI, performance related to other creative and professional workloads was also shared. In Keyshot rendering, for example, AMD claims up to 119% gains over the Xeon SKU. And in Chaos V-Ray, the 9995WX is said to offer nearly 2.5 times the performance. AMD has not released pricing information for the Threadripper 9000 series.
    • Funk Microsoft - I would switch from PS5 as you have better deals but the Xbox interface (I tried One S and later on, even one X i hate the interface and considering all MS changes in Windows interface over the years.. I hope they have a good one coming ps5 has also weird interface I had to get used too. But considering the library of ps4 games I wanted to be playable for me… I got used and adapted
    • I loved Sonic CD so much. I think I must have almost worn out that disc!
    • For what it's worth, if the game was scheduled for a September release, then most if not all of art assets, etc. were complete. That's the really expensive part of any AAA game. So going back into the code, game play, combat loop, etc. should be much easier and faster than re-imagining the look of the game entirely. That took years and zillions to create.
  • Recent Achievements

    • First Post
      Ian_ earned a badge
      First Post
    • Explorer
      JaviAl went up a rank
      Explorer
    • Reacting Well
      Cole Multipass earned a badge
      Reacting Well
    • Reacting Well
      JLP earned a badge
      Reacting Well
    • Week One Done
      Rhydderch earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      653
    2. 2
      ATLien_0
      267
    3. 3
      Michael Scrip
      218
    4. 4
      +FloatingFatMan
      188
    5. 5
      Steven P.
      146
  • Tell a friend

    Love Neowin? Tell a friend!