sql

USE [Martz]
GO
/****** Objeto:  StoredProcedure [dbo].[Martz_transpaso1]    Fecha de la secuencia de comandos: 03/13/2019 16:48:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE  [dbo].[Martz_transpaso1] @Sucursal as nvarchar(50),  @Accion as nvarchar(50), @Vale as nvarchar(50)
AS
Begin
Declare @varQuery nvarchar (1000)

Select @varQuery =
       

'SELECT suc.NoParte, suc.NombreProd, cat.Categoria, suc.Unidad, LR.Precio_Venta, suc.FechaIngreso, suc.Serie, suc.Autorizo, suc.Mensajero, alm.Mercancia, suc.FecSist, suc.Usuario, suc.IdTraspaso '+
'FROM '+ @Sucursal  +' AS suc INNER JOIN '+
'dbo.CatCategoria AS cat ON suc.IdCategoria = cat.IdCategoria INNER JOIN '+
'dbo.CatAlmacen AS alm ON suc.StMercancia = alm.StMercancia INNER JOIN '+
'dbo.Lista_Refacciones AS LR ON suc.NoParte = LR.Producto '+
'WHERE   suc.NoParte <>'''''

If  @Accion <>'Buscar'
Select @varQuery =  @varQuery + ' AND IdTraspaso ='''''


Else If @Vale IS NOT  NULL
  Select @varQuery =  @varQuery + ' AND IdTraspaso =''' +@Vale +''''

 Select @varQuery =  @varQuery +' ORDER BY id DESC'
EXECUTE sp_executesql  @varQuery ;