Viewing 15 posts - 4,141 through 4,155 (of 5,504 total)
Paul White (2/28/2010)
lmu92 (2/28/2010)
Unless you are processing huge XML data sets, I really don't think it matters too much. If you were processing huge sets of XML data...
March 1, 2010 at 3:51 am
Did you try to wrap your code into TRY ... CATCH blocks?
That would give you the option to control the "behavior" of a proc.
If you want to control more than...
February 28, 2010 at 4:46 pm
Here's my interpretation of the numbers:
Query 1:
There really seems to be no big difference. Run it with a larger data set to see which query scales better. You could also...
February 28, 2010 at 11:14 am
Do you know the structure of your XML file?
If so, can you post some sample data to describe the structure?
February 28, 2010 at 9:57 am
RBarryYoung (2/28/2010)
What I did notice though is that adding the text function ("(.../text())[1]") really seems to help the optimizer to produce a much more efficient XML query (I actually learned...
February 28, 2010 at 9:39 am
Paul White (2/28/2010)
lmu92 (2/28/2010)
...Really? I did run both last night, and both took zero milliseconds :doze:
Are you comparing estimated costs?
You're right in terms of execution time. But when...
February 28, 2010 at 5:25 am
Paul White (2/27/2010)
...In the real world, I'd probably use your one, though there's not much to choose between the first two, so it's possibly just a question of style.
...
Paul
I compared...
February 28, 2010 at 3:22 am
A similar approach to Pauls VIEW concept, but a different way to query the results:
You could insert the result set of your CTE (which would become a normal SELECT statement)...
February 28, 2010 at 3:10 am
tabrez.test (2/27/2010)
i want...
February 28, 2010 at 2:59 am
PhilM99 (2/27/2010)
Yes, that was an error I made during construction of the sample for posting. Sorry!But it led to a useful learning exercise!
Phil
Great you look at it that way!!
And nothing...
February 27, 2010 at 5:24 pm
PhilM99 (2/27/2010)
February 27, 2010 at 4:43 pm
I haven't seen a scenario where the MAX() function on character values did not work.
Would you mind posting some of the data that will fail in your scenario?
Based on the...
February 27, 2010 at 2:42 pm
bitbucket-25253 (2/27/2010)
Din not see lmu92's solution before posting mine .. lmu sorry about that ...
Nothing to be sorry for!
If it's any different than mine you should keep it posted. Two...
February 27, 2010 at 12:00 pm
If number of columns and data type would be identical for table 1 and table2 I guess Pauls approach would be the way to go.
But that doesn't seem to be...
February 27, 2010 at 11:56 am
I would use a self join on a numbered CTE.
I don't know how you determine the row that's "immediate next" so I assumed a id column. The reason why I...
February 27, 2010 at 11:36 am
Viewing 15 posts - 4,141 through 4,155 (of 5,504 total)