Viewing 15 posts - 1,981 through 1,995 (of 5,502 total)
krishusavalia (2/3/2011)
And I Appriciate you suggetion that I have to reevaluate the table structure but In...
February 3, 2011 at 1:20 pm
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...
February 3, 2011 at 12:11 pm
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...
February 2, 2011 at 4:25 pm
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.
February 2, 2011 at 1:29 pm
January 30, 2011 at 2:19 pm
I think you've been around long enoug to know how it works...
Table DDL, sample data and expected results, please.
January 30, 2011 at 2:55 am
I'm sure this link will help you.
January 29, 2011 at 4:26 pm
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...
January 28, 2011 at 1:16 pm
What have you tried so far and where did you get stuck?
January 28, 2011 at 12:54 pm
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...
January 28, 2011 at 11:33 am
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....
January 28, 2011 at 11:15 am
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...
January 27, 2011 at 4:23 pm
L09041975 (1/27/2011)
set @MyVariable = MyFunction(@MyParameter) andselect @MyVariable = MyFunction(@MyParameter) gave the following error:
'MyFunction' is not a recognized built-in function name.
Did you try to call the function including the schema?
E.g....
January 27, 2011 at 4:15 pm
1) The function is a UDF. It basically pull the ids based in the values provided.
It seems like this function can be eliminated and the lookup could be used directly...
January 27, 2011 at 12:18 pm
Viewing 15 posts - 1,981 through 1,995 (of 5,502 total)