Your application (whatever the language written in) can call up the stored proc.

In general, I found that downloading all relevant records to the application to let the application crunch them...

"

much simpler than any of that...

Notice the cell coordinates right next to "Sheet1$" ? The "a4" identifies the left corner of the header row... the "c" identifies the...

"There's no reason to use goto" ...

I beg to differ.

I do have a use for GOTO -- provided DISCIPLINE is used to keep it readable.

Since this is forum on SQL...

About return values:

I usually comment my code by breaking it down in sections (and subsections), which I number sequentially. And form each section number, I will use a return value...

"COMEFROM"

YES !! My all-time favourite !

Is this public flaming really necessary ?

I, for one, have found several of Jeff's articles really useful.

Let's keep the tone of this forum civil. I can do without the...

The advice I received specifically concerned SQL Server 7, by someone who specialized in using PowerBuilder. The theory was that it was more efficient to refer, in the join, to...

If you intend to loop on something, then write what you mean and mean what you write.

WHILE immediately indicates a loop, whereas a GOTO would have to be checked for...

1 lakh = [font="Courier New"]10 exp 5[/font]

1 crore = [font="Courier New"]10 exp 7[/font]

so, 4 lakh is 400,000.

The first statement is very close to what SQL Server generates when you script a procedure, except that the last condition in the WHERE clause is

[font="Courier New"] and OBJECTPROPERTY(id,...

Ignore this posting, I am just subscribing to this thread. If anyone knows how to subscribe without making a dummy post, let me know. Regards

I hope I did not leave the impression that you saw it as a good idea. I just pointed out it is not a flaw that it does not work,...

I am not certain this can really be called a flaw.

SELECT DISTINCT ntext

would mean for each record in the query, go get the text stored at pointer of ntext and...

This is not an error message. SS2K is simply telling you that it ignore NULL values when performing an aggregate operation on records.

Such as

5, NULL, 7

SUM will produce the result...

About orphaned headers.

My trick is to first use a GROUP a band that is high enough to contain not only the header but also ONE record. That band has the...