.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

I Need Help to display Present & Absent when Employee present or Absent

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server

Hi all

hear is my query

SELECT t.EmployeeCode, t.FullName

, COUNT(CASE WHEN t.LogInDate = '2010-07-05' THEN 'p' ELSE 'A' END ) AS [day1]

, COUNT(CASE WHEN t.LogInDate = '2010-07-06' THEN 'P' ELSE 'A' END ) AS [day2]

, COUNT(CASE WHEN t.LogInDate = '2010-07-07' THEN 'P' ELSE 'A' END ) AS [day3]

, COUNT(CASE WHEN t.LogInDate = '2010-07-08' THEN 'P' ELSE 'A' END ) AS [day4]

, COUNT(CASE WHEN t.LogInDate = '2010-07-08' THEN 'P' ELSE 'A' END ) AS [day5]

, COUNT(CASE WHEN t.LogInDate = '2010-07-10' THEN 'P' ELSE 'A' END ) AS [day6]

, COUNT(CASE WHEN t.LogInDate = '2010-07-11' THEN 'P' ELSE 'A' END ) AS [day7]

FROM dbo.PermenantAttadenceView t

WHERE t.LogInDate  between '2010-07-05' and '2010-07-11'

GROUP BY t.EmployeeCode, t.FullName




View Complete Post

More Related Resource Links

Unit Testing SharePoint - Past, Present, and Sporm

As I described in SharePoint: The Wild West of Software Development there is a serious problem when you develop for SharePoint: ensuring quality through unit testing is really, really hard. And that's where a new open source tool just released today called sporm (SharePoint Object Relational Mapper) comes in. While sporm provides many benefits besides simplified unit testing I wanted to focus on this topic first, because sporm's approach, which models the entity framework in the way it supports POCO's, is a unique feature not available with other SharePoint tools like LINQ to SharePoint.

Overflow when image not present



I have the following on an image so that i can load :


The function is:

function Repl_img(sender)
           // you may need to comment this out if no images are reachable
                sender.src = "dir/NoImage.jpg";

When i run on a machien which doesn't have the noimage present i receive a stack overflow at line 0

I've put the try catch around it and still receive this.

I'm wondering if i have the try catch correct or i need something else to fix?

Display Employee Record


I have employee table and qualification table

Each employee has multiple qualifications

Now what i want to display is employees basic information like name, identity card, designation etc..

With all the qualification he/she has

please let me know how can i do that

Following is situation which i dnt want


Identity card :123


Qualification one


Identity card :123


Qualification two

AssemblyInfo file not present in ASP.NET Server Control Project



I have created my first Custom asp.net server control.But i think such projects probably contains AssemblyInfo file.But i am missing that. When i created project that file was not added.

I am working on VS 2008 Team System Edition,with VB.NET language.How to get that file ? 

System.InvalidOperationException: Invalid attempt to read when no data is present.


Invalid attempt to read when no data is present.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.InvalidOperationException: Invalid attempt to read when no data is present.

Source Error: 

Line 53:             if (reader.HasRows)
Line 54:             {
Line 55:                 Response.Write(reader.GetString(0));

Here is my code:

Header for ultimate recipient is required but not present in the message

Hello All-I am getting error message shown below.I am using WSE 3.0/Vs 2005/x509. When my client try to access my webservice, they get error message shown below.Can anyone please help me on this. I am stuch on this issue and can not find a solution anywhere.Feel free to ask me if you have further questions.Thank you very much in adavnce.-Sandip <faultstring>System.Web.Services.Protocols.SoapHeaderException: Server unavailable, please try later ---> System.ApplicationException: WSE841: An error occured processing an outgoing fault response. ---> System.Web.Services.Protocols.SoapHeaderException: Microsoft.Web.Services3.Security.SecurityFault: Header http://schemas.xmlsoap.org/ws/2004/08/addressing:Action for ultimate recipient is required but not present in the message. at Microsoft.Web.Services3.Design.RequireSoapHeaderAssertion.RequireSoapHeaderFilter.ProcessMessage(SoapEnvelope envelope) at Microsoft.Web.Services3.Pipeline.ProcessInputMessage(SoapEnvelope envelope) at Microsoft.Web.Services3.WseProtocol.FilterRequest(SoapEnvelope requestEnvelope) at Microsoft.Web.Services3.WseProtocol.RouteRequest(SoapServerMessage message) at System.Web.Services.Protocols.SoapServerProtocol.Initialize() at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean&amp; abortProcessing)

SQL server setup has encountered the following error: The given key was not present in the dictionar

For various reasons I have installed and uninstalled SQL Server 2008 developer on my vista machine.. I just received this error after clicking the installation > New SQL Server stand alone installation ....link in the Installation Center SQL server setup has encountered the following error: The given key was not present in the dictionary I had to uninstall and reinstall because the analysis services install failed so I wanted to reinstall.

The given key was not present in the dictionary.

When i click site columns in Site Settings. I got an error message.  The given key was not present in the dictionary.

SharePoint crawl errors on files which are not present

All, I'm noticing 2 errors in my crawl logs. Neither of the files exist anywhere on our site. The URLs are http://.../forms/repair.aspx and http://.../forms/combine.aspx and the error message is 'Error in the Microsoft Windows SharePoint Services Protocol Handler'. Our crawl normally takes about 3 and a half hours. Recently, it's been taking 5-6 hours. These 2 errors are logged at the end of the crawl. While the crawl is running, I see the success count growing and at about 3 and a half hours into the process, the success count stops growing. I'm not sure what the crawl is doing for the next 2 or so hours, but if finally logs the 2 errors mentioned earlier at the end of the crawl, then completes. I have tried resetting the crawled content and changing the index location of the SSP, but neither have worked.  I have also tried excluding the path to these two files with crawl rules, but that hasn't worked. I am on SharePoint 2007 SP2. Any ideas? Thanks

Search Autocomplete: The given key was not present in the dictionary

Hello there! I am having difficulty with my search autocomplete. Below is all the code and error logs. Why am i getting "The given key is not present in the dictionary" when i try accessing the ashx file / searching? Can't seem to find the answer....   AutoCompletePeople.ashx (placed in the _layouts) folder <%@ WebHandler Language="C#" Class="GenericHandler1" %> <%@ Assembly Name="Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Assembly Name="Microsoft.Office.Server.Search, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Assembly Name="Microsoft.Office.Server, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> using System; using System.Web; using System.Data; using Microsoft.SharePoint; using Microsoft.Office.Server.Search.Query; public class GenericHandler1 : IHttpHandler { public void ProcessRequest (HttpContext context) { context.Response.ContentType = "text/plain"; string prefixText = context.Request["q"]; using (SPSite siteCollection = SPContext.Current.Site) { // create a new FullTextSqlQuery class FullTextSqlQuery query = new FullTextSqlQuery(siteCollection); query.QueryText = "SELECT Title FROM SCOPE() WHERE

"Non-additive" target value in KPI. How to present it in a scorecard or Pivot Table.

Hi.. I would like to have some help in designing the following solution. It musn't be to hard, but i can't figure it out yet.. I have 2 tables: Group and Worker. Table Group has GroupID and GroupTarget. Table Worker has WorkerName, GroupID, WorkerTarget and Amount. The relation between tables is GroupID, as each worker belongs to a group. Now I want to take this to a pivotTable, to present KPI for each worker, and the value of the indicator is calculated comparing the Amount vs the WorkerTarget. Also I setup a single hierarchy in the PivotTable, where the parent is the GroupID, and when displayed, you can see all the Workers belonging to that group. Now the problem is, Everything is fine when I want to see the actual group total amount value, as I just have to SUM all the Amounts of each Worker, and I can see the GroupAmount. But.. ¿How can I display the GroupTarget in the PivotTable in the same column as the WorkerTarget? I don't mind a solution using SSAS or PerformancePoint, but my idea is in SSAS to put some kind of formula in the KPI target, so when I'm in a level of the hierarchy, the target is WorkerTarger, and when I'm in the parent, the target is GroupTarget. Is there some kind of formula like this??   If not, any other idea will be much apreciated.. Thanks a lot.. regards.. Canario O.

window.XMLHttpRequest - Is it possible to call the Method which is present on the same page?

Dear Friends, I am using the below XML HTTP Request for checking the username whether already exist or not, What i am doing is i am opeing a page on xmlhttp.open("GET", "CheckUserNameSupportiveFile.aspx?UserName=" + username, true); And passing the username to check with database. if (window.XMLHttpRequest) { // code for all new browsers xmlhttp = new XMLHttpRequest(); }if (xmlhttp != null) { xmlhttp.onreadystatechange = state_Change; var adad = username = document.getElementById('<%=txtUserName.ClientID %>').value; // alert(adad); xmlhttp.open("GET", "CheckUserNameSupportiveFile.aspx?UserName=" + username, true); xmlhttp.send(null); }but what i want to do is, IS IT POSSIBLE WITHOUT CALLING ANOTHER PAGE [CheckUserNameSupportiveFile.aspx?UserName=" + username ] Can i check it on the same page itself by calling method OR something on the same page itself.I do not want to pass the value to another page on and check it with DB, i want to do in same page itself.All your suggestion / advice are welcome.

Looking for suggestions or ideas how to setup to capture search criteria and present to user if they

Requirements call for the ability to save search values so that they can select them at later times to return the results without having to re-enter the values. They have the ability to search on 4 different types of data (Date, Time and Lat/Long), so they would like to capture what was entered and ONLY if they chose to save those values, it will be saved and next time they login, if they are searching, they can pick an old search and submit it again.   Im thinking that i add a checkbox next to each button, if they check it, it saves the data into a table with there values and username. Next time they login and go tothe search page, if there are any records for them in the table, i present them with a link that displays all the values stored and if they select one, it will run the search again and present them with the results.. does that sound like the right way to handle this request? 

DataAdaptor/Dataset problems when no row present in database tables

Hi All, I'm trying to use a DataSet to maintain some rows for a table, and when I've finished my changes, send all changes to the database using a SqlDataAdapter.    I find if there are no rows in the table in the database then I am getting a 'Object reference not set to an instance of an object' when I try to access the table in the Dataset. Is there a way to work with a Dataset like this ie. I start off with an empty table and I wish to add rows, to access the structure of the table rows, build rows, then add them and do the update on the SQLDataAdapter. Thanks, Sinead Here is my code: protected SqlDataAdapter memberDA = new SqlDataAdapter(); protected DataSet memberDS { get { if (ViewState["memberDS"] != null) return (DataSet)ViewState["memberDS"]; else return new DataSet(); } set { ViewState["memberDS"] = value; } } protected SqlDataAdapter getDataAdapterForMembers() { SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["SiteDBConn"].ConnectionString; memberDA = new SqlDataAdapter("usp_GetMembers", conn); memberDA.SelectCommand.CommandType = CommandType.Stored

CQWP - The given key was not present in the dictionary.

Hi,  After trying various attempts to solve my problem, followed by searching the internet for what seems days, I only found one documented case with the same symptoms (dated 2007 with no responses!).  I'm putting a plea out to see if anyone else has come across the same issue or has any tips on troubleshooting this further...The problem only occurs with Content Query Web Parts.  All other Web Parts function correctly, and CQWP display fine, but I am unable to use the Modify Shared Web Part command on the drop down menu.The site was created using WSP packages and a content migration.  The CQWP (both MS standard and custom developed) have been working fine for about 5 months, until recently when we get the following error.Any thoughts would be greatly appreciated! The given key was not present in the dictionary. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  Stack Trace: [KeyNotFoundException:

How to find the Number of Tables Present in an XML File?

Dear All,Can any one let me know "How to find the number of Tables present in a XML Schema File"?Thanks and Regards,G.V.N.Sandeep
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend