Viewing 15 posts - 841 through 855 (of 2,038 total)
Could you please explain more detailed. Your statement seems to be syntactical correct.
Please provide the table DDL, some sample data and the required result for the sample data.
Have a look...
May 21, 2009 at 12:16 pm
Hi Bruce
I'm still quiet unsure if I got you but let's give it a try (works only with temp tables)...
As I understood the returned columns shall depend on the resulting...
May 21, 2009 at 12:13 pm
So let's start with the "any questions" :hehe:
1.)
What do you mean with "create a process"? A procedure? A .Net app? A web-app? PHP? Cobol?
2.)
I don't really understand your data1-data5 bits....
May 21, 2009 at 11:49 am
Grant Fritchey (5/21/2009)
GilaMonster (5/21/2009)
Lynn Pettis (5/21/2009)
Are we talking about our window washer friend here?
No. It's someone who answers questions, not asks. (no one here, obviously)
Steve: Apologies in advance...
May 21, 2009 at 11:38 am
You write the XML comes from a web-service. So there must be any application which takes the XML. Why don't use this application for the transformation?
However, if you have to...
May 21, 2009 at 10:22 am
Lynn Pettis (5/21/2009)
May 21, 2009 at 9:31 am
Lynn Pettis (5/21/2009)
Alvin Ramard (5/21/2009)
GilaMonster (5/21/2009)
Oh yay. 🙁Another email accusing me of personal attacks and damaging someone's public image by 'misleading' people about his statements.
Sometimes I wonder why I bother.....
Lynn,...
May 21, 2009 at 9:06 am
GilaMonster (5/21/2009)
Florian Reischl (5/21/2009)
May 21, 2009 at 9:04 am
GilaMonster (5/21/2009)
For some info on scalar functions, including the difficulting in seeing how they performhttp://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/
Gail, generally you are correct. But there is a huge difference between Pieters scalar function and...
May 21, 2009 at 8:53 am
Hi Pieter
Pieter (5/21/2009)
First of all, thanks every one for your help so far. Its clear that I need to learn a few more things about performance of functions.
Always welcome. Those...
May 21, 2009 at 8:22 am
Since you didn't answer my question for C# or VB.Net I use C# because this is my preference 😀
Ensure that you use "Release" compiled assembly. The "Debug" build is about...
May 21, 2009 at 8:15 am
J-F Bergeron (5/21/2009)
Florian Reischl (5/20/2009)
@J-F:I stopped your function at two minutes.
Greets
Flo
Ouch... And I thought it would perform better... Do you have the exec plan Flo, just for reference.
Thanks,
I just tried...
May 21, 2009 at 8:05 am
Hi Pieter
I just tried some CLR stuff with 1 million rows.
Currently your function takes 17s
CLR takes 7s
I think this can be faster. Give me a little bit more time.
Questions:
1.)
Are you...
May 20, 2009 at 4:08 pm
Errors? I just copy/pasted into an empty query window and executed. I don't get any errors.
Err, I think I know what you need...
You probably don't have a Tally table. Execute...
May 20, 2009 at 2:53 pm
Hi Tim
I didn't notice that this was the "Newbie" forum...
If you have any questions, feel free to come back here!
Greets
Flo
May 20, 2009 at 2:39 pm
Viewing 15 posts - 841 through 855 (of 2,038 total)