• 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

    • Amazon Deals: Samsung Q990F Q900F Q800F 2025 Dolby Atmos soundbars with wireless subwoofers by Sayan Sen While separate AV receivers with hi-fi speakers are generally the preferred way to listed to music and watch movies/shows by audiophiles, the more general folks often prefer soundbars instead as they offer a capable all in one solution that is still plenty good. Currently Nakamichi is running discounts on multiple products from its Dragaon lineup as well as its Shockwafe model. If you are looking for more options to choose from Samsung has its Q-series products at lowest prices (purchase links towards the end of article). Q990F The flagship Q990F is an 11.1.4 system and the single subwoofer unit on it houses two opposite-facing 8-inch subwoofer drivers. Thus, together they move around the same amount of air as a single 12-inch subwoofer unit. In addition to increasing the bass by +3 dB, dual opposing drivers are also said to help reduce vibrations of the subwoofer cabinet by cancelling out the resonance. Samsung also says that the bass is "AI-optimized" but we are not sure if it actually helps or if it's just a buzz term here. Aside from the bass, dialogue in movies is the second most important thing, and Samsung claims great vocal clarity from its front speakers thanks to AVA (Active Voice Amplifier) Pro feature that is said to detect noise disturbances and amplify dialogue to make it more audible over such surrounding noises. Q900F Feature wise the Q900F is similar to the 990F model except it has fewer channels and it is a 7.1.2 setup. Finally the Q800F is a 5.1.2 system and it has a passive radiator instead of the additonal subwoofer driver unit. Get the Samsung Q series soundbars at the links below: Samsung Q990F 11.1.4ch Wireless Dolby Atmos, Q-Symphony, Game Mode Pro, Adaptive Sound (HW-Q990F, 2025): $1497.99 (Shipped and Sold by Amazon US) Samsung HW-Q900F 7.1.2 ch Wireless Dolby Atmos, Q-Symphony: $997.99 (Shipped and Sold by Amazon US) Samsung Q800F 5.1.2ch Q Series Soundbar + Subwoofer, Wireless Dolby Atmos, Q-Symphony, Game Mode Pro, Smart Integration (HW-Q800F, 2025): $697.99 (Shipped and Sold by Amazon US) This Amazon deal is US-specific and not available in other regions unless specified. If you don't like it or want to look at more options, check out the Amazon US deals page here. Get Prime (SNAP), Prime Video, Audible Plus or Kindle / Music Unlimited. Free for 30 days. As an Amazon Associate, we earn from qualifying purchases.
    • They are shifting into AI now. Don't you see?
    • Exactly. No need to pay to rent a license. I'd rather own it.
  • Recent Achievements

    • One Month Later
      Helen Shafer earned a badge
      One Month Later
    • One Month Later
      ambani880 earned a badge
      One Month Later
    • Week One Done
      ambani880 earned a badge
      Week One Done
    • First Post
      artistro08 earned a badge
      First Post
    • First Post
      paul29 earned a badge
      First Post
  • Popular Contributors

    1. 1
      +primortal
      498
    2. 2
      ATLien_0
      223
    3. 3
      Michael Scrip
      196
    4. 4
      Xenon
      160
    5. 5
      +FloatingFatMan
      138
  • Tell a friend

    Love Neowin? Tell a friend!