1
  • How to calculate previous row value?

    Here is the model I am using: Data: Date Hours Worked FullDay 9/4/2013 7:13:00 No 9/6/2013 10:52:00 Yes 9/7/2013 6:43:00 No 9/10/2013 9:26:00 Yes FullDay column to be updated as 'Yes' if previous day worked hours is at least 8 hours. How can I calculate whether or not the previous row value is...

    ITKE350,300 pointsBadges:
  • Trimming Values with SQL Server Express 2005

    I have a column whose values range from 10-15 characters and whose last 7 characters I would like to get rid of. Can someone please show me how to do this? I thought it would be RTRIM but that didn't work for me. I can't use LEFT or RIGHT before the column because the column length is variable. I...

    Eabouzeid175 pointsBadges:
  • order of evaluation in DateAdd with multiple expressions

    I've spent 3 hours researching how order of evaluation would work in this expression. If @BeginTime was 16:45:00 for example, what would be the result of this expression? set @BeginTime = DateAdd(mi,-Datepart(mi,@BeginTime)-Datepart(hh,@BeginTime)*60,@BeginTime )

    LHalkape15 pointsBadges:
  • Processing XML files with SQL Server functions

    Hi I read through your tip on Processing XML files with SQL Server functions. It's great but what happens when the XML file exceeds 4000 charcters? I'm using SQL Server 2005 and the XML file that I try and import is too big. Do you have any ideas to how I can use SQL to import an XML file that...

    HughFox105 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following