Viewing 15 posts - 976 through 990 (of 7,631 total)
CirquedeSQLeil (2/16/2010)
RBarryYoung (2/16/2010)
(if that doesn't make sense, then note closely the dates & times in the thread above,...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 16, 2010 at 1:56 pm
RBarryYoung (2/16/2010)
mick L (2/16/2010)
I posted on msdn and got this solutionhttp://social.msdn.microsoft.com/Forums/en/sqlxml/thread/38016fd9-4a7d-48d5-850b-dc01e370f3af
Sooo... Five hours after I worked to produce a completely correct and valid answer to your question (and in...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 16, 2010 at 1:50 pm
Chad Crawford (2/16/2010)
RBarryYoung (2/16/2010)
(if that doesn't make sense, then note closely the dates & times in the...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 16, 2010 at 1:47 pm
michael.morse (2/16/2010)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 16, 2010 at 1:35 pm
Just knowing that I am helping someone is what makes it all worthwhile.
(if that doesn't make sense, then note closely the dates & times in the thread above, and at...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 16, 2010 at 1:08 pm
mick L (2/16/2010)
I posted on msdn and got this solutionhttp://social.msdn.microsoft.com/Forums/en/sqlxml/thread/38016fd9-4a7d-48d5-850b-dc01e370f3af
Sooo... Five hours after I worked to produce a completely correct and valid answer to your question (and in less...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 16, 2010 at 12:48 pm
C# Screw (2/16/2010)
(Hi Barry I am wondering what is C4?)
C4 is a plastic explosive with a particularly high "burn rate" or (more properly) detonation velocity of 28,900 kph.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 16, 2010 at 11:34 am
In fact, for the longer-strings, an abbreviated Boyer-Moore Search and Replace (or an unabbreviated one for really big strings) should be freaky fast.
(edit: fixed spelling)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 16, 2010 at 10:40 am
Hmm, this all seems like the kind of thing that a CLR UDF should burn through like C4.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 16, 2010 at 10:34 am
And just to warn you ahead of time: If you are looking to write this as a T-SQL Function, be aware that they do not allow dynamic SQL. ...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 16, 2010 at 10:18 am
mick L (2/16/2010)
Thanks for this solution. This works fine against tables. How would I go about this if each set of elements were created from a SQL statement involving joins?
I...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 16, 2010 at 10:11 am
john-902052 (2/15/2010)
No, Part 2 has 3 absences but they are not consecutive.
What constitutes "consecutive"? There are no other intervening fees.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 15, 2010 at 6:29 pm
john-902052 (2/15/2010)
...PartID = 1 should get a termination record
PartID = 2 should not
I don't understand this. PartID 1 has 4 absences in a row and PartID has 3 in...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 15, 2010 at 5:43 pm
Well, it's certainly obtuse, but this is one way to do it:
SELECT (
Select CAST(C AS XML)
FROM (
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 15, 2010 at 10:45 am
Hmm, I'm not sure that there is a good way to do this.
It sounds like someone wants an "XML Cursor" and there really isn't such a thing in T-SQL. An...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 15, 2010 at 10:11 am
Viewing 15 posts - 976 through 990 (of 7,631 total)