Viewing 15 posts - 1,771 through 1,785 (of 11,677 total)
You cannot use sum on a text column. Is it possible to give some sample data and desired output?
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 1:51 am
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
Viewing 15 posts - 1,771 through 1,785 (of 11,677 total)