Viewing 15 posts - 9,406 through 9,420 (of 11,678 total)
Too easy 😀
(especially since you can rule out the "All" answer, as you had to select 2 answers)
May 18, 2011 at 6:55 am
The problem is that you are inserting a datatime value directly in your SQL statement, giving the following result (for today's date):
UPDATE g
SET g.[DateTime]= s.[DateTime]
,g.[OrderID]= s.[OrderID]
FROM
[DB1] g
JOIN
[DB2] s
ON g.id =...
May 17, 2011 at 11:48 pm
That seems OK.
Well, I'm quite out of options. No triggers that are messing with the data?
Sorry, this all I can come up with without looking at the actual package.
May 17, 2011 at 12:29 pm
Can you generate the full CREATE TABLE statement of the table in SSMS. That way we can check the DDL to see if everything is OK there.
May 17, 2011 at 12:19 pm
Scott Arendt (5/17/2011)
Unchecked. If I understand the use of the option, I would only have it checked if I wanted to specify the contents of the column, correct?Thanks,
Scott
Indeed.
You didn't...
May 17, 2011 at 7:22 am
Gianluca Sartori (5/17/2011)
Koen Verbeeck (5/17/2011)
And now I've reached the 5000-points milestone.W00t w00t! :w00t: 😎 :hehe:
Ahem.... Back to the tasks at hand... 😀
Congrats!
You can keep a postcard of this moment:
Thanks! I...
May 17, 2011 at 4:48 am
And now I've reached the 5000-points milestone.
W00t w00t! :w00t: 😎 :hehe:
Ahem.... Back to the tasks at hand... 😀
May 17, 2011 at 3:50 am
Carlo Romagnano (5/17/2011)
Koen Verbeeck (5/16/2011)
And the explanation doesn't mention why inserting NULL in another string doesn't result in NULL, but in an empty space instead.
I am curious: bol does not...
May 17, 2011 at 3:48 am
I thnk you're better of in the SQL Server 2008 forum:
May 17, 2011 at 3:46 am
ckishore 72107 (5/17/2011)
[font="Arial Black"]can u post what is the issue?[/font]
This thread was started in 2007 and was picked up by numerous people over the years.
So the issues are spread out...
May 17, 2011 at 12:54 am
ckishore 72107 (5/17/2011)
1)Make a view in the database having the same column names as in excel sheet.
2)copy the data in the excel sheet and paste it in view.
i...
May 17, 2011 at 12:41 am
I personally went for a career in BI, but that depends on local job market of course. BI is a very interesting field where there are still some awesome technical...
May 17, 2011 at 12:26 am
Duran (5/12/2011)
May 17, 2011 at 12:20 am
I don't see a real (technical) problem with using schema's to seperate facts and dimensions. It's just a question of taste I guess.
I use schema's to seperate data marts and...
May 17, 2011 at 12:01 am
Viewing 15 posts - 9,406 through 9,420 (of 11,678 total)