Viewing 15 posts - 1,261 through 1,275 (of 5,502 total)
Did you try
WHERE A.CashPurse1 < > 0
July 14, 2011 at 1:22 pm
Just as a side note: instead of
WHERE DATEPART(YEAR,DateColumn)=2009
I'd rather recommend use
WHERE DateColumn>='20090101' AND DateColumny'20100101'
The original version won't benefit from a (hopefully) existing index on DateColumn.
July 14, 2011 at 1:13 pm
It's hard to troubleshoot without having the table defs referenced by the sproc.
You might need to run the code with defiined parameter instead of calling the sproc with input variables....
July 14, 2011 at 11:41 am
I think there's a little more to change...
Change the block before the comment -- Execute SQL statement
SET @sqlStatement = @sqlStatement + @whereSql + '
)
SELECT * FROM PaymentViewPaged
WHERE RowIndex between @PageIndex...
July 14, 2011 at 10:42 am
Ninja's_RGR'us (7/14/2011)
Not needed anymore.Lutz finally understood the quoting system.
NO. :-P:-D
:hehe:
July 14, 2011 at 10:30 am
@ninja: I edited the quote range in my reply. You might need to adjust yours to reflect that, too 😀
July 14, 2011 at 10:16 am
I just removed the GROUP BY as well as the CONVERT() function. The result is still identical:
SELECTDISTINCT OM.ID,Sequence
FROM #DataHistory OM
OUTER APPLY
(
SELECT
STUFF((
SELECT ',' + LTRIM(RTRIM(O.Letter ))
FROM #DataHistory...
July 14, 2011 at 10:14 am
Matt Miller (#4) (7/14/2011)
SELECT *...
July 14, 2011 at 9:51 am
Start with comparing the actual execution plans if both are exactly the same.
July 14, 2011 at 9:46 am
krypto69 (7/14/2011)
So I'm guessing that this is a dynamic parameter and not static value
yep I talked to the dev again and he said it was a dynamic parameter..so they...
July 14, 2011 at 8:35 am
Almost impossible to answer based on the information provided so far.
Parameter sniffing? Out of date statistics? Missing/dropped indexes? Changed data volume? Heavy server load? Disc issues? ...
Please remember: neither do...
July 14, 2011 at 8:32 am
I am perplexed, can summing up of DISTINCT COUNT aggregated measure from day level to week be a reason for this?
It depends.
What do you expect to be a valid result...
July 14, 2011 at 2:22 am
run the inner query separately:
SELECT wrhid
FROM (
(SELECT wrkID, MAX(wrhid) as wrhid
FROM tblWerknemerHistorie
WHERE wrkID in (SELECT wrh.wrkid
FROM dbTR_20110708.dbo.vwWerknemers WRK
INNER JOIN dbTR_20110708.dbo.tblWerknemerHistorie WRH on...
July 14, 2011 at 2:17 am
Ninja's_RGR'us (7/13/2011)
krypto69 (7/13/2011)
I talked to the dev and he says he must use that function -
So I'm guessing that this is a dynamic parameter...
July 13, 2011 at 4:17 pm
Or even just
WHERE PC.[PaymentStatus] IN ('AM','P','VR')
July 13, 2011 at 3:58 pm
Viewing 15 posts - 1,261 through 1,275 (of 5,502 total)