Viewing 15 posts - 331 through 345 (of 1,246 total)
So is this a SQL Server log or a RedGate log? I guess that is what you are wondering. I dont use RedGate personally but you mention source control, the...
----------------------------------------------------
January 13, 2017 at 1:19 pm
If your RRN schema was instead DBO, then the schema "dbo" would be the owner of all the objects involved. As it stands the DBO owner cannot access those what are...
----------------------------------------------------
January 13, 2017 at 1:12 pm
And of course let me not forget... In SSMS you can simply type CTLR+SHIFT+F and that will put the results of the query to a file you define at run...
----------------------------------------------------
January 13, 2017 at 1:00 pm
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
Viewing 15 posts - 331 through 345 (of 1,246 total)