Here's a little test harness. It's a simplification of your problem - all you have to play with is the accrual date and the delta you want to apply to...

-- First, correct all the mistakes in your sample table script:

DROP TABLE table1

DROP TABLE table2

DROP TABLE table3

DROP TABLE table4

DROP TABLE table5

create table table1 (phone int,kod_name int ,kod_fname int,kod_country int,kod_auto int)...

The join hint restricts the number of possible plans which the optimiser has to evaluate to the point where it has time to pick a suitable plan, hence with the...

richard.austin (7/5/2013)

---

Thank you, but i am running your revised query and it too is taking a long time. It is worth mentioning that I have since added a join hint...

Eugene Elutin (7/5/2013)

---

I wonder, do NHS operating surgeons ask questions on innet forums while inside of someone body?

OP:

Hi guys, I've just cut the man and I'm not sure what to...

shyam00 (7/5/2013)

---

Thanks for the reply.

Is there any way to tackle my scenario mentioned here.?

I need to combine (UNION) two non related derived tables and create an indexed...

It's very difficult for us too, because we don't know what you want to do. Please explain providing as much detail as necessary....

Andrew G (7/4/2013)

---

The DROP procedure statement refers to a different procedure:

DROP PROCEDURE [dbo].[NIC_OA_GetPatientXRayReportsOut]

create PROCEDURE [dbo].[NIC_OA_GetPhysicianXRayReportsOut]

One is PatientXray, the other is PhysicianXray, change DROP statement to:

IF EXISTS (SELECT * FROM sys.objects...

jhager (7/5/2013)

---

Thanks all for replying; although I was aware of the "precedence" feature of COALESCE, I didn't realize that literal values would be typed differently, in this case 99 as...

select sv.SVSEQ, sc.SCACO, ac.f1 as AccountNo, ne.NEAN, ne.NEEAN,bg.BGCFN1,bg.BGCFN2, bg.BGCFN3, bg.BGCUS,

sv.SVNA1 ,sv.SVNA2, sv.SVNA3, sv.SVNA4, sv.SVNA5, sv.SVPZIP,sv.SVCSA, sc.SCACO,sx.SXDLM

from NEPF ne

inner join tmpAccountList ac on NEEAN=ac.f1

inner join BGPF bg on bg.BGCUS=ne.NEAN

inner...

The optimiser was timing out because of a logic inconsistency in your WHERE clause. Try this:

SELECT c.Title

, c.Surname

, c.[Known As]

, c.Gender

, c.[Start Date]

, c.[Leaving Date]

...

Write a query which utilises a spilling sort or hash 😉

How about posting the code for the stored procedures which are called from this one?

There's nothing in this stored procedure related to importing a flat file - how have you...

What do you mean by 'looping'? A table or clustered index scan? You can incorporate an iTVF into a query using APPLY but that won't help at all if there...

ALTER FUNCTION [dbo].[IF_GetVar2]

(@Var1 VARCHAR(10))

RETURNS TABLE WITH SCHEMABINDING AS

RETURN

SELECT var2

FROM test

WHERE var1 = @Var1

;

GO

-- Testing:

SELECT var2 FROM IF_GetVar2('Somevalue')

-- Examine the execution...