Viewing 15 posts - 616 through 630 (of 1,229 total)
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
summerpet39 (1/14/2016)
January 14, 2016 at 11:21 am
If this is indeed the case, I am not sure why updating one field means blanking out the other, but as I mentioned I am probably missing a thing or...
January 14, 2016 at 11:08 am
Viewing 15 posts - 616 through 630 (of 1,229 total)