great! thanks for your help.

anthony.green (5/10/2012)

---

It cache's the data in a data file within the solution so it doesnt have to hit the DB every time the report is run in BIDS.

Usually I just...

anthony.green (5/10/2012)

---

It cache's the data in a data file within the solution so it doesnt have to hit the DB every time the report is run in BIDS.

Usually I just...

Sean Lange (5/1/2012)

---

Jeremy... (5/1/2012)

---

Thanks. you've been a huge help. Right before you replied, I actually went back through and and put the entire case statements in the where...

Sean Lange (5/1/2012)

---

You can't reference your derived column like that. You have to use the whole case statement again.

Here is a really basic example.

select case when 1 = 2 then...

capn.hector (5/1/2012)

---

Can you post DDL and Sample date (See the link in my signature for help on posting that if you need it.) it looks like your where clause...

SQLKnowItAll (4/16/2012)

---

Jeremy... (4/16/2012)

---

Thanks for the help so far. I am essentially trying to show the expiration date for an item, however, when the value is null, this means the...

Thanks for the help so far. I am essentially trying to show the expiration date for an item, however, when the value is null, this means the license has...

I'll try that out. thanks for the heads up.

Thank you. I was able to figure it out late last night. The key was using runningvalue() in BI Studio to plot the total orders for the month and...

Figured it out. Had to use a derived table.

SELECT AVG(turntime) FROM

(SELECT DISTINCT Fm.filenumber, dbo.fn_Business_Days_Between_Dates(dbo.GetLocalDateTimeFunc((SELECT MAX(dbo.GetLocalDateTimeFunc(FA1.ReceivedDate))

FROM FileActions FA1

WHERE FA1.ActionDefID IN (61,315, 393, 400) --disburse

AND FA1.ReceivedDate IS NOT NULL

AND...

Thanks much Jason. have a great weekend.

Wow. That worked. I now have 3.500000. Is the built in function just not displaying any decimals,...

Lynn Pettis (2/22/2012)

---

I agree with wildcat as it would cause a table scan. The convert function has to...

Thanks Lynn. Is there a good place to find information on this topic? I've seen the below done 500 different ways and usually have trouble deciphering what some...