Viewing 15 posts - 1,726 through 1,740 (of 11,677 total)
Sure, you can use the first CTE as a subquery in the second CTE, resulting in only one CTE.
But semantically nothing has changed, since CTEs are subqueries anyway. The execution...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 6:08 am
wannabe_developer (10/8/2014)
Koen Verbeeck (10/6/2014)
There is no backwards or forwards compatibility in SSIS.If you need packages for SSIS 2008, you need to develop them in Visual Studio 2008 (aka BIDS).
Thanks for...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 5:41 am
Raghavender (10/8/2014)
Do we have any compatibility issues between SQL Server 2012 and crystel reports tool.
No idea, never used the tool 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 4:54 am
Evaluation edition will expire after a few months.
For a relatively low price, you can buy SQL Server developer edition, which has all the enterprise features.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 4:31 am
fokkol (10/8/2014)
We solved it to...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 4:08 am
Please include the actual .rdl file instead of the pasted XML.
Or a screenshot would be nice as well.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 3:04 am
NeverDie (10/8/2014)
In the past (many years ago), I was not impressed with Microsoft's Help with Programming Languages and SQL. Ever since, I've used any other resource except for...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 2:15 am
NeverDie (10/8/2014)
My personal opinion, BOL is just a reference point, you can't really "learn" how to do things from BOL.
There are tutorials though on MSDN:
SSIS Tutorial: Creating a Simple ETL...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 1:55 am
ReamerXXVI (10/8/2014)
Thanks for the reply.That's interesting, if that's the case I think it might come down to the SSMS version. The user I'm supporting might be using SSMS express?
That might...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 1:54 am
If you install it on a machine where SQL Server is already installed, you don't need to pay extra for SSIS.
If you install SSIS alone on a machine, you will...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 1:49 am
Take a look at this article:
Report Server Service Trace Log
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 1:46 am
Ville-Pekka Vahteala (10/8/2014)
If I remember correctly those menu links should be there even when user has not enough permissions. Report will show some error on that situation.
Indeed, the reports should...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 1:42 am
faulknerwilliam2 (10/8/2014)
I have tried via indicators but am clearly doing something wrong - will keep trying.
The Wingdings solution is a neat...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 1:22 am
Either use the indicators provided in SSRS, or use the Wingdings font.
For example, é and ê translate in the up and down arrow.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 1:06 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2014 at 12:58 am
Viewing 15 posts - 1,726 through 1,740 (of 11,677 total)