Viewing 15 posts - 646 through 660 (of 10,144 total)
SELECT
COL1, Col2, Col3, First_Bal, First_Qty, S_Balance
, First_bal -...
July 17, 2017 at 5:15 am
July 17, 2017 at 5:12 am
July 14, 2017 at 5:59 am
In your sample data, I reckon the third and fourth rows might contain a date error. Are you sure the count should be 3? I make it 2, because there...
July 13, 2017 at 9:14 am
July 12, 2017 at 9:56 am
Here's another way - it works exactly the same way as John's code but makes fewer changes to the original:
July 12, 2017 at 4:29 am
It's a row-goal query which the optimiser hasn't quite figured out. Try this:
SELECT TOP(150000)
fls.query_feasibility_location_solution_id
FROM tbQuery_Feasibility_Location_Solution fls
WHERE fls.created_dttm < '2017-06-01'
AND EXISTS (
July 12, 2017 at 2:11 am
Id, startdate, endDate, PersonID, systemID
1, '01/01/2012', '01/12/2015' 1, 1
2...
July 11, 2017 at 8:53 am
July 10, 2017 at 10:06 am
July 10, 2017 at 7:09 am
July 10, 2017 at 4:25 am
Hi Guys
Aprreciate your help with this. I am trying to tune the following query: It...
July 6, 2017 at 10:02 am
July 6, 2017 at 8:08 am
Viewing 15 posts - 646 through 660 (of 10,144 total)