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)