Viewing 15 posts - 616 through 630 (of 1,231 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.
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 - 616 through 630 (of 1,231 total)