Most probably the file is different than the sample file Flo used in his example due to the lack of any further information... Change 'C:\test.xml' to the real file destination.

Also,...

How many days does a year have in your scenario?

same question for month...

Your example could also result in 1 year 0 month 30 days (assuming a year with February 29th)...

Seems like the insert statement doesn't reflect your situation (I'd assume [SHP_ZIP] to have NULL values...).

In that case, (to complete Daves hint):

SELECT

[ORD_NBR],

[1ST_NME],

[LST_NME] ,

ISNULL([SHP_ZIP],[BILL_ZIP]) AS zipcode...

What is the reason to send one xml node at a time?

Wouldn't it be easier to convert all rows per batch into one xml variable (matching the node structure, of...

Did you check that the linked server is available at all?

(e.g. by test the connection using right click on the linked server in SSMS?)

Btw: Seems like the question wasn't that...

Button (im)pressed. Nice one, Jeff!

I thought there was an easy solution out there...

Glad I could help.

Well, that would turn the "old fashioned" DOS command option into a "retrofit version" 🙂 But the basic concept would be the same...

So, if your company would accept it I...

AFAIK there is no "easy" way of appending to an existing file.

I remember a few options being discussed a while ago (but I can't find the thread...):

a) load the content...

Would something along those lines do it?

DECLARE @t table(Type char(3),Cnt int, Date datetime)

INSERT INTO @t values('Foo' ,206, '11/04/2009')

INSERT INTO @t values('Foo' ,509, '11/05/2009')

SELECT

t1.type,

t1.date,

t1.Cnt,

t2.cnt as CntYesterday,

t1.cnt-t2.cnt as Diff...

marty.seed (11/5/2009)

---

...If a week has wed-sat falling in the next month it is considered a new week, new month.

The business rule for defining a Fiscal Month is as you have...

You're very welcome!

Actually, I felt like I had to do some "charity work" since I had a real bad day a work...

But now I'm feeling better! Thank you for your...

What is the business rule for the beginning of a new fiscal year (always first Sunday of December?)

What is the business rule for defining a fiscal month? Is it based...

Hi,

it took me a while so set up a step by step "tutorial" on how to convert a static cross tab into a dynamic cross tab using your sample data...

Would you mind sharing some sample data together with your expected result?

Please see the first link in my signature on how to post sample data.

There are several ways to do...