How do I execute outside the editor? Thanks.

Thanks for the replies guys, however, I had figured out the answer shortly after my post. My apologizes for not updating the thread.

GilaMonster (1/15/2014)

---

I suspect (without any ability to test) that you want this

WHERE ((([Serial Query].SER_OR_ADM_IND) = 'A'))

AND t1.DISCHARGE_DISP ! = 'VVX'

AND t1.VISIT_DATE = CONVERT(varchar,GETDATE(), 101)

AND (t1.Diag_Code1 = ''...

Yes, that's correct. Sorry for not being more descriptive.

Links up and dwain c thank you both for your replies.

Links up - I removed the extra parenthesis and the query ran fine, but my results were off....

I have added the extra closing paraenthesis, but still getting the same error.

LinksUp (11/2/2013)

---

Just an extra closing paren.

INNER JOIN cte2 b ON a1.AdmitCCYYMM = b.EffectiveCCYYMM

LEFT JOIN...

Thanks for repyling. I tried your code below and got :Msg 174, Level 15, State 1, Line 32

The substring function requires 3 argument(s).

LinksUp (11/1/2013)

---

Briceston (10/31/2013)

---

I tried casting the date, but...

Can someone please chime on my last post, I really need some insight.

Actually, the missing months was an error on my part when providing a sampling. Both tables have equals months between them.

I constructed a cte, however, I'm still having some issues...

Mark, thanks for replying. Your example logic below was very helpful. After I introduced into my logic, the report runs fine.

Thanks.

Mark Fitzgerald-331224 (10/30/2013)

---

Briceston (10/29/2013)

---

Hi,

I have a SSRS...

dwain.c, Thanks for your insight thus far, I really appreciate it.

Your code is not working with my environment, and I'm not exactly sure why.

Below is the code from my environment...

Ok, understood.

I used your last code example in my environment, and it's taking long to execute. I keep having to cancel it at the 4min mark or else...

First, thank you for replying. How are you deriving your average cost figures?

Hi guys,

Below is an example of my data using a create and insert.

--===== Create the test table with

Create table Admission

(Contract Varchar(4),

Admissiondate Varchar(6),

SumofCost DECIMAL(19,...

Sorry for the delayed reply. I have been caught up with school and work since my first post. Thank you to those who chimed in.

If there was a lack of...