Manipulating data of the same column

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Manipulating data of the same column

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-11-17 : 08:00:10

jabez writes "Code Description
IN-001 Written Test
IN-002 Technical Interview
IN-003 HR interview

AppId InterviewType Interviewdate
APP-01 IN-001 17/11/2005
APP-01 IN-002 25/11/2005
APP-01 IN-003 30/11/2005

I want to calculate the difference i.e time taken (in days) between each interview type for particular candidate.
So that the output looks like

App Code Time taken for Time taken for Time taken
Technical shorlist HR shorlist from Shortlist
to Tech interview

APP-01 8 5

Windows 2000 service pack 4
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) "

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources