Sounds like either the group by function (like Lutz mentioned), or the use of the windows ranking functions will do the job. And, like Lutz mentioned, we need more information...

Whilst I won't pretend that I know your system better than you, might I suggest you change the way that you are doing this?

If you put your varchar values into...

And yet you still bothered to double-post.

Try this out.

-- Notice how I built a table and populated it with your test data?

-- this makes it MUCH easier for people to help you out

-- all...

Then it looks like you need to provide better details and sample data. See the link in my signature...

I have seen instances where the application (in this case, Enterprise Manager) appears to be frozen, especially after cancelling an operation. However, it's not; it's just that the screens didn't...

duplicate post. post replies here

duplicate post. Post replies here

It sounds like you installed SQL Server using an account that does not have network permissions. You need to change the logon account for the services to one that does....

SQL_Quest (6/24/2009)

---

BUt when the data is inserted using the application, there where the problem comes.

Note: If the trigger is disabled, then the data gets loaded perfectly OK.

Can any one please...

skailey (6/24/2009)

---

Hi Lynn,

Thanks so much for the response. That did work, however, I was able to simplify this for my needs with what you gave me... they key being...

I tried your code out, then added this insert statement to test out the trigger.

It inserts about 2000 rows into your table, then selects everything.

insert into cnsmr_accnt

select CONVERT(varchar(5), 22 +...

Gianluca Sartori (6/23/2009)

---

LOL! What's your hourly fee, Wayne? I need to get the grass cut......

Gary Hines (6/23/2009)

---

Hi, I'm having a little problem writing a query against a table storing an XML data packet.

Background: We have a sales application that processes an XML packet sent...

sridevi_mahalingam (6/23/2009)

---

Is there any special way of inserting XML data into SQL server / DB2 native XML database using XQuery? If so let me know. I tried with CAST function....