Viewing 15 posts - 8,041 through 8,055 (of 11,678 total)
What they are meant for: substracting and summing values.
It's hard to see without the entire SQL statement present, but the select statements return numerical values.
edit: apparently Gail can type faster...
February 8, 2012 at 7:16 am
And the award for best topic title this year goes to:
Processing Dimension fails when it sees Michael Bublé
(thanks to Gail for spotting this)
February 8, 2012 at 7:07 am
Henrico Bekker (2/8/2012)
Try SQL_Latin1_General_CP1_CI_AS
If the collation first used is accent insensitive, shouldn't the process succeed?
As it doesn't matter if the letters have accents or not...
February 8, 2012 at 7:02 am
For those who stumble upon this thread using Google, there is a more thorough discussion at the MSDN forums:
February 8, 2012 at 6:34 am
Normally 2005 packages have the 2005 behaviour and 2008 packages the 2008 behaviour, as each has it's own Integration Services service that loads the appropriate runtime and DTEXEC executable.
This is...
February 8, 2012 at 6:10 am
SQL 2005 can not run 2008 packages, so you should only be developping in BIDS 2005, or migrate to 2008.
There is no difference between 2008 and 2008R2.
I think the easiest...
February 8, 2012 at 5:00 am
nithila.sp (2/8/2012)
I have two series for Y axis value
i.Actual
ii.Goal
X-axis is month
So when i change the series property of actual all the bar will be of same
color,this...
February 8, 2012 at 4:55 am
And I learnt about truism! :w00t:
(yes dear OP, we are spamming your mailbox with useless notifications :-D)
February 8, 2012 at 2:25 am
Ian C0ckcroft (2/7/2012)
February 8, 2012 at 2:22 am
SQL Kiwi (2/8/2012)
Koen Verbeeck (2/8/2012)
The INTERSECT is quite an elegant solution, that one is going straight into my knowledge libraryFor details here, for anyone interested:
Interesting read, thanks for the link.
February 8, 2012 at 2:20 am
If you want to do everything with SSIS, you could use a For Each Loop with a file system task inside.
One loop for .xls, one loop for .txt.
LIKE THAT
But I...
February 8, 2012 at 2:18 am
Business intelligence is not a single product, it is an entire field.
You first need to know what product you will focus on, for example the Microsoft BI stack using SQL...
February 8, 2012 at 2:13 am
SQL Kiwi (2/8/2012)
Koen Verbeeck (2/8/2012)
I believe this will work:
Doesn't account for NULLs.
SELECT
t2.*
FROM dbo.temp1empdtls AS t1
JOIN dbo.temp2empdtls AS t2 ON
t2.empno = t1.empno
WHERE...
February 8, 2012 at 2:06 am
Phil Parkin (2/8/2012)
Koen Verbeeck (2/8/2012)
banu2316 (2/7/2012)
findstring(character expression,string,occurance)!=-1wat does the condition specifies here.
That's a tautology (aka always true).
-1 is never returned by the findstring function, so this expression always yields true.
Actually,...
February 8, 2012 at 2:00 am
I believe this will work:
SELECT temp.empno, temp.empname, temp.age
FROM
temp1empdtls major
INNER JOIN
temp2empdtls temp
ON major.empno = temp.empno
WHERE major.empname <> temp.empname OR major.age <> temp.age
February 8, 2012 at 1:53 am
Viewing 15 posts - 8,041 through 8,055 (of 11,678 total)