Comments by V Mohan (Top 40 by date)

Yes i am using stored procedure

Thanks rob.

I am using .Net 3.5 and SQL Server 2008

Thanks
Mohan

Thanks peter, With above query its converting all the single record into min
like below
RID CID Name Value
1 1 Test 175
1 1 Test 200
But

I need the Result as below
RID CID Name Value
1 1 Test 375

Some of value field of similar rows

Thanks, But it displays the seperate records as result like below
1 1 Test 2:15
1 1 Test 4:15
But i need result as follow
1 1 test 6:30

Please help

Thanks. But its working for me if the value is integer. My problem is the value field is can be time also so i use the below conversion to set sum of time

Convert(time,dateadd(s,SUM(( DATEPART(hh, td.value) * 3600 ) + ( DATEPART(mi, td.value) * 60 ) + DATEPART(ss, td.value)),0)) as Total

But it show the same values not the sum of the values. Please help me to resolve this

Sorry, I got the Sum of all values in a table , But my requirement is need some of Unique record values. Please help me

No

Thanks. it is working fine

Because value is nvarchar type

Thanks for yor reply. Second query is working fine. But the first query is showing error as follows

Conversion failed when converting the nvarchar value '4.3' to data type int.

Because the Data type for Value is nvarchar. So its shows error as below

Operand data type time is invalid for sum operator.

Thanks for your reply. I tried but it shows error as below

Operand data type nvarchar is invalid for sum operator.

I tried, But it shows error. Please help me to get sum of all int and sum of all time value in a query

I want two outputs one is sum of all integer values as integer and another one is sum of all time in time format.

Thanks

Thanks Raul. I tried this but it return all the records in the table i need max version of each product.Please help me to achive this

Thanks.

I need Max version based on Each Product. I will give Persion_Id as input . But i need result for each product max version

Please help

Thanks, But i need generalized query to achive this task.
I want only month as a result when i gave start date and end date.

But main objective is month to be rounded of to down that is

if result is 1.9 then result need to change as 1


Please help me to resolve this

<SESSIONSTATE timeout="150"> </SESSIONSTATE>

Thanks Prasad.

i need session timeout as 150 min. So can i set like below in web.config.

<sessionstate timeout="150"> .

Thanks in Advance
Mohan

Thanks. But Already button inside the update panel

Thanks.but my code is in update panel only

its only for one project.

Thanks Suna,

I have bulk data in my excel sheet.From that excel sheet only i need to be copy data and store in SQL table. How i can read data from Excel to sql server

in master page

<div id="content" class="shell">
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<contenttemplate>
<asp:ContentPlaceHolder id="ContentPlaceHolder1" runat="server">




</div>

in Aspx page :


<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">

<asp:UpdatePanel ID="RegUpdatePanel" runat="server">
<contenttemplate>

<asp:FileUpload ID="flUpload" runat="server" Width="148px" />
<asp:Button ID="btSubmit" Text="Upload" runat="server" OnClick="btn_UploadClick" />


<Triggers>
<asp:PostBackTrigger ControlID="lnkTemplate" />
<asp:AsyncPostBackTrigger ControlID="btSubmit" />
</Triggers>

Hi FOX,
Thanks for your answer.
I use web form (ASP.Net with C#)

Yes. I changed the permission in IIS. its working fine. Thanks

Thanks Aarti

Sorry for confusion .please validate above table structure. Can i use the same table structure for storing and display nearly 100 employee .

Hi Aarti , Thanks for your advice, can you give the table design that the above inputs stored in Database

As well as i need separate table for each team

Thanks Sandeep.

I share some sample questions

Team Question Answer

A Question1 Answer1
A Question2 Answer2

B Question 1 Answer1
B Question 2 Answer2

C Question1 Answer1
C Question2 Answer2

In this way i have to display the grid. Pls suggest the best method to display this content.

I am using Update panel . But outside the update panel same code is working fine. Problem is with the update panel.

Simply i use to download the file from server in my link button click event

Please help me to solve the problem .


Code is as below

Response.AppendHeader("Content-Disposition", "attachment; filename=" + FileName);
Response.TransmitFile(FilePath);
Response.End();

Already i did change the values of ObjectDatasource using the Smart Tag of the Report Viewer. But Same Error is Display

Thank you so much

No, In different scenario i join different tables but i select common fields from all. For that only i need a LINQ query for var Lqry as a general