Thanks Again,,

Its really helpfulll....

Mithun

thanks for ur reply,

But when to use which?

can u guide me in that?

pls..

Mithun

Hello,,,

It was not intended cross post, but i thought of that may be the performance tunning is the right section for it....

I m really sorry , never wanted to waste...

Please Provide us some sample data, ur existing query and what output u getting and and whats ur desired output..

pls

Mithun

mverma4you (4/13/2009)

---

don't cry too much this is not your Board exam. Regarding the point moderator will check for the point.:-D. I can't modified the answer of this question and motive...

I think there is a approval process before this question comes in "QOD"....

arun.sas (4/9/2009)

---

Hi,

Fine with other statement,

Actually in OP the order by based on the last No of the field

Not the length of the field

declare @abc table

(

name1 varchar(10)

)

insert into

hey if u want invoices period wise then just add period to query

SELECT entityid, COUNT(DISTINCT INVOICE),expped

FROM [YOUR TABLE] GROUP...

dwierenga (4/9/2009)

---

It seems like all the function calls are a bit overkill IMO, unless I'm missing how they handle some edge-case.

A simple

ORDER BY len(column), column usually works for me...

hi manohar,

if ur values are going to be mixed of string and alphanumeric and if u want to take care of order of alphanumeric then try this one

ORDER BY...

HEY DUDE,

ITS WORKING VERY FINE,,,GOOD ONE GRETA...

I HAVE NEVER TRIED THIS WAY SO IM VERY GALD TO SEE IT..

REGARDS,

mITHUN

Lowell (4/3/2009)

---

mithun.gite (4/3/2009)

---

yeah thanks for that function actually, we have this function and we are using it also... and we handling such situation thru dynamic sqll......but this question has come...

manohar (4/3/2009)

---

Mithun....

I will tell what i know.....In case of ur query , in where clause u have specified column of integer type...

if u pass any numeric value as varchar then...

manohar (4/3/2009)

---

Mithun....

I will tell what i know.....In case of ur query , in where clause u have specified column of integer type...

if u pass any numeric value as varchar then...

yeah thanks for that function actually, we have this function and we are using it also... and we handling such situation thru dynamic sqll......but this question has come when we...