Viewing 15 posts - 1,771 through 1,785 (of 11,676 total)
Tables have no order. Is there any field in your table that can be sorted on to ensure the rows have the correct order?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 6, 2014 at 12:45 am
I believe it is ISServerExec.exe.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 6, 2014 at 12:39 am
The SQL syntax looks fine to me.
What if you tried a DB2 forum, since this is probably a DB2 specific error?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 6, 2014 at 12:37 am
Interesting question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 6, 2014 at 12:31 am
Hugo Kornelis (10/3/2014)
You do not want to know how many seasoned professionals did unspeakable things to their data due to setting SET ROWCOUNT and then forgetting to reset it.
I can...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 6, 2014 at 12:26 am
Nice trivia question, thanks Steve.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 6, 2014 at 12:26 am
Steve Jones - SSC Editor (10/2/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 2, 2014 at 11:57 am
You can also write a pivot as a bunch of CASE statements.
PIVOT compared to CASE for a crosstab result
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 2, 2014 at 6:24 am
Take a look at the PIVOT operator.
An example:
Pivot tables in SQL Server. A simple sample.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 2, 2014 at 5:16 am
You always have 4 values in the metodoctb column? (tipo 1, 2, 5 and 7).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 2, 2014 at 5:07 am
Is for example 7, 2,7,4 one string where all the nubmers are concatened with a comma, or is it actually 4 different columns?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 2, 2014 at 4:47 am
Lempster (10/2/2014)
Koen Verbeeck (10/2/2014)
Phil Parkin (10/2/2014)
Does the account executing the package have access (and permission) to the Excel file?
If it's on a local drive on the server, I would...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 2, 2014 at 4:03 am
Phil Parkin (10/2/2014)
Does the account executing the package have access (and permission) to the Excel file?
If it's on a local drive on the server, I would not expect it...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 2, 2014 at 3:22 am
Chris Webb has written on this (and you can find similar articles through Google):
Build Your Own Analysis Services Cache-Warmer in Integration Services[/url]
Building a Better Cache-Warmer, Part 2: The Formula Engine...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 2, 2014 at 3:05 am
I'm not sure what you mean.
In Reporting Services, you can create a connection to an Analysis Services cube stored on an SSAS server. This means of course you need to...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 2, 2014 at 2:52 am
Viewing 15 posts - 1,771 through 1,785 (of 11,676 total)