Viewing 15 posts - 1,876 through 1,890 (of 4,085 total)
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 16, 2017 at 11:16 am
Reported as spam.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 16, 2017 at 10:57 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...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 16, 2017 at 10:55 am
Reported as spam.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 14, 2017 at 3:14 pm
;
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
)
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 14, 2017 at 3:09 pm
Reported as spam.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 13, 2017 at 4:21 pm
Reported as spam.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 13, 2017 at 4:21 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...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 13, 2017 at 4:14 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 10, 2017 at 9:39 am
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 8, 2017 at 9:01 am
I posted this question earlier yesterday, but I don't think I asked the...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 7, 2017 at 2:13 pm
Reported as spam.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 7, 2017 at 2:07 pm
Reported as spam.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 7, 2017 at 2:06 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...
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 7, 2017 at 10:30 am
SSIS Conditional Split Example
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
February 7, 2017 at 10:14 am
Viewing 15 posts - 1,876 through 1,890 (of 4,085 total)