Viewing 15 posts - 436 through 450 (of 852 total)
[font="Verdana"]Following this with interest. GSquared, did you test your answer? I tried it, but it dropped off the first line for me.
BTW, I am wondering why you need...
March 17, 2009 at 3:23 pm
Chris Morris (3/17/2009)
It was supposed to be a CROSS JOIN but it didn't look right in the same sentence as beer:-P
[font="Verdana"]Yeah, I got that. 😀
I did wonder whether you...
March 17, 2009 at 2:59 pm
[font="Verdana"]Happy join? :w00t:
I miss Oracle's natural join. "Just join the two tables, dammit! I've already told you what the foreign key relationship is..."
[/font]
March 17, 2009 at 2:44 pm
Lynn Pettis (3/17/2009)
Over all, it was a good game, and I enjoyed watching her and her team from the best seat in the house, the pitch.
[font="Verdana"]It sounds like a great...
March 17, 2009 at 2:31 pm
[font="Verdana"]Welcome. It's a good script, and modifying it was easy. 🙂
I used to do this on SQL Server 2000, just by selecting from sysindexes with a script like...
March 17, 2009 at 2:10 pm
GSquared (3/17/2009)
(Free association error: Connection between Pern books and SQL Server being established ... reconciliation impossible ......
March 17, 2009 at 2:01 pm
[font="Verdana"]Zzzzz... mumble mumble... Lynn... Soccer... mumble mumble... zzzzz[/font]
March 17, 2009 at 1:55 pm
[font="Verdana"]...and thus was born the son of thread. Oh, wait: we need three wise people. Who is up for a camel ride?[/font]
March 16, 2009 at 9:55 pm
[font="Verdana"]I guess I must be slow. What are you wanting your stored procedure to actually do?[/font]
March 16, 2009 at 7:56 pm
[font="Verdana"]The subqueries where a bit complicated for my liking, so I took your code and pulled out the subqueries into CTEs. Also, I have had indexes turn up with...
March 16, 2009 at 4:56 pm
[font="Verdana"]Wine tours of NZ and Australia? Been there, done that. 😀 Well, I have one more area (Melbourne) left to do in Australia.[/font]
March 16, 2009 at 4:25 pm
[font="Verdana"]No, we've moved on from amusement parks to litigation. Although we might take a sudden side turn for wine tours.
Didn't you bring your map?
[/font]
March 16, 2009 at 3:52 pm
[font="Verdana"]I was hoping to sue for a sudden outbreak of acne to recoup some of my costs. That waiver has just foiled my evil plan. :crazy:[/font]
March 16, 2009 at 3:39 pm
[font="Verdana"]Look up the STUFF() function in SQL Server Books Online.[/font]
March 16, 2009 at 3:07 pm
Lynn Pettis (3/16/2009)
March 16, 2009 at 2:42 pm
Viewing 15 posts - 436 through 450 (of 852 total)