Viewing 15 posts - 1,636 through 1,650 (of 11,678 total)
Maybe a time-out error?
Time to tune that query 🙂
October 14, 2014 at 4:13 am
naga.rohitkumar (10/13/2014)
what need to check in ssrs logs can you please confirm on it
Errors and/or warnings probably?
October 14, 2014 at 1:00 am
cbrammer1219 (10/13/2014)
October 13, 2014 at 3:40 pm
Bharatvip (10/13/2014)
Does this mean the data needed for the...
October 13, 2014 at 3:38 pm
Time to take a look at the execution plan. Remove the TOP and get an estimated execution plan.
Maybe you need some indexes to speed up the query.
October 13, 2014 at 1:26 pm
How many rows are we talking about here?
How many flat files (aka how many joins)?
October 13, 2014 at 1:09 pm
You'll learn a lot more if you try to write the query yourself.
Take a look at the following functions:
October 13, 2014 at 7:01 am
1. Look for the string // (of http://). If you find it, the character that comes after it is your starting position. If you don't find it, the starting point...
October 13, 2014 at 6:50 am
Bharatvip (10/12/2014)
October 13, 2014 at 5:35 am
The following columns are missing in the CTE:
MessergebnisAlpha, MessunsicherheitDefault, testCode, Probennummer, [Parameter] and isDisplay_LOQ.
Also, in the CTE, you have the following CASE expression:
CASE WHEN (CONVERT(FLOAT,REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LTRIM(RTRIM(pt.limitOfQuantification)),CHAR(13),''),CHAR(9),''),CHAR(10),''),'<',''),'*',''),' ',''),',','.')) * 100
>CONVERT(FLOAT,REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LTRIM(RTRIM(pt.limitOfQuantification)),CHAR(13),''),CHAR(9),''),CHAR(10),''),'<',''),'*',''),' ',''),',','.')) *...
October 13, 2014 at 5:18 am
Ah ok. So basically if the gap between two timestamps is bigger than 15 minutes a new group should be started.
This is a typical gaps and island problem.
Itzik has a...
October 13, 2014 at 4:50 am
OK. On what decision are the first three rows grouped together and the last two rows grouped together?
October 13, 2014 at 4:27 am
It seems there is a ) missing that closes your CTE.
Where does it need to be?
After " AND pt.testId = t.TestId
AND pt.isDeleted =...
October 13, 2014 at 3:18 am
Viewing 15 posts - 1,636 through 1,650 (of 11,678 total)