Viewing 15 posts - 886 through 900 (of 8,731 total)
Well, I won't do all the process to render the html. Can you post something easier to read? You could just get a SELECT with the results you need.
October 20, 2017 at 11:12 am
October 20, 2017 at 11:07 am
October 20, 2017 at 11:01 am
Thom A - Friday, October 20, 2017 9:07 AMSQL Server 2008 Luis/Chris. 😉
October 20, 2017 at 10:58 am
October 20, 2017 at 10:49 am
Here's a sligthly faster version than the original one. I'm not sure what happens if we add a proper holidays table.
I tried by adding a filtered index to...
October 20, 2017 at 10:43 am
A simpler solution, assuming that you can only get zeros and ones.
WITH SampleData AS (
SELECT * FROM (VALUES
(1, 62, 0),(2,...
October 20, 2017 at 8:58 am
EDIT: This is a worse version of Lynn's code. I didn't see it before posting.
How about preventing any updates done to table_a by other connections?
[code...
October 19, 2017 at 1:13 pm
Here's another possible solution, pure brute force.
WITH
E(n) AS(
SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)
),
E2(n) AS(
SELECT a.n FROM E a, E b
October 18, 2017 at 2:24 pm
The conversion of a...
October 18, 2017 at 2:10 pm
October 18, 2017 at 1:38 pm
October 18, 2017 at 7:11 am
dhanekulakalyan - Tuesday, October 17, 2017 2:32 PMIt is working for me, Thank you for keeping this reply.
Thank you for the feedback....
October 17, 2017 at 3:39 pm
Did you find a real-world problem with this functionality? Or were you experimenting?
October 17, 2017 at 1:50 pm
Hello everyone,
October 17, 2017 at 11:28 am
Viewing 15 posts - 886 through 900 (of 8,731 total)