Even though BOL lists it as an aggregation function, I'd argue that GROUPING_ID doesn't aggregate anything. Rather, it gives an indication if a row contains aggregated values or not.

Why does your replacement text have <a href ... twice?

What is the value of @Name when you get the incorrect output?

Sean Lange (11/18/2014)

---

For what it is worth, you should consider using a numeric datatype instead of float. It appears this is dealing with money and float is not an exact...

super48 (11/18/2014)

---

while adding the Data sets ,

In field Option we get add query field and calculated filed.

I figured out how to add calculated field but

how to right in...

XML is case sensitive, so it can't match the attribute you are searching for.

try:

SELECT

x.item.value('@CLM_ID[1]', 'NVARCHAR(max)') AS CODE

FROM @x.nodes('//INPUT/HEADER') AS x(item)

please post the query you have at the moment so we can see if there are opportunities for improvement

you want:

SELECT

x.item.value('@clm_id[1]', 'NVARCHAR(max)') AS CODE

FROM @x.nodes('//INPUT/HEADER') AS x(item)

since you called the nodes column 'item'

put in some breakpoints and examine the variables used to set up the file names just before the failing operation executes. That should give you clues.

cphite (11/14/2014)

---

Ed Wagner (11/14/2014)

---

GilaMonster (11/14/2014)

---

Jason-299789 (11/14/2014)

---

Gail/Lynn/Ed,

I don't disagree, and as Lynn states maybe if MS enforced it so that code wouldn't compile without the use of the statement terminators, like...

I may have missed something, but the only difference I can see in the IF...ELSE... clauses is this (in the else clause)

AND EnumKey != 'ClosingEntry' AND EnumKey != 'ClosingEntryRevision'

That's a...

nodes(), value()

Gazareth (11/14/2014)

---

GilaMonster (11/14/2014)

---

Luis Cazares (11/13/2014)

---

g.britton (11/13/2014)

---

SeanNerd (11/13/2014)

---

My question is about indexing strategy for the following scenario:

I have a table where we cannot use the typical int identity primary key column....

DECLARE @t TABLE(Race char(1), AgeRange char(5), Amount int)

INSERT INTO @t (Race, AgeRange, Amount) values

('W','17-20',5000),

('W','21-30',4000),

('W','31-40',2000),

('A','17-20',1000),

('H','41-50',2500),

('H','51-60',2900)

select Race,

isnull("17-20",0),

isnull("21-30",0),

isnull("31-40",0),

isnull("41-50",0),

isnull("51-60",0)

from @t t

pivot (max(Amount) for AgeRange in ("17-20", "21-30", "31-40", "41-50",...

Add expressions to each task that disable the tasks based on the time

SeanNerd (11/13/2014)

---

My question is about indexing strategy for the following scenario:

I have a table where we cannot use the typical int identity primary key column. The table can have millions...