krishusavalia (2/3/2011)

---

I appriciate your response. And you solution was awesome. Thats what i was looking for.

And I Appriciate you suggetion that I have to reevaluate the table structure but In...

That's weird. What is the result of the following statement? It should point to Monday of the current week.

SELECT DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()), 0)

SELECT DATEADD(WEEK, DATEDIFF(WEEK, '19000101', GETDATE()), '19000101')

If both...

You'd need to add the MoreProperties/Property node e.g. by using another CROSS APPLY.

If you really need to store it in the table structure as provided, you'd need to CrossTab (or...

The issue is rather simple:

Replace

where a.ParentID=n.value('@ParentID[1]','int') with

where a.ParentID=n.value('ParentID[1]','int')

ParentID is an element, but you've referenced it as an attribute.

Please don't cross post.

Original post can be found here.

No replies on this thread, please.

I think you've been around long enoug to know how it works...

Table DDL, sample data and expected results, please.

And your question is?

I'm sure this link will help you.

It looks like you'Re not using XQuery that often.. So, here's a link to a great site providing a lot of examples about how to query XML data. Give it...

What have you tried so far and where did you get stuck?

After some sample data cleanup (there's an invalid end tag in your sample) the following code did work.

The "trick" is to declare all namespaces used in your query. In the...

Please provide table DDL and ready to use sample data as described in the first link in my signature. Also, please provide your expected output based on your sample data....

Probably the easiest way to deal with fiscal years not following the calendar year would be using a calendar table where you'd add the FY information per day.

You could also...

Did you try to call the function including the schema?

E.g....

@pravasis:

It seems like this function can be eliminated and the lookup could be used directly...