Comments by nsvrao - CodeProject

nsvrao 1-Jul-22 2:28am View

select
case
when ((marks > 75 and marks < 90) and (marks > 50 and marks < 75)) then grade
else null
end as g1,
case
when ((marks > 40 and marks <= 50)and (marks > 30 and marks <= 40)) then grade
else null
end as g2
from student
where marks --- wanted to know what will be exact condition to be placed in where condition

nsvrao 30-Jun-22 12:17pm View

Either of grade column is becoming NULL with the above query.

nsvrao 3-Mar-21 8:46am View

no, this question is different. I am trying to pass dataset as an INOUT parameter to PostgreSQL stored procedure. In C# I am trying to develop the same.

nsvrao 2-Mar-21 10:03am View

Thanks for your response.

I am trying to pass ref cursor as an input paramter to postgresql stored procedure.

I want to make this ref cursor input paramter as a generic one, so that I can pass any ref cursor as an input parameter for different databases like oracle, sql or postgresql stored procedures.

nsvrao 18-Jul-19 1:56am View

Excel 2016... There are no multiple instances. Under one excel instance, multiple child processes are running.

nsvrao 17-Jul-19 4:54am View

yes, all the excel files are separate instances. I want to close one instance via a batch file.

nsvrao 3-Dec-18 7:41am View

That is in remote machine which I can't post it... Could you please share any powershell code snippet which will set product version number to the given exe file.

nsvrao 3-Dec-18 4:34am View

Could you please share some sample code on the same.

nsvrao 30-Nov-18 12:07pm View

Deleted

I am trying to deploy unmanaged C++ code via Jenkins.

Build version number i will get from Nexus site.

I want to know how to implement versioning to exe file by modifying assemblyinfo.cpp file.

In net i m able to see only managed code versioning.

Could you please help me...

nsvrao 23-Jul-18 9:34am View

Could you please guide me on this.

nsvrao 18-Sep-13 5:37am View

thanks for your solution... but according to the requirement, I am not supposed to declare another table please give me a query with in the select command it self... if possible

nsvrao 18-Sep-13 4:28am View

Thanks for your solution...
But I want that sum in another column in the last row
the remaining columns should be "-".

nsvrao 20-Aug-13 14:45pm View

If you dont mind, could you please explain with an example..

nsvrao 20-Aug-13 11:28am View

In the same View from one textfield in button click I want to pass the argument

nsvrao 20-Aug-13 11:25am View

<table>
<tbody>
<%
int i = 1;

foreach (var data in (IEnumerable<cfrcloamodel>)ViewData["DCDetails"])
{ %>
<tr>
<td class="table_td_bdr_1" align="right">
<%=i%>.
</td>
<td class="table_td_bdr_1">
<%=data.orderno%>
</td>
</tbody>
</table>
This is the way How I want to retrieve the data.
By passing the arguement to the ViewData Function.

nsvrao 20-Aug-13 11:08am View

From View I want to pass the argument.
from a textfield I want to retrieve the data and in button click I want to transfer the data to ViewData
It is in jquery

$("#btnSelectedOrders").click(function() {

});

nsvrao 20-Aug-13 10:46am View

How to pass the argument... Means
I want to retrieve the data by passing one argument to the service.

like cfrep.GetDCDetails(string Dcno);

how to do this..

nsvrao 19-Jun-13 12:31pm View

Thank you very much Prabhu.. for your fast reply... It works for me..

nsvrao 19-Jun-13 11:32am View

LoadingDayRate (second table) * Day Qty (first table)
UnLoadingDayRate (second table) * Day Qty (first table)
CrossingDayRate (second table) * Day Qty (first table)

Finally I want like this

Godown,Activity,Time,Qty,price
1001,Loading,Day,10,10*10=100

nsvrao 3-May-13 5:35am View

Thank you very much mike... But i forgot to tell you one thing.
RouteID RouteSummary
U1_KZ_U1 1001-COAKPL-DL_VSP-FC_RU2-HYDRC
U1_VJW_U2 CN_TRU-VSP-COSKLM
r5 1001

In the second row and third row there is no HYDRC...

Sorry... I forgot to tell you...

nsvrao 3-May-13 2:57am View

Thanks for your fast reply...
but it is returning only one row as out put.. please check this...

nsvrao 2-May-13 9:57am View

Thanks for your fast reply...
Actually my question is different...

Comments by nsvrao (Top 22 by date)