Comments by Kailash_Singh

Kailash_Singh 20-Jun-20 2:25am View

thank you,

Kailash_Singh 7-Aug-12 2:58am View

thnx ..........

Kailash_Singh 27-Jul-12 5:49am View

Thanx Man....................

Kailash_Singh 27-Jul-12 3:50am View

It is in item template.....

Kailash_Singh 27-Jul-12 3:49am View

Thanx Amit ...
Its suitable when you have one or two tab grid view
but I have more than 20 tabpanel and each panel have its own grid view....
that's why I am using for each loop in tab container....but couldn't find grid view.....

Kailash_Singh 8-Jul-12 23:58pm View

Hi Krrak thanx a lot...Its worked
:) :)
Now I have another condition,
I have three field, SrNo(Int),Month(nvarchar(12)) and Issues(nvarchar(MAX)).

I use following querry:

Select SrNo,Month,count(Issues)as[Total]
from tblIssues
group by Month

But I need as following query

Select SrNo,Month,count(Issues),sum(count(Issues))
from tblIssues
group by Month

again thanx.....

Kailash_Singh 6-Jul-12 6:12am View

My code is working fine when it is running locally. But after publishing it in web server, its not working....

my code is:
<tr><td><asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Conditional">
<Triggers>
<asp:AsyncPostBackTrigger ControlID="Timer1" EventName="Tick" />
</Triggers>
<contenttemplate>
<asp:ListBox ID="lstEmployee" runat="server" Width="200px">
<asp:Button ID="btnMoveRight" runat="server" Text=">>" OnClick="btnMoveRight_Click" />
<asp:Button ID="btnMoveLeft" runat="server" Text="<<" OnClick="btnMoveLeft_Click1" />
<asp:ListBox ID="ddlFor" runat="server" Width="300px" SelectionMode="Multiple">

</td></tr>

Kailash_Singh 6-Jul-12 3:51am View

Hi Ece..
I tried again as following manner:

select [monthname],[YES],[No]
from
(select * from tblIssue )source pivot
(count(IsSolve) for IsSolve in ([Yes],[No]))pt
order by monthname

I got error:
Invalid column name 'monthname'

BTW..thnx a lot for your instance reply

Kailash_Singh 6-Jul-12 2:31am View

Sorry...........Ece........
But Same error...
:( :( :(

Kailash_Singh 6-Jul-12 0:48am View

Hey Ece

Thanx for instance reply

but its not working for me.It's showing error after PIVOT

Incorrect syntax near (

if I remove parenthesis it's showing error after PIVOT

Incorrect syntax near count

I am using Sql server 2005 and I also checked its compatibility level, its 90

Comments by Kailash_Singh (Top 10 by date)