The 24 hour wouldnt be an issue, but I did go a different route. Instead of using the 00:00 format, I went ahead and converted the result to seconds. Then...

Sean Lange (3/25/2013)

---

Since you are trying to record the amount of TIME something took why not use the TIME datatype?

declare @Time time = '09:26'

select @Time

Now you have stored only the...

I went with a different route. If this helps anyone, this is what I did:

=(IIF(RowNumber("BugID")=1, 0, DateDiff("s", Previous(Fields!DateAssigned.Value), Fields!DateAssigned.Value))) / 86400

I placed this in it's own cell, next to the...

GSquared (12/11/2012)

---

If you're using SQL 2008 (as per the forum you posted in), then yes, there's a simple solution. Cast the columns to NVarchar(max). That will work in...

GSquared (12/11/2012)

---

You just need to get rid of the AS statements inside it.

CASE

WHEN column1 = 1 THEN 'column1'

ELSE ''

END

+ ' '...

Let me add that I'm using this SP for a SSRS report. As the code I provided stands, the SP has one parameter called Products. So the parameter accepts multiple...

If I understand what you're looking for, I've done this in the past.

Create a parent group on Details. INnstead of selecting a field, I used an expression like the one...

anthony.green (11/12/2012)

---

What I would do is build a calendar table and link to that based on what you class is a business day.

http://www.sqlservercentral.com/scripts/Date/68389/

Will also come in handy for other calendar...

After a little research, I found this worked for me.

SubString(ChangeLog, 82, Len(ChangeLog) - 40) as Reason

I tried this and it worked but up to a limit.

Case When Len(ChangeLog) >= 5 Then Right(ChangeLog, Len(ChangeLog)-48) Else ChangeLog End As Reason

I can only go up to 48 characters.

Does...

I found this one to be very helpful.

http://www.barnesandnoble.com/w/microsoft-sql-server-2008-reporting-services-step-by-step-stacia-misner/1104954678?ean=9780735626478

You're right. A friend of mine helped me with this and it was the exact same thing. Thanks!

Paul Morris-1011726 (4/25/2012)

---

OK made some progress but I am stuck...

The "Both" and "Printing" selection works from the drop down list on the report... the "Copy" selection is where I...

I hope I can explain this, so here goes.

If you select Both, which has the value of B, it gives the value of '1', which the first part of the...

Daniel Bowlin (4/24/2012)

---

DarthBurrito (4/23/2012)

---

I'm working on a report and this is the last piece I need to complete it.

In one of the column of the report, the column has this...