GilaMonster (6/6/2013)

---

What do you mean, the database is empty? Someone ran a script dropping all tables?

Production server or local test DB?

Without a backup, there's no way to restore a database...

Sean Lange (2/27/2013)

---

asco5 (2/26/2013)

---

hi thanks for your reply

this is a example of what i want to do

as you see i have my data base and i have my...

Sean Lange (2/25/2013)

---

asco5 (2/25/2013)

---

Hi exactly

In fact instead of going...

Hi exactly

In fact instead of going to sql management...

Sean Lange (2/8/2013)

---

asco5 (2/8/2013)

---

thanks for the code its seem to works i just need to test it in a bigger database with more entry

i want to ask if i have...

thanks for the code its seem to works i just need to test it in a bigger database with more entry

i want to ask if i have a lots of...

hi i don't want to insert

i just need to know in my table

who are the id that have the most record depending on their ID and date.

each id is nunique...

i still have the same error message

this is what i wrote:

select top 100 id, personid,name, firstname,

count (*) mycount

from [database].

.

group by id, personid,name, firstname

order by mycount;

and i have the same...

still not working

still same probleme not working same error

hi i tried first one

select top 100 cause i need only the 100 first people who have the most entry

so i did

select top 100 ID,

count (*)

from [database].

.

group by id

order...