Hi,

This works perfectly, Thanks 🙂

This works perfectly, I can't thank you enough 🙂 🙂

The Order by clause if from the Outer query, it's working fine when included as well.

The Select below returns the same results as the one I first posted. Just rows with values for the filtered dates

SELECT

ot.OperationalTypeAlternateKeyAS [OperationalTypeAlternateKey]

,ot.OperationalTypeAS [Entry Type]

...

I would like to see the OperationalTypeKey and the OperationalTypeName for those columns with no counts, the dates can be defaulted to the filter date, just to show that there...

The script was inherited, I'm not sure why the no lock hint was used especially on temp tables and the others is data warehouse tables that are used by other...

Here's the required output, at the moment the rows with 0 counts are not returned:

For example If I'm running the report for the dates below, I would like to see...

Thanks Lorrin, this works perfectly. I used the WHERE Clause 🙂

Thank you 🙂 I'll try your solution..

Thanks for your suggestions, I'll have a look and improve my script.

Regards Teee 🙂

Hi,

Thanks for your response, I've managed to come up with a solution to split the dates:

-- Get comparison dates

Create Table #TempComparison(dteDateComparison varchar(36), bitProcessed bit)

IF (@dteDateComparison <> '')

Insert Into #TempComparison...

I've joined the inserted table to the actual table as it's using a text column and it works perfectly. Thanks

ALTER TRIGGER trDtlIncident ON dbo.dtlIncident

AFTER INSERT

AS

IF EXISTS...

Thank you, I'll try your suggestions 🙂

Thanks I'll have a look, I have found a temp work around in the meantime. 🙂

Lol! it actually worked when I used IN instead of = but the data that was returned wasn't correct, the second bit works fine.

Thanks

This works perfectly, Thank you all for your responses. 🙂