|
|
Posted by Tracy McKibben on 08/16/06 17:38
dba_222@yahoo.com wrote:
> Thank you! That worked!
>
> One of the websites I looked at was:
> http://databases.about.com/od/sqlserver/l/aastoredprocs.htm
> But I can't find the other one with the loop. Now that I think of
> it, the print statement was my addition.
>
> Sorry if I'm rubbing anyone the wrong way. But I'm sure you tell, I
> was getting really pissed off here. I've been working in tech for a
> long time. I know that in the beginning, you have to get the basics
> down. Syntax. Variables. Built in functions and other features.
> Libraries. How to compile and link. How it's done in this language.
> Etc. I've done this with Oracle, C, VB, some java and so on.
>
> So, I do know what I am trying to do. And I do know that it is
> possible. I'm going to the newsgroups as a last resort after
> struggle. When this writer gets to that point, I just want the answer.
>
> Just how do I do it please? Not an intellectual discussion.
> Not questions or comments about what I'm trying to do.
> Consider it a test question where only the right answer gets
> you the marks.
So, what you're saying is that you already know your way is the best way
(even though you can't make it work), and aren't interested in hearing
alternatives to your approach. Not a bit arrogant, are we? I've been
writing T-SQL code for almost 10 years now, and I learn something new,
or am reminded of something I forgot, EVERY DAY from these newsgroups.
No matter how good you think you are, there's always somebody better out
there. As others have already pointed out to you, a cursor is rarely
the preferred tool to use in SQL, but you already knew that, right?
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Navigation:
[Reply to this message]
|