Database

Tridip Bhattacharjee wrote:

how to query address field in my xml or how to query Options field,how query CompanyOrName.

DECLARE @ShipXML XML
    SET @ShipXML = 
	'<OpenShipments>
		<OpenShipment>
			<NumberOfPackages>1</NumberOfPackages>
			<ShipmentActualWeight>5</ShipmentActualWeight>
			<DescriptionOfGoods>Car Parts</DescriptionOfGoods>
		</OpenShipment>
		<OpenShipment>
			<NumberOfPackages>2</NumberOfPackages>
			<ShipmentActualWeight>3</ShipmentActualWeight>
			<DescriptionOfGoods>Bike Parts</DescriptionOfGoods>
		</OpenShipment>
	</OpenShipments>'

SELECT shs.sh.value('NumberOfPackages[1]','bigint') AS NumberOfPackages
      ,shs.sh.value('ShipmentActualWeight[1]','bigint') AS ShipmentActualWeight
      ,shs.sh.value('DescriptionOfGoods[1]','varchar(20)') AS DescriptionOfGoods
  FROM @ShipXML.nodes('OpenShipments/OpenShipment') shs(sh)
 WHERE shs.sh.exist('.[DescriptionOfGoods != "Car Parts"]') = 1

I are Troll

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