Comments by Ashish_Agrawal

Ashish_Agrawal 1-Oct-14 8:21am View

ToJSONString() is also a java function. Just removed it and save the obj only.

Ashish_Agrawal 1-Oct-14 7:43am View

Assuming you are going to use this data at client side (javascript), you can put this data into a hidden field and then access it on client side.

Ashish_Agrawal 1-Oct-14 7:35am View

How are you trying to get the script of the table or sp?

Ashish_Agrawal 24-Dec-13 7:05am View

Where are you assigning @In_Punch?

Ashish_Agrawal 20-Dec-13 6:48am View

"but its not working" means the function is not getting called?

Ashish_Agrawal 20-Dec-13 6:46am View

Where are you storing value into your session?

Ashish_Agrawal 20-Dec-13 4:34am View

which one is line 28 in your code?

Ashish_Agrawal 19-Dec-13 4:51am View

My query is working fine with your given example. I do not get any syntax error. BTW, which SQL Server version you are using?

Ashish_Agrawal 13-Dec-13 3:44am View

What error you are getting?

Ashish_Agrawal 11-Dec-13 12:56pm View

Why are you using subquery when you can get the result through single query. But if you have to use sub query you can do like this..

SELECT Top 3 * FROM (SELECT item as ITEM, COUNT(quantity) as TOTAL_ORDER FROM Items_Order Group By ITEM )as od ORDER BY TOTAL_ORDER desc

Ashish_Agrawal 11-Dec-13 12:39pm View

What do you mean by 'exact output'? Can you please post expected output of your table.

Ashish_Agrawal 10-Dec-13 9:23am View

OP asked through C# code. :)

Ashish_Agrawal 6-Dec-13 11:05am View

Are you creating RadGrid programmatically?

Ashish_Agrawal 6-Dec-13 7:54am View

This query works with your example. Can you post me the column value where you are getting conversion failed issue?

Ashish_Agrawal 4-Dec-13 3:07am View

ViewClientPersonalDetails is view? Is there any relationship between ViewClientPersonalDetails & dbo.Login table?

Ashish_Agrawal 19-Nov-13 5:50am View

what are your next queries? can you give us some example where you are going to use @dist_no.

Ashish_Agrawal 15-Nov-13 8:41am View

Could you please tell me what do you want to do with each row. If you need to do some processing on one column, you can create a functions. Then you can call the function in your select query. Something like this

SELECT Col1, DoSomeProcessing(Col2) as Col2 FROM table1.

Ashish_Agrawal 13-Nov-13 10:38am View

Thanks Rahul. However, would like know the solution you found.

Comments by Ashish_Agrawal (Top 18 by date)