Viewing 15 posts - 2,716 through 2,730 (of 4,080 total)
I just want to say again that your solution was really pretty Jeff. Mine was also based on a ctes using row_number(), but yours was much...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 24, 2009 at 7:57 am
I wasn't going to bring that up, because, despite the name, I don't consider extended stored procedures to be stored procedures in the sense the author of the question meant....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 24, 2009 at 7:55 am
If they won't link back, then go with the parameter passing option in my last post. We can discuss that more if you need to. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 24, 2009 at 7:51 am
Orson Scott Card (Ender's Game) is a great read for kids. Follow it up immediately with Ender's Shadow and then have a very interesting conversation with your...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 23, 2009 at 3:53 pm
Also consider "The Jungle Book". Most of the stories aren't for the faint of heart. (Disney got it all wrong.) But it was one of the first...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 23, 2009 at 3:01 pm
Also, just in case you are tempted to explain why it HAS to be a function and not a stored proc. Please, don't bother. I have had a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 23, 2009 at 10:36 am
Functions can't call stored procedures. Sorry, but you have to re-think what you want to do.
You can write a stored procedure that uses a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 23, 2009 at 10:28 am
Works fine, fails "safe", and drains to the bilge... [Hehe] Nasty fast to boot.
Same principle, but much quicker than my solution for sure. Nice clean piece of...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 23, 2009 at 9:56 am
An alternative to the view/table scheme above would be to pass the list as a parameter to the proc on SystemB. This might be necessary if you couldn't...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 22, 2009 at 2:42 pm
In our setup, both systems are linked servers with respect to each other. I created a view (could just as easily be a table) on the calling system....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 22, 2009 at 2:13 pm
I'd still prefer you ask them to try and solve it, or post some work.
No problem, Steve. I like that plan. I'm excited to be...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 22, 2009 at 12:56 pm
Hey Lynn,
I'm about to head out to lunch. I sent you and Matt the solution though.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 22, 2009 at 11:08 am
If you're going to tell them they're not posting right then it would be a good idea if you could give them the link to the information about the right...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 22, 2009 at 11:04 am
Matt and Lynn,
I'll go ahead and send you my solution, so you can double-check me. I did it with CTEs and freely admit there is probably a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 22, 2009 at 10:51 am
seems a tad mean
Yeah I know, but it took me literally under 1 minute to convert his table2 post into real code that I could work with. The arrogance...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 22, 2009 at 10:00 am
Viewing 15 posts - 2,716 through 2,730 (of 4,080 total)