You may try to use WITH ROLLUP option in your query.

It won't remove all the rows with CompanyID's from the final recordset, but will add 2 records to it"

YEAR ...

I would not update the master table but set up another "queue" table for approval requests.

Once a "details" row is updates the coresponding key value is inserted by the trigger...

Replace "Not working" part with this:

INNER JOIN (

SELECT PATIENT_ID, MIN(Date_Written) MIN_START, MAX(EXPIRES_ON) MAX_START

FROM [dbo].[PT_CASE]

GROUP BY PATIENT_ID ) AS Ptc ON [Pat].[PATIENT_ID] = [Ptc].[PATIENT_ID]

and simply add MIN_START,...

YOu may folow the money :hehe: by tracing intermediate results:

select (1400.05 / 4232.33 ), (1400.05 / 4232.33 ) * 4180.06, round((1400.05 / 4232.33 ) * 4180.06 ,2) --Statement 1

declare @v1...

Steven Willis (3/5/2013)

---

🙂

These values "10:35","14:22", etc. are from an HTML form and they are posted as strings generated by a hard-coded HTML dropdown with the 5 character pseudo-"time"...

Steven Willis (3/4/2013)

---

As for the time being bound to the date...well, no, not in this case. As I pointed out in the OP the data I'm getting from the application...

Jeff Moden (3/4/2013)

---

Considering that you're only working with 6 digits to begin with, consider transposing your formula for a smidgen more accuracy.

UPDATE dbo.Analysis

SET AccMargin = ((MArgin+Freight)/Gallons)

Of course, since you're...

See BOL for descrioption of ROUND function.

...

function

Is the type of operation to perform. function must be tinyint, smallint, or int. When function is omitted or has a value of...

Steven Willis (1/2/2013)

---

The output was for a golf tournament signup schedule and the end-user needed a column to display tee times. These were actual times of course and not durations....

Sean Lange (3/4/2013)

---

Something like this is maybe close.

SELECT rc.ResultCode,

COUNT(a.AccountNumber)

FROM ResultCodes rc

LEFT OUTER JOIN Accounts a ON rc.ResultCode = a.ResultCode

left JOIN [Types] t ON a.AccountNumber = t.AccountNumber and t.[Type] = 'MHIC'

GROUP...

An indexed view does.

Another name for it is "materialized view" - because all...

To get unique vaues you just need to group the entries for the columns (that applies to all kind of queries, not only to "FOR XML" ones :hehe: ):

SELECT a.ID,

...

There is no need for outer apply here

DECLARE @string VARCHAR(8000) = '{White,Black,Green}';

SET @string = REPLACE(REPLACE(@string,'{',''),'}','');

SELECT Name, ISNULL(Item,'Other') AS Color, IDX

FROM #testEnvironment a

LEFT JOIN [dbo].[DelimitedSplit8K](@string,',') b on b.Item =...

or create an indexed view.

There are requirements to meet though - check BOL for details.

ScottPletcher (2/25/2013)

---

But they may need spool space just like any other table or view used multiple times for lookups, etc., yes?

[I actually don't know if SQL spools go to tempdb...