need help on query
-
Hi all,
need help on below requirement.
Thanks,
Abhas
-
Is this some kind of guessing game contest ?
-
What have you tried so far?
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.How to post questions to get better answers faster
Managing Transaction Logs -
Maybe Jeffrey was too subtle...
You really need to read this article:
Forum Etiquette: How to post data/code on a forum to get the best help
I'd post my attempt, but I want to see if the OP has tried anything yet.
-
Heh... keeping with the spirit of the question... 😉
Results;
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions - Jeff Moden wrote:
Heh... keeping with the spirit of the question... 😉
Results;
-
So I have a new interview question. 😀
Given the following output:
And the following code that produced the output:
Write the code to create and populate the test table.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions -
This was removed by the editor as SPAM
-
This was removed by the editor as SPAM
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply