Viewing 15 posts - 6,151 through 6,165 (of 11,678 total)
L' Eomot Inversé (11/27/2012)
Isn't "avoid them" good advice no matter which dance group somewhat popular in 2000 "them" might refer to?
For some obscure reason they're still popular. They still sell...
November 28, 2012 at 12:08 am
Revenant (11/27/2012)
Jo Pattyn (11/27/2012)
DBCC Timewarp: Active Directory returns to 19 november 2000. New singer Linda Merts for the popular belgium pop/dance group. Waar zijn die handjes?:-D
Sorry, this airplanes me. What...
November 27, 2012 at 12:31 pm
Hugo Kornelis (11/27/2012)
Koen Verbeeck (11/26/2012)
Nice question. The explanation could be a bit more clear.That is a very polite way to put it.
That's the difference between the Belgians and the Dutch...
November 27, 2012 at 6:01 am
The logical processing order specifies a way how the results should be achieved.
However, the query processor can choose any ordering it wants, as long as the end result is the...
November 27, 2012 at 5:18 am
You can have multiple OLE DB sources in your dataflow. Each of them executes one SQL query. You can append to resultsets to each other using the UNION ALL component...
November 26, 2012 at 11:40 pm
How many users are there?
How did you configure the lookup?
November 26, 2012 at 11:38 pm
No and Yes. You can't install on XP, but you can install on Windows 7. You can install it even on Vista if you'd want to.
November 26, 2012 at 11:35 pm
Can you provide us with a little bit more information?
What type of connection are we talking about?
What are you doing inside the package?
November 26, 2012 at 11:33 pm
Nice question. The explanation could be a bit more clear.
It's not the default from the default expression GETDATE(), but the default value that is chosen when 0 or space is...
November 26, 2012 at 11:31 pm
I mean the actual error description. The one that shows in the output tab in BIDS.
November 26, 2012 at 6:02 am
So much to read on a Monday morning 🙂
I wonder why the explanation talks about EXCEPT when none of the answers use it.
November 26, 2012 at 12:51 am
LAG and LEAD are still relational I think, because you use them in the OVER clause which defines a window (which has an ORDER BY).
November 23, 2012 at 3:55 am
I don't mind 🙂
You can change the datatype of the column in the Advanced Editor of the source component. Check the output column in the last tab.
Make sure you refresh...
November 23, 2012 at 3:54 am
learning_sql (11/23/2012)
Koen Verbeeck (11/22/2012)
In the source query, use the following TSQL:
SELECT myDate = REPLACE(CONVERT(CHAR(10),mySmallDatetime,103),'/','')
FROM myView
I added that to my create view statement (the ssis exports an entire view) and...
November 23, 2012 at 3:31 am
Viewing 15 posts - 6,151 through 6,165 (of 11,678 total)