Viewing 15 posts - 331 through 345 (of 1,241 total)
----------------------------------------------------
January 13, 2017 at 11:33 am
Not sure what you mean by "the language of your SQL". You mean if it is ANSI compliant? Is your data source something other than SQL Server?
----------------------------------------------------
January 12, 2017 at 7:28 pm
adonetok (1/11/2017)
----------------------------------------------------
January 12, 2017 at 4:28 pm
Since you are pulling from a URL, have you tried studying the Web Services task in SSIS 2008? I have not touched it in a while so don't want to...
----------------------------------------------------
January 12, 2017 at 4:10 pm
----------------------------------------------------
January 12, 2017 at 4:02 pm
It is as far as the end result being deterministic and resulting in NULL. I thought that was the scope here since your/our statement(s) will not even execute in SQL...
----------------------------------------------------
January 10, 2017 at 1:18 pm
Hmm, which is why you have to read the context. If people are blindly pulling code they don't understand, then they are the ones choosing to take risk. If they...
----------------------------------------------------
January 10, 2017 at 12:42 pm
Brandie Tarvin (1/10/2017)
MMartin1 (1/10/2017)
drew.allen (1/10/2017)
MMartin1 (1/9/2017)
You forgot the NOT.
SELECT CASE WHEN NULL IS NOT NULL THEN NULL ELSE NULL END;
How about
SELECT CASE WHEN NULL IS NOT NULL THEN NOT NULL...
----------------------------------------------------
January 10, 2017 at 12:16 pm
drew.allen (1/10/2017)
MMartin1 (1/9/2017)
You forgot the NOT.
SELECT CASE WHEN NULL IS NOT NULL THEN NULL ELSE NULL END;
How about
SELECT CASE WHEN NULL IS NOT NULL THEN NOT NULL ELSE NULL END
...
----------------------------------------------------
January 10, 2017 at 11:51 am
Is this a dev or prod environment? If dev is it possible others could be publishing then removing the reports as modifications go?
----------------------------------------------------
January 9, 2017 at 6:58 pm
You forgot the NOT.
SELECT CASE WHEN NULL IS NOT NULL THEN NULL ELSE NULL END;
How about
SELECT CASE WHEN NULL IS NOT NULL THEN NOT NULL ELSE NULL END
?
same logical...
----------------------------------------------------
January 9, 2017 at 6:46 pm
If you are using a OLE DB destination adapter in the data flow then you can also tinker with the "Rows per patch:" or the "Maximum insert commit size:" options...
----------------------------------------------------
January 9, 2017 at 6:07 pm
SELECT
tbl1.Date,
tbl1.ID,
tbl1.Order_Amount,
tbl2.StoreNum,
COUNT(tbl1.id) over(partition by tbl1.id) as count
FROM tbl1 right join tbl2
ON tbl1.ID = tbl2.ID
I always cringe a bit when I see those right joins.
Let us...
----------------------------------------------------
January 9, 2017 at 4:51 pm
wendy elizabeth (1/8/2017)
----------------------------------------------------
January 9, 2017 at 4:36 pm
wendy elizabeth (1/8/2017)
----------------------------------------------------
January 9, 2017 at 4:31 pm
Viewing 15 posts - 331 through 345 (of 1,241 total)