Viewing 15 posts - 1,876 through 1,890 (of 4,087 total)
February 16, 2017 at 11:16 am
It depends on what you mean by "link". The obvious options are JOIN or UNION. If you want something more specific than that, you're going to need to provide more...
February 16, 2017 at 10:55 am
;
WITH param_changes AS
(
SELECT *, CASE WHEN LAG(ParamValue) OVER(PARTITION BY ParameterID ORDER BY VersionID) <> ParamValue THEN 1 ELSE 0 END AS change
FROM IntegrationParameters
)
February 14, 2017 at 3:09 pm
The problem with that solution is that it requires a JOIN which is expensive. You can do it without a JOIN.
;
WITH T_Dates AS
(
SELECT...
February 13, 2017 at 4:14 pm
February 10, 2017 at 9:39 am
February 8, 2017 at 9:01 am
I posted this question earlier yesterday, but I don't think I asked the...
February 7, 2017 at 2:13 pm
cbrammer1219 - Tuesday, February 7, 2017 10:19 AMYou're funny
This is a free forum and we are all volunteers here. Most of us...
February 7, 2017 at 10:30 am
February 7, 2017 at 10:14 am
Viewing 15 posts - 1,876 through 1,890 (of 4,087 total)