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


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Sqlserver query

Posted By: Naresh     Posted Date: August 26, 2010    Points:2   Category :Sql Server
Hi All,

query in sqlserver.

In My application i want to display output like scheduled hrs for 1st week,2nd,3rd and 4th.Output should be like this.for 1st week percentage of people got scheduled less than 24 hrs,b/w 24 and 48,more than 48 hrs.similarly for all other weeks

Ouput like this

SCheduled Hours 8/1/2010 8/8/2010 8/15/2010 8/22/2010

Less than 24 hrs 89% 91% 62% 71%

b/w 25 and 48 hrs 21% 72% 41% 69%




Responses
Author: Abhimanyu Kumar Vatsa             
Posted Date: August 28, 2010     Points: 5   

hey....

let me know which database you are using?

***********************************************

ADCA BCA MINDCRACKER MVP

Author: Naresh             
Posted Date: August 30, 2010     Points: 5   

Hi Abhimanyu,

i am using sqlserver databse



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

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