-- set up sample data (this will be your job next time)

declare @sample table (string varchar(40))

insert into @sample

select 'Apples' union all

select 'Bananas' union all

select 'Coconuts' union all

select 'Paradimethylaminobenzaldehyde'

-- view...

Trudye, since you are obviously a beginner, I will help you out a little on this one. BB is absolutely right, though. If you...

That would be SIX of one, half a dozen of the other. 😉

Is it just me, or are we starting to get a lot of "homework" questions again? I've seen several lately that seemed to be absolutely basic,...

Thanks for...

Where row_number() ceases to be the most efficient technique depends on a number of variables, like the row size being retrieved and the existence of index. The...

I thought this was a good question because I've run across a number of people who didn't realize it was possible, but the example troubles me. It just...

For low volume queries, you can also use a cte with ROWNUMBER() using both partition and order by, then testing for where rownumber = 1.

Look up the syntax for ROWNUMBER()...

AllRIGHT! Extra effort paid off. I just got approval to go to PASS. 😀 😀 😀

Have you tried looking this up? Or even taking a guess? It's really terribly awfully simple.

I'm guessing this is part of a...

I can't stop either, Barry. It's a sickness, I tell you. :w00t:

Maybe we should form...

Fine article, Lynn, and another rocking discussion, everyone.

I'm cussing now because work is taking away from my reading time in here.

Spend enough cache and you can buy a better query plan?

(Sorry, Emperor Paulpatine. I just couldn't resist.)

In the NFL all my ties are to the Giants, but they didn't look that great on offense last night. To me, the Cowboys beat them everywhere...

People

Eating

Tasty

Animals