Thank you Will try and test the performance

Yes after the @

Hi

Try this way

as my prev piece of code but only change the left join between the tables.

CREATE TABLE #REV_BINDERS2

(

[OFFICE_ID]...

Hi

Try a cover index

something in the line of

CREATE NONCLUSTERED INDEX Idx_CoverIndex ON InvoiceEquipment (EquipID,InvoiceDate DESC) inlcude (Amount,Type)

Kind Regards

HI

maybe this will also help. Thou not an IN operator but effective

Kind Regards

CREATE TABLE #REV_BINDERS2

(

[OFFICE_ID] [INT] NOT NULL

...

Hi Luis

Thanks for the link. Will have a look at it.

Regards Daniel

Eirikur Eiriksson (8/2/2014)

---

Daniel Matthee (8/2/2014)

---

Hi Eirikur

I dont fully agree that it has the same flexibility.

For example in my suggestion i can create any date...

GilaMonster (8/2/2014)

---

I'm saying that's a pretty extreme statement to make, claiming that all subqueries and derived tables cause TempDB overhead (which, btw, would not show as physical reads, they'd show...

Hi Eirikur

I dont fully agree that it has the same flexibility.

For example in my suggestion i can create any date range as a integer...

Hi

Please help me if I am wrong. But usually when i do an inner select and look at sql monitor the physical reads, or even sp_who2 active the amount of...

Hi

Yes normalize should work but if you can get your dates to be more like and integer value like 20140707 = 7-jul-14

then the following idea might work better for you.

CREATE...

Hi

I recommend create a nice function on your database.

CREATE FUNCTION [dbo].[getParmsFromString]

(@String VARCHAR(MAX))

RETURNS @Parms TABLE

(

...

So this can easily be done in SQL.

But since this is string parsing it will be intense on the sql server. So i recommend to rather change the way the...

Hi

What about something like this.

declare @inc int = 0

create table #BATCH (

Number int,

BATCH varchar(2)

)

while (@inc < 36000)

begin

insert into #BATCH

select @inc,

case

WHEN @inc BETWEEN 10000 AND 10999 THEN 'A' ...

Hi

Although the above mentioned queries will work I have learned not to do Inner select as this creates over head on the tempdb on the server.

An inner select is sql...