Viewing 15 posts - 4,411 through 4,425 (of 10,144 total)
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...
July 8, 2013 at 5:34 am
-- 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)...
July 8, 2013 at 4:19 am
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...
July 8, 2013 at 1:13 am
richard.austin (7/5/2013)
July 5, 2013 at 8:00 am
Eugene Elutin (7/5/2013)
OP:
Hi guys, I've just cut the man and I'm not sure what to...
July 5, 2013 at 7:45 am
shyam00 (7/5/2013)
Is there any way to tackle my scenario mentioned here.?
I need to combine (UNION) two non related derived tables and create an indexed...
July 5, 2013 at 6:57 am
gurbanov.1984 (7/5/2013)
butfor me this query very diffcult
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....
July 5, 2013 at 6:52 am
Andrew G (7/4/2013)
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...
July 5, 2013 at 6:25 am
jhager (7/5/2013)
July 5, 2013 at 5:56 am
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...
July 5, 2013 at 4:56 am
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]
...
July 5, 2013 at 4:50 am
sqldbaonly (7/5/2013)
How to do tempdb utilazation in mssq; server ?
Write a query which utilises a spilling sort or hash 😉
July 5, 2013 at 3:35 am
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...
July 5, 2013 at 3:03 am
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...
July 5, 2013 at 1:53 am
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...
July 5, 2013 at 1:27 am
Viewing 15 posts - 4,411 through 4,425 (of 10,144 total)