Hi Sandy

You're missing the parentheses around the variable:

select top (@n) * from emp_detail

Cheers

ChrisM

Yes, that's pretty much it. As you can see, you can do a whole set at a time, no fiddling about with single rows.

What do you want to do with...

Jack Corbett (4/6/2009)

---

It's one of those, Jack, but the requirements are so ambiguous it's kinda hard to tell 🙂

Nah Jacek, the kitchen! Leffe brune, just the one...gonna stop now, keep bumping into Jack. Good luck, Jack 😎

jbuttery (4/6/2009)

---

I can't seem to figure how to insert new records into a database based on previous records. I want to read a record, increment or modify several columns and...

I reckon this is what you are looking for

DROP TABLE #Temp

CREATE TABLE #Temp (col1 CHAR(1), col2 CHAR(1), col3 CHAR(1), col4 CHAR(1), col5 CHAR(1))

INSERT INTO #Temp (col1, col2, col3, col4, col5)

SELECT...

As they say here "it...

Jack Corbett (4/6/2009)

---

No worries. I was just a little surprised you said that, and knew...

Jack Corbett (4/6/2009)

---

Chris Morris (4/6/2009)

---

Jack Corbett (4/6/2009)

---

One problem with your first query is that it includes the columns you want the MAX for in the GROUP BY so you get...

Jack Corbett (4/6/2009)

---

One problem with your first query is that it includes the columns you want the MAX for in the GROUP BY so you get all the rows. ...

Hey Bob, I'm still messing about with derivatives of this - have you got...

Nope. Bet he's busy with his nose...

If that was exactly as...

pedro.ribeiro (4/6/2009)

---

Hi,

Yap, there's other reason.

With the result of the select i will trie to produce a txt file (script) that as insert statements.

This script will be sent to other...

pandeharsh (4/6/2009)

---

SELECT Table1.code

FROM Table1, Table2

WHERE Table1.code not in(select code from Table2)

GROUP BY Table1.code;

I get the result,but i do not want to use group by or distinct clause.

Can I acheive...