Database

fracalifa wrote:

Hi all,

is there a way to restrict the form.showdialog method to the calling parent-window and not to the whole app ?

thank you !
frank

SELECT DESCR,ACTV,[CYCLETEMPLATE] = STUFF((SELECT ',' + CAST(CYCLETEMPLATE AS VARCHAR(MAX))
				    FROM #temp
					WHERE DESCR = t.DESCR
					AND ACTV = t.ACTV 
					FOR XML PATH('')),1,1,'') 
into #TempSummary   FROM #temp t
GROUP BY DESCR,ACTV

ALTER FUNCTION [dbo].[GetSortedString]
(
 @inputString varchar(max)
)
RETURNS varchar(max)
AS
BEGIN
 
if dbo.IsStringNumeric( @inputString) = 1
 begin
  return dbo.GetSortedStringNumeric( @inputString)
 end

return @inputString --dbo.GetSortedStringNormal(@inputString)

END

ALTER  FUNCTION [dbo].[GetSortedStringNumeric]
(
 @inputString varchar(max)
)
RETURNS varchar(max)
AS
BEGIN
 
declare @outputString varchar(max)
set @outputString = ''
select @outputString = ltrim(rtrim(str(item))) + ','  + @outputString  from dbo.fnSplit(@inputString,',') order by item desc
 declare @Results int 
 set @Results = (select dbo.IsMatching(@outputString,'[A-Z ]'))

if  SUBSTRING(@outputString,len(@outputString),1) = ',' AND @Results = 0
 begin
  set @outputString = SUBSTRING(@outputString,1,len(@outputString)-1) 
 end
else if SUBSTRING(@outputString,len(@outputString),1) = ',' AND @Results > 1
begin
return @outputString 
end
return @outputString

END

SELECT DESCR, dbo.GetSortedString(Cast(NULL AS varchar(8000))) AS CycleIdList,ACTV
INTO #TempSummary
FROM temp (NOLOCK)
GROUP BY DESCR,ACTV
ORDER BY DESCR,ACTV

SELECT DESCR,ACTV,
[CYCLETEMPLATE] = STUFF((SELECT ',' + CAST(CYCLETEMPLATE AS VARCHAR(MAX))
FROM #temp
WHERE DESCR = t.DESCR
 AND ACTV = t.ACTV Order by CYCLETEMPLATE 
FOR XML PATH('')),1,1,'')
into #TempSummary FROM #temp t
GROUP BY DESCR,ACTV

Vuyiswa Maseko wrote:

STUFF((SELECT ',' + CAST(CYCLETEMPLATE AS VARCHAR(MAX))