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


Top 5 Contributors of the Month
david stephan
Post New Web Links

"NOT ABLE TO GENERATE MY REPORT"

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
 
I have to generate a report in this format:   staffcode   Name   dateintime    dateoutime   duration   for example: Staffcode  Name     01-08-2010intime   01-08-20100uttime   01-08-2010duration 1001        Amit             09:00                   18:30                     09:30 In sql server management studio for 5 days i have written query like this Declare @intime table ( Staffcode varchar(7), Name varchar(100), [01-08-2010 InTime] datetime, [02-08-2010 InTime] datetime, [03-08-2010 InTime] datetime, [04-08-2010 InTime] datetime, [05-08-2010 InTime] datetime ) Declare @outtime table ( Staffcode varchar(7), Name varchar(100), [01-08-2010 outTime] datetime, [02-08-2010 outTime] datetime, [03-08-2010 outTime] datetime, [04-08-2010 outTime] datetime, [05-08-2010 outTime] datetime ) Declare @Duration table ( Staffcode varchar(7), Name varchar(100), [01-08-2010 Duration] datetime, [02-08-2010 Duration] datetime, [03-08-2010 Duration] datetime, [04-08-2010 Duration] datetime, [05-08-2010 Duration] date


View Complete Post


More Related Resource Links

Categories: 
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