Comments by patil.nitin8358 (Top 39 by date)

nice job...
but it work for only IN ('varchar', 'nvarchar', 'char', 'text', 'ntext') for int how will it work ?

if i add int inside the IN it gives error

Actually email address & Phoneno are different for each student , i have changed table entries

thanks

now i have changed question title as per ur suggestion.

i already mentioned datatype as varchar so dont go on title

hello BrishPandey,

above function is not working well

1
13.abc
2.1 abc
2.2
311.test

which is wrong , even though 13 is greater than 2.1 & 2.2 still displaying 13 ahead of 2.1 & 2.2

what changes should be done in function?

please help


regards,

nitin

suppose

first row marks=100
@MaxValue>marks i.e. 0 >100 it return false
so @Maxvalue is initialize to 100 so @Maxvalue=100

second row marks=200
@MaxValue>marks i.e. 100 > 200 it return false
so @Maxvalue is initialize to 200 so @Maxvalue=200

Third row marks=300
@MaxValue>marks i.e. 200 > 300 it return false
so @Maxvalue is initialize to 300 so @Maxvalue=300

Fourth row marks=50
@MaxValue>marks i.e. 300 > 50 it return true
so @Maxvalue is initialize to 300 so @Maxvalue=300

Finally it select @Maxvalue which contain 300

Please confirm . Is it correct?

Thanks...

Regards
Nitin

Select @MaxValue=(case when @MaxValue>marks then @MaxValue else marks end) From [stud].[dbo].[Stud]

As it returning @MaxValue=300

how will it compare @MaxValue & marks then finally returning @MaxValue=300

Hello OriginalGriff,

Thanks for that, i dont know the query execution step by step

could u please help me.

Hello NeverJustHere,

Thanks for the solution .

It works for me.

Good

hello BrishPandey,

function create query work well on local sql server 2008 R2 while on remote sql server 2005

it saying that

Msg 139, Level 15, State 1, Procedure sortingfunction, Line 0
Cannot assign a default value to a local variable.


regards,

nitin

Hello Ashish_Agrawal,

your query also solve my problem iff my column contain value of format
11.asd
2.s
3.

if i have column with value 2MyDream then it gives error

Conversion failed when converting the varchar value '2MyDream' to data type int.


Thanks for the help

hello BrishPandey,

Thanks for the help , it solve my problem. good

Regards ,

nitin

Hello Ashish_Agrawal,
it saying

Conversion failed when converting the varchar value '2MyDream' to data type int.

thanks

Hello Snehasish_Nandy ,

actually column is varchar ,could u please see the updated question


Should sort by
1.aaaa
5.xx
11.bbbbbb
12
15. how can i get this sorting order

Wrong
1.aaaa
11.bbbbbb
12
15.
5.xx


Many Many thank for looking this issue

Hello BrishPandey

column is varchar not an numeric

when i run ur suggester query it gives an error

Error converting data type varchar to numeric.

Thanks

hello master,

SELECT *
FROM table
ORDER BY CAST(SUBSTRING(column,LOCATE('.',column)+1) AS SIGNED)

here ,when i use this it gives error to me for locate function , i think it is for mysql


could u please suggest me any other solution for

Should sort by
1.aaaa
5.xx
11.bbbbbb
12
15. how can i get this sorting order

Wrong
1.aaaa
11.bbbbbb
12
15.
5.xx




Regrads,

nitin

I have updated the question. Please review it . it is like a simple addtion of two number.

it was asked by interviewer to me? is their any asyncronous process in wpf

its straight forward question.

i dont want use that passwordBox & set the textmode to password

i cant have option of build. when i right click on Crypto.vb

The use of operators..
use of logical operator the first && operators is works due to preceding high priority so i and j increment with 1 and due to || operator it works only for j not for k .. you can swap j and k then you can get j is not increment but k will increment.

so i need to check priority of logical operator

k=0;
i have preincremented it. then it become 1
why k is o as answer.
I know how to debug the program very well.

To Rohan Leuva,

I think u don't know the answer , this may happenned because of overconfidenc. If u know the answer then u can answer it. i think u have no answer.

every one try to pull out legs of other who want to improve.

if u know it then only u can answer it. for ur information dont go on language just answer if u know the answer reply it

if u know it then only u can answer it. for ur information c & C# logic is same dont go on language just answer if u know

i am able to redirect from http://207.234.225.70 to https:207.234.225.70
but here https:207.234.225.70 it gives me message web page not avilable and the web page must be viewed over secure channel .
I am using iis 6.0.

i am able to redirect from http://207.234.225.70 to https:207.234.225.70
but here https:207.234.225.70 it gives me message web page not avilable and the web page must be viewed over secure channel .
I am using iis 6.0.

after page load i want set src attribute

The Error in OS-64 bit is the Operation or method not implemented

The Error in OS-64 bit is the Operation or method not implemented