Smart answer Phil

But I don't have 64 bit system ..and I read all installion guides and requirements .but any where not specify the is it for only 64 bit system..

And...

Nope.32 bit x86 system..I mentioned details above ...please check ..above reply

Hey I downloaded a installation file from Ms site ..when I click double on setup.exe Im getting above error ...??????????

Hi All

Thank you Phil Parkin

en_sql_server_2016_developer_x64_dvd_8777069 i have downloaded this file while installing this i am getting same error . i think i have to download 32 bit file .please provide...

Hi ,

following query meets your requirements if there is any wrong correct me .

declare @StartDate datetime, @EndDate datetime

select @StartDate = '10/01/2012 08:40:18.000',@EndDate='10/04/2012 09:52:48.000'

select convert(varchar(5),DateDiff(s, @startDate, @EndDate)/3600)+':'+convert(varchar(5),DateDiff(s, @startDate, @EndDate)%3600/60)+':'+convert(varchar(5),(DateDiff(s, @startDate,...