Viewing 15 posts - 631 through 645 (of 1,246 total)
rakesh.naik (12/31/2015)
The mail could not be sent to the recipients because of the mail server...
----------------------------------------------------
January 20, 2016 at 3:29 pm
Another thing to consider is avoiding the chaining of views if possible. You keep the compiler from getting a good query plan. Things are not as re-usable in the SQL...
----------------------------------------------------
January 20, 2016 at 2:35 pm
How would you know in the real world that [dbo].[L2] was the first view in the chain, where you started the refresh? Certainly things are not named this way...
----------------------------------------------------
January 20, 2016 at 2:30 pm
Great solution Eirikur , the
,ROW_NUMBER() OVER
(
...
----------------------------------------------------
January 20, 2016 at 2:20 pm
If you have someone good at it, finding the bad code and fixing it isn't as expensive as most would think and has the long term benefit of being rather...
----------------------------------------------------
January 20, 2016 at 1:33 pm
Just have to ask, you mentioned you tried all the data types in SSIS. I assume this includes the "double" type as well? I am surprised it would fail here.
----------------------------------------------------
January 20, 2016 at 11:25 am
I did a quick search and looked through a few links on recursion. Here is one that I think explains the basics fairly well from a elementary standpoint.
http://www.cplusplus.com/articles/D2N36Up4/
----------------------------------------------------
January 20, 2016 at 11:03 am
MMartin1 (1/15/2016)
----------------------------------------------------
January 19, 2016 at 2:04 pm
Koen Verbeeck (1/15/2016)
MMartin1 (1/14/2016)
Great question. It reminds me of the merge join transform in SSIS, the inputs have to be ordered in like fashion.
It's not exactly the same. In...
----------------------------------------------------
January 19, 2016 at 11:03 am
After deployment, the shared data source connection is stored, like the reports, to the virtual directory that SSRS deployed to. Here you can change the value of the shared connection...
----------------------------------------------------
January 15, 2016 at 7:39 pm
If you do a search on something along the lines of "Employees table and CTE query to show who reports to who" you will get the main go to example...
----------------------------------------------------
January 15, 2016 at 7:25 pm
GilaMonster (1/15/2016)
sqlnewbie17 (1/14/2016)
Ex:Col A ,col B,col C,col D,col E,col F,col G....... col JCol A > 10
Col B > 100
col C < 20
CASE WHEN <Condition 1> AND <Condition 2> AND <Condition...
----------------------------------------------------
January 15, 2016 at 7:11 pm
Phil Parkin (1/15/2016)
Welsh Corgi (1/15/2016)
Phil Parkin (1/15/2016)
Welsh Corgi (1/15/2016)
drew.allen (1/14/2016)
Welsh Corgi (1/14/2016)
I need to create a new table that has an Identity Column so that I can delete the duplicates.
No,...
----------------------------------------------------
January 15, 2016 at 6:57 pm
In Excel, insert a column next to the one with the date. Assuming there is a value in B2 displaying like 12/31/2015 ... Enter a formula into C2 (the new...
----------------------------------------------------
January 15, 2016 at 5:40 pm
Great question. It reminds me of the merge join transform in SSIS, the inputs have to be ordered in like fashion.
----------------------------------------------------
January 14, 2016 at 1:20 pm
Viewing 15 posts - 631 through 645 (of 1,246 total)