It's been a while, but I do think that the back end needs a 0 or 1 in FrontPage.

That depends on your development environment, but 0 (zero) usually represents an unchecked state, while 1, -1, or sometimes any non-zero value represents a checked state. Some dev environments even have...

The method I came up with is the same basic concept, and I have no idea whether it would be faster or slower than Ninja's solution (I'm guessing they'd be...

Are you wanting to do this for a range of dates, or specifically only for the last six orders, no matter how many days elapsed between the first and last...

My bad, I had them switched in my head. I'm got a bit confused, as RS does allow for a Report Header, it's just in the body itself, which I see you've...

The link you provided is to a picture stored on your local drive, so while you can see it, none of us can (except for those who have hacked into...

By the way, RS does have Report Headers. Right click on that grey square in the upper left corner of the layout design window, and you can turn on the...

I don't believe that it even checks names when you set permissions from SQL Server Management Studio. When you do it from Report Manager, even though it looks the same,...

You'll find that many folks here have hundreds of millions or even billions of rows of data, so don't fret expanding your's to 288k. The main problem with the design...

Without seeing your data, I don't see anything obviously wrong, but there are a few things I'd check, just to ensure there are no typos, etc.

First, your derived table for...

This is pretty close to what it sounds like you're attempting to do with it.

While I agree with jezemine about the model, below is a solution (untested) that should work for you. Keep in mind that you didn't qualify columns, so I guessed as...

A couple of questions. Are you joining on col1 between the two tables? Assuming that is true, what are the maximum number of rows that a single col1 value has in...

Untested, and it's Friday, so probably not the ideal solution, but it should work:

UPDATE

 i

SET

 i.Payor = p.Payor

FROM

 InpatientMedStat AS i

 INNER JOIN (

   SELECT

    PID

    ,Payor

    ,MaxAmt

   FROM

    [Table two] AS t1

    INNER JOIN (

      SELECT

       PID

       ,MaxAmt = Max(PayAmount)

      FROM

       [Table two]

      GROUP BY

       PID

       ) AS...

The problem is that you are using a five part name to reference a column in a table that you've already aliased, specifically "mwltmw.MWI.DBO.RM20201.APFRDCNM" and "mwltmw.MWI.DBO.RM20201.APTODCNM".

In fact, after looking at this...