Reputation
6,713
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 8 21
Impact
~477k people reached

Apr
20
awarded  sql-server-2008-r2
Apr
4
awarded  Good Answer
Apr
4
awarded  Populist
Feb
24
awarded  Yearling
Jan
15
awarded  Scholar
Jan
15
comment How to cast a list of values within xquery in SQL Server?
Thanks. Great solution.
Jan
15
accepted How to cast a list of values within xquery in SQL Server?
Jan
15
comment How to cast a list of values within xquery in SQL Server?
@Mr.Brownstone, in the current setting I do not have control over the schema. So, I cannot change it.
Jan
15
comment How to cast a list of values within xquery in SQL Server?
@Mr.Brownstone, thanks for the ?. That makes a lot of sense. See also: w3.org/TR/xpath-30/#prod-xpath30-OccurrenceIndicator
Jan
15
asked How to cast a list of values within xquery in SQL Server?
Oct
19
awarded  Enlightened
Oct
19
awarded  Nice Answer
Oct
10
awarded  Popular Question
Feb
24
awarded  Yearling
Dec
2
comment How can I create notification on user's connecting to database?
Do you have a backup of msdb from before the "cleaning"?
Sep
30
awarded  Explainer
Sep
29
revised How to get more information from dm_exec_query_stats
added 259 characters in body
Sep
29
answered How to get more information from dm_exec_query_stats
Sep
24
awarded  Autobiographer
Jun
9
comment Create a result for a line chart with dates
The risk on 2/21 is not 26. Instead it is unknown. Therefore you should not plot a 26 either. Just plot the dates that the measurements were taken on and leave gaps for the other days.