You can't mark it as answer here at SSC. The concept over here...

You could also move the WHERE clause into the view definition (assuming the 10 minute interval is a fixed value).

If the time interval is a variable, I would consider using...

The solution below is based on the DelimitedSplit8K fuction referenced in my signature expanded by an additional output column

Position = CHARINDEX(@pDelimiter,@pString,s.N1),

This allows to check for the number of...

Duplicate post. No replies please.

Discussion already started here

For a new line character you should use "\ n" without the space.

It depends if you're looking for an additional criteria:

WHERE CABWO_CABLE_WORK_ORDERS.WO_NO=[Please Enter WO Number] AND CABWO_CABLE_WORK_ORDERS.ISS_NO)=[Please Enter Issue Number] AND CABWO_WO_DETAILS.TITLE)=[Please Enter Title];

or an alternative criteria:

WHERE ((CABWO_CABLE_WORK_ORDERS.WO_NO=[Please Enter WO Number] AND...

The question what isolation level to use depends on the expected result for a given scenario.

In your case:

What should App2 return as amount while App1 update the amount column from...

I'd use the CrossTab method as described in the related link in my signature.

To apply the concep to your scenario, it would look something like

SELECT

MAX(CASE WHEN display_value='BROADCAST_2'THEN Param_value ELSE NULL...

Duplicate post. No replies please.

Discussion already started here.

I'd recommend to create the view at SQL Server level and tune that view. Once the view is tuned, link it to Access.

A few checks to consider:

Do you have a...

Great you found the solution.

Would you mind sharing it so others might benefit? Remeber, it's a two-way street here 😉

Edit: complaint no longer valid. Immediately fixed by the OP. Well done!

I guess the OUTER APPLY approach will return the data you're looking for:

SELECT *

FROM #temp1

OUTER APPLY

(

SELECT TOP 1 *

FROM #temp2

WHERE ...

What is the data type of EndDate and StartDate?

Are you looking for a simple DATEDIFF() statement?

SELECT CableBoxID,DATEDIFF(dd,StartDate, EndDate)

FROM CableBoxTable