Leila-2011
پنج شنبه 10 مرداد 1392, 11:01 صبح
سلام
چطوری میتونم یه order by به کوئری زیر اضافه کنم :
declare @SubQueriesPlaceHolder varchar(50)
declare @FiltersPlaceHolder varchar(500)
declare @Qry varchar(max)
declare @SubQueries varchar(max)
declare @Filters varchar(max)
set @Filters = @RepInx;
select @SubQueriesPlaceHolder = '<SubQrueries>',
@FiltersPlaceHolder = '<Filters>',
@Qry = 'select PPA_ID,RepInx,AssembleCode,Counter,PartCode,QcInsC ode,OperatorID' + @SubQueriesPlaceHolder + char(13) + ' from [QC-TempTable] A where RepInx in (' + @FiltersPlaceHolder + ')',
@SubQueries = ''
select @SubQueries += CHAR(13) + ',(SELECT max(PPA_PropertyValue) from [QC-ProcessPropertiesPerAssemble] where PPA_PropertyTitle = ''' + PPA_PropertyTitle + ''') as [' + PPA_PropertyTitle + ']'
from [QC-ProcessPropertiesPerAssemble] WHERE PPA_ProjID=@ProjID AND PPA_ProcID=@ProcID
GROUP BY PPA_PropertyTitle
set @Qry = REPLACE(@Qry, @SubQueriesPlaceHolder, @SubQueries)
set @Qry = REPLACE(@Qry, @FiltersPlaceHolder, @Filters)
exec(@Qry)
چطوری میتونم یه order by به کوئری زیر اضافه کنم :
declare @SubQueriesPlaceHolder varchar(50)
declare @FiltersPlaceHolder varchar(500)
declare @Qry varchar(max)
declare @SubQueries varchar(max)
declare @Filters varchar(max)
set @Filters = @RepInx;
select @SubQueriesPlaceHolder = '<SubQrueries>',
@FiltersPlaceHolder = '<Filters>',
@Qry = 'select PPA_ID,RepInx,AssembleCode,Counter,PartCode,QcInsC ode,OperatorID' + @SubQueriesPlaceHolder + char(13) + ' from [QC-TempTable] A where RepInx in (' + @FiltersPlaceHolder + ')',
@SubQueries = ''
select @SubQueries += CHAR(13) + ',(SELECT max(PPA_PropertyValue) from [QC-ProcessPropertiesPerAssemble] where PPA_PropertyTitle = ''' + PPA_PropertyTitle + ''') as [' + PPA_PropertyTitle + ']'
from [QC-ProcessPropertiesPerAssemble] WHERE PPA_ProjID=@ProjID AND PPA_ProcID=@ProcID
GROUP BY PPA_PropertyTitle
set @Qry = REPLACE(@Qry, @SubQueriesPlaceHolder, @SubQueries)
set @Qry = REPLACE(@Qry, @FiltersPlaceHolder, @Filters)
exec(@Qry)