Pardon my ignorance but, could you comment on the attached file? Looks like I need an index on MRN.

DesNorton,
What specifically am I to look for in the results of this query?

Thanx Gail. An answer even I can understand.

Folks,
I have inherited a table with 80K-100K records. Mostly, patient demographic data so, the columns are not wide. I was just wondering if I should expect that SQL would use...

I tried to simplify the code a bit for my sake. I think there is still a problem with double and single quotes.

DECLARE @cmd VARCHAR(2048)
DECLARE @FileName...

Wonderful. Thanx.

Wonderful. I had the Operator set to "=", not "IN". Works like a charm.
Thanx.

The report pulls data for our Radiology department. They want to be able to pull exams by date range, exam type, and location. There is a date range parameter and...

Got it. Thanx.

Still can't get it to work so, I'm going to simplify the report.Thanx for the help

How can I run the report using some of the parameters but not others? For example get all the Xrays for a particular location. Then, run the report again that...

Thanx.

Sorry, yes I did. I get very easily distracted here at work.
Thanx Lowell.

Got it. I would have said so otherwise in my first post but, I understand why they would want those specifics.

I didn't think you needed rules but, here goes.............
The ^ is always the character before the string and the } is always after the string.