Viewing 15 posts - 331 through 345 (of 1,243 total)
To export a column to a file>
I took this example from
http://mytechmantra.com/LearnSQLServer/How-to-Export-records-from-SQL-Server-to-Text-File-using-BCP/
EXEC xp_cmdshell 'bcp "SELECT Name FROM [AdventureWorks2012].[Person].[CountryRegion]" queryout "C:\Temp\CountryRegion.txt" -T -c -t ' ----------------------------------------------------
January 13, 2017 at 12:55 pm
The place where I know the dimension key(s) are defined is when creating the dimension through the wizard. I choose 'use an existing table' and select the date dimension from...
----------------------------------------------------
January 13, 2017 at 12:22 pm
----------------------------------------------------
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
Viewing 15 posts - 331 through 345 (of 1,243 total)