|
Home > Archive > MS SQL XML > July 2005 > Here is the query
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Craig HB 2005-07-28, 3:24 am |
| select -- DebitNote
1 as Tag,
null as Parent,
null as [DebitNote!1],
null as & #91;DebitNoteDocumen
tDetails!2],
null as & #91;DebitNoteDocumen
tDate!3],
null as & #91;DebitNoteDocumen
tNumber!4],
null as & #91;DocumentStatus!5
],
null as & #91;InvoiceReference
!6],
null as & #91;InvoiceDocumentN
umber!7],
null as & #91;OrderReference!8
], -- col 10
null as & #91;PurchaseOrderNum
ber!9],
null as [Buyer!10],
null as [BuyerGLN!11],
null as [Address!12],
null as & #91;BuildingIdentifi
er!13],
null as [PostCode!14],
null as [Seller!15],
null as [SellerGLN!16],
null as [Address!17],
null as & #91;BuildingIdentifi
er!18], -- col 20
null as [PostCode!19],
null as [ShipTo!20],
null as [ShipToGLN!21],
null as & #91;TaxPointDateTime
!22],
null as [DebitItem!23],
null as & #91;DebitItem!23!Cha
ngeReasonCoded],
null as & #91;LineItemNumber!2
4],
null as & #91;ItemIdentifier!2
5],
null as [GTIN!26],
null as & #91;InvoiceQuantity!
27], -- col 30
null as & #91;DebitQuantity!28
],
null as [UnitPrice!29],
null as & #91;LineItemPrice!30
],
null as & #91;LineItemDiscount
!31],
null as & #91;DiscountValue!32
],
null as & #91;DiscountRate!33]
,
null as [VATDetails!34],
null as & #91;TaxCategory!35],
null as [TaxRate!36],
null as & #91;CreditLineIndica
tor!37], -- col 40
null as & #91;DebitTotals!38],
null as & #91;DocumentDiscount
Rate!39],
null as & #91;SettlementDiscou
ntRate!40],
null as & #91;VATRateTotals!41
],
null as [VATDetails!42],
null as & #91;TaxCategory!43],
null as [TaxRate!44],
null as & #91;DiscountedLineTo
tals!45],
null as & #91;DocumentDiscount
Value!46],
null as & #91;SettlementDiscou
ntValue!47], -- col 50
null as & #91;TaxableAmount!48
],
null as [VATPayable!49],
null as & #91;SettlementSubTot
al!50],
null as & #91;DebitNoteSubTota
l!51],
null as [VATTotal!52],
null as & #91;SettlementDebitT
otal!53],
null as & #91;TotalPayable!54]
-- col 57
union select -- DebitNoteDocumentDet
ails
2,
1,
null, -- DebitNote
null, -- DebitNoteDocumentDet
ails
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null
union select -- DebitNoteDocumentDat
e
3,
2,
null, null,
DebitNoteDocumentDat
e,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- DebitNoteDocumentNum
ber
4,
2,
null, null, null,
DebitNoteDocumentNum
ber,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- DocumentStatus
5,
2,
null, null, null, null,
DocumentStatus,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- InvoiceReference
6,
1,
null, null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null
union select -- InvoiceDocumentNumbe
r
7,
6,
null, null, null, null, null, null,
InvoiceDocumentNumbe
r,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- OrderReference
8,
1,
null, null, null, null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null
union select -- PurchaseOrderNumber
9,
8,
null, null, null, null, null, null, null, null,
PurchaseOrderNumber,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null
from DebitNotes_XmlView(1
)
union select -- Buyer
10,
1,
null, null, null, null, null, null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null
union select -- BuyerGLN
11,
10,
null, null, null, null, null, null, null, null, null, null,
BuyerGLN,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null
from DebitNotes_XmlView(1
)
union select -- Address
12,
10,
null, null, null, null, null, null, null, null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null
union select -- BuyerBuildingIdentif
ier
13,
12,
null, null, null, null, null, null, null, null, null, null, null, null,
BuyerBuildingIdentif
ier,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- BuyerPostCode
14,
12,
null, null, null, null, null, null, null, null, null, null, null, null,
null,
BuyerPostCode,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- Seller
15,
1,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null
union select -- SellerGLN
16,
15,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null,
SellerGLN,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- Address
17,
15,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null
union select -- SellerBuildingIdenti
fier
18,
17,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null,
SellerBuildingIdenti
fier,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null
from DebitNotes_XmlView(1
)
union select -- SellerPostCode
19,
17,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null,
SellerPostCode,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null
from DebitNotes_XmlView(1
)
union select -- ShipTo
20,
1,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null
union select -- ShipToGLN
21,
20,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null,
ShipToGLN,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- TaxPointDateTime
22,
1,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
TaxPointDateTime,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- DebitItem
23,
1,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null,
null, '5',
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null
union select -- LineItemNumber
24,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null,
LineItemNumber,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- ItemIdentifier
25,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null
union select -- GTIN
26,
25,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null,
GTIN,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- InvoiceQuantity
27,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null,
InvoiceQuantity,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- DebitQuantity
28,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
DebitQuantity,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- UnitPrice
29,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null,
UnitPrice,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null
from DebitNotes_XmlView(1
)
union select -- LineItemPrice
30,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
LineItemPrice,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null
from DebitNotes_XmlView(1
)
union select -- LineItemDiscount
31,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null
union select -- DiscountValue
32,
31,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null,
DiscountValue,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null
from DebitNotes_XmlView(1
)
union select -- DiscountRate
33,
31,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
DiscountRate,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- VATDetails
34,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null,
null,
null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null
union select -- ItemTaxCategory
35,
34,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null,
ItemTaxCategory,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- ItemTaxRate
36,
34,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null,
ItemTaxRate,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- CreditLineIndicator
37,
23,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null,
CreditLineIndicator,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- DebitTotals
38,
1,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null
union select -- DocumentDiscountRate
39,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null,
DocumentDiscountRate
,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null
from DebitNotes_XmlView(1
)
union select -- SettlementDiscountRa
te
40,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
SettlementDiscountRa
te,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null
from DebitNotes_XmlView(1
)
union select -- VATRateTotals
41,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null,
null,
null, null, null, null, null, null, null, null, null, null, null, null, null
union select -- VATDetails
42,
41,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null,
null,
null, null, null, null, null, null, null, null, null, null, null, null
union select -- TotalsTaxCategory
43,
42,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null,
TotalsTaxCategory,
null, null, null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- TotalsTaxRate
44,
42,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null,
TotalsTaxRate,
null, null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- DiscountedLineTotals
45,
41,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null,
DiscountedLineTotals
,
null, null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- DocumentDiscountValu
e
46,
41,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null,
DocumentDiscountValu
e,
null, null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- SettlementDiscountVa
lue
47,
41,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
SettlementDiscountVa
lue,
null, null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- TaxableAmount
48,
41,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null,
TaxableAmount,
null, null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- VATPayable
49,
41,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
VATPayable,
null, null, null, null, null
from DebitNotes_XmlView(1
)
union select -- SettlementSubTotal
50,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null,
SettlementSubTotal ,
null, null, null, null
from DebitNotes_XmlView (1)
union select -- DebitNoteSubTotal
51,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null,
DebitNoteSubTotal,
null, null, null
from DebitNotes_XmlView(1
)
union select -- VATTotal
52,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
VATTotal,
null, null
from DebitNotes_XmlView(1
)
union select -- SettlementDebitTotal
53,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null,
SettlementDebitTotal
,
null
from DebitNotes_XmlView(1
)
union select -- TotalPayable
54,
38,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null,
TotalPayable
from DebitNotes_XmlView(1
)
order by tag
for xml explicit
| |
| markc600@hotmail.com 2005-07-28, 7:23 am |
| Looks like a SQL Server bug. If you explicitly use the element
directive for the last five columns, it appears to work,
i.e. change
& #91;SettlementSubTot
al!50] to & #91;SettlementSubTot
al!50!element]
BTW your ORDER BY clause is correct and required, also you may
want to use UNION ALL instead of UNION (more efficient).
| |
| Craig HB 2005-07-28, 7:23 am |
| Thanks for your reply.
If I do change change & #91;SettlementSubTot
al!50] to
& #91;SettlementSubTot
al!50!element] I get <SettlementSubTotal element="0.00" />
instead of <SettlementSubTotal>0.00</SettlementSubTotal>.
If I do put & #91;DebitTotals!38!S
ettlementSubTotal!el
ement] to say that
SettlementSubTotal is an element of DebitTotals, it will come after the
VATRateTotals element (that contains other sub-elements) --- and order is
important.
This is how the <DebitTotals> bit should look like...
<DebitTotals>
< DocumentDiscountRate
>0.00</ DocumentDiscountRate
>
< SettlementDiscountRa
te>0.00</ SettlementDiscountRa
te>
<VATRateTotals>
<VATDetails>
<TaxCategory>S</TaxCategory>
<TaxRate>17.50</TaxRate>
</VATDetails>
< DiscountedLineTotals
>0.00</ DiscountedLineTotals
>
< DocumentDiscountValu
e>0.00</ DocumentDiscountValu
e>
< SettlementDiscountVa
lue>0.00</ SettlementDiscountVa
lue>
<TaxableAmount>20.00</TaxableAmount>
<VATPayable>3.50</VATPayable>
</VATRateTotals>
<SettlementSubTotal>0.00</SettlementSubTotal>
<DebitNoteSubTotal>23.50</DebitNoteSubTotal>
<VATTotal>3.50</VATTotal>
< SettlementDebitTotal
>0.00</ SettlementDebitTotal
>
<TotalPayable>23.50</TotalPayable>
</DebitTotals>
Is there something I can do with ORDER BY ? I'm a bit stuck now.
| |
| markc600@hotmail.com 2005-07-28, 7:23 am |
| Apologies, typo
& #91;SettlementSubTot
al!50] to & #91;SettlementSubTot
al!50!!element=AD]
(two exclamation marks not one)
| |
| Craig HB 2005-07-28, 7:23 am |
| That's it ! Thanks for helping me. By the way, I have started using UNION ALL
instead of UNION
- Craig
| |
| Michael Rys [MSFT] 2005-07-29, 3:24 am |
| Please disregard my earlier posting asking for the repro.
using [name!1] had a bug that we fixed in at least SQL Server 2005, don't
remember at the moment whether it is fixed in SP4 as well. Please use
[name!1!] instead.
Best regards
Michael
"Craig HB" <CraigHB@discussions.microsoft.com> wrote in message
news:DA9542C4-1546-4814-BE5D- 54259729A4F8@microso
ft.com...
> That's it ! Thanks for helping me. By the way, I have started using UNION
> ALL
> instead of UNION
>
> - Craig
| |
| Eugene Kogan [MSFT] 2005-07-29, 3:24 am |
| Yes, it is fixed in SQL Server 2000 SP4. So, either install SP4 or use the
workaround Michael provided.
Regards,
Eugene
"Michael Rys [MSFT]" <mrys@online.microsoft.com> wrote in message
news:e1AW8F%23kFHA.320@TK2MSFTNGP09.phx.gbl...
> Please disregard my earlier posting asking for the repro.
>
> using [name!1] had a bug that we fixed in at least SQL Server 2005, don't
> remember at the moment whether it is fixed in SP4 as well. Please use
> [name!1!] instead.
>
> Best regards
> Michael
>
>
> "Craig HB" <CraigHB@discussions.microsoft.com> wrote in message
> news:DA9542C4-1546-4814-BE5D- 54259729A4F8@microso
ft.com...
>
>
|
|
|
|
|