how to use GROUP BY clause on VARCHAR variable?

Permander Malik · New User Joined: 24 Oct 2009 Posts: 11 Location: Mumbai

Hi All,

I want to use GROUP BY clause on VARCHAR variable. Can anyone please let me know how we can use that?

PeterHolland · Posted: Fri Dec 11, 2009 3:21 pm

www.db-staff.com/index.php/microsoft-sql-server/86-sql-group-by

Permander Malik · New User Joined: 24 Oct 2009 Posts: 11 Location: Mumbai

On the above link I did not find the same. Can anyone help me out.

enrico-sorichetti · Posted: Fri Dec 11, 2009 5:28 pm

I do not see any reaso from a conceptual point of view to treat
a varchar column differently from a <normal> column

what did You find to make You believe You need special processing?

Permander Malik · New User Joined: 24 Oct 2009 Posts: 11 Location: Mumbai

Its not returning any result for me in DB2 query. Any idea how we can get through ?

dbzTHEdinosauer · Posted: Fri Dec 11, 2009 5:35 pm

your second where clause condition is causing the no-result condition

bhairon singh rathore · New User Joined: 19 Jun 2008 Posts: 91 Location: banglore

Can you provide us with the query which you are working on

enrico-sorichetti · Posted: Fri Dec 11, 2009 5:43 pm

dbzTHEdinosauer · Posted: Fri Dec 11, 2009 6:00 pm

GuyC · Posted: Fri Dec 11, 2009 7:08 pm

Funny, I get the same question here from an analist of a project that we outsourced to India.

GuyC · Posted: Fri Dec 11, 2009 7:21 pm

explaining the problem :
It is not that he is getting sqlcode +100, He's having a time out because of the performance that grouping on a varchar(6000) can cause.

dbzTHEdinosauer · Posted: Fri Dec 11, 2009 8:06 pm

GuyC,

well, how come you guys outsource the easy stuff?

GuyC · Posted: Fri Dec 11, 2009 8:11 pm