Thank you.

I am looking for difference in minutes

select u.UserID, u.UsertRegistrationCompletedDate - r.RIinvitationCreatedDate

from RInvitation r

join User u

on u.UserID = r.RInvitationLoginID

BUT THE OUTPUT IS

101900-01-01 05:00:17.300

111900-01-01 00:00:58.597

121900-01-01 00:07:58.157

131900-01-01 00:04:01.503

201899-12-31 23:41:00.080

211899-12-31 23:41:39.953

231899-12-31 23:15:03.610

291899-12-31 21:27:39.953

I need the difference time between RIinvitationCreatedDate in...

Thanks Lowel!

but my script is...see below, Presently I am exporting this data to excel(manual copy paste). Now I need this report in pipe delimited.

DECLARE @accountID INT

DECLARE @FromDate DATETIME

DECLARE @ToDate DATETIME

SET...

Thank you for the reply. I will restore the database with mdf and ldf

My question is why SQL Server 2005 is accepted .ndf extension in log file path?...

Hi Pradeep, Thank you for your reply.

Can you please guide me how to do from SSMS or any script is there.

Appreciate your help

I tried to use both float and numeric(4,2), but failed get 74.64(eg:)

with float, I got this

0.746428571428571

with numeric, I got this

0.74

Thank you for your reply.

for columns 'Average','Standard Deviation', I want to store the data like 74.64%, 35.72%.

Just wondering what type, precision and scale need to use?

Appreciate your help.

Hi,

I am trying to export data from Excel 2007 to SQL Server 2005.

excel data

Average,Standard Deviation,t_min_median,t_max_median

74.64%35.72% ...

Resolved.

I have combined the date and time columns data in excel itself to new column and imported to sql table.

Thanks to all.

Can I any body provide the solution/script to update the statusID in User table.

here is the error

Msg 547, Level 16, State 0, Line 14

The UPDATE statement conflicted with the FOREIGN KEY constraint "IUser1". The conflict occurred in database "DBName", table "dbo.StatusReason".

The statement has...

Table2 name is StatusReason

Below are the 3 related tables. I want update User table, change the statusID to 1 for users 46 and 48.

TableName: User

UserID(PK) StatusID(FK) StatusReasonID(FK)

46 ...

Thanks for your reply.

This is production and I need to update the record. What is solution for this?

Client is using UNIX plotform.

Our OS is windows.

I tried internally from my end. I am able to send rar files(rename extension also) to myselft and my gmail account.

Client also confirmed...