|
|
Posted by David Portas on 08/16/06 17:15
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.
>
> Thanks again!
>
I don't know if you still have a question or not. Your revised code
works for me.
As regards test questions. I do sometimes ask one question about
cursors when I give interviews. But the only answer I'm really looking
for is that the interviewee rarely uses them.
Quote:
> This is one of the most classic elementary programs you write.
> Read the data, print it, end.
In SQL? Absolutely not! You just failed the interview I'm afraid :-)
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Navigation:
[Reply to this message]
|