Viewing 15 posts - 32,701 through 32,715 (of 59,102 total)
henrik staun poulsen (8/24/2011)
Well, yes that might be true. But my meta data says that it is a float. So my transform job crashed.
With my improvement, the code continues...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 28, 2011 at 6:52 pm
uncle_boris (8/23/2011)
Unfortunately I do not know the technique or protocol to display two execution plans in this forum so they are viewable.
Run the code with the "Actual Execution Plan" turned...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 28, 2011 at 6:47 pm
Lynn Pettis (8/24/2011)
Jeff Moden (8/23/2011)
IceDread (8/23/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 28, 2011 at 5:30 pm
Isn't there also supposed to be some "deleted" data to go along with that "added" data?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 28, 2011 at 5:23 pm
You bet, Karthik... thank you for the feedback.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 28, 2011 at 5:18 pm
GilaMonster (8/28/2011)
WayneS (8/28/2011)
Jeff Moden (8/27/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 28, 2011 at 4:57 pm
J Livingston SQL (8/28/2011)
Jeff Moden (8/28/2011)
nairdeepa (8/27/2011)
Hi Jeff,I am not clear on what you just said. could you please elaborate?
Many thanks,
Gah covered that pretty well for me. He also...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 28, 2011 at 4:48 pm
nairdeepa (8/27/2011)
Hi Jeff,I am not clear on what you just said. could you please elaborate?
Many thanks,
Gah covered that pretty well for me. He also provided an example of how...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 28, 2011 at 12:28 pm
Gosh... outright theft of articles just keeps getting worse and even more blatant. Take a look at the following and then click on the Feb/Mar 2009 magazine release to...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 27, 2011 at 9:19 pm
Yeah, you're right, of course. Old habits die hard.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 27, 2011 at 6:37 pm
Bruce W Cassidy (8/22/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 27, 2011 at 5:14 pm
Sarath Vellampalli (8/27/2011)
How to loop through files in a specified folder, load one by one from source folder and copy to destination folder using SQL stored procedure.
My requirement is,...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 27, 2011 at 4:18 pm
nairdeepa (8/27/2011)
with abc as
(select client_order_number,mmc_vendor,max(session_order) as 'max_session' from
dbo.tmp_coremetrics_order_lookup
group by client_order_number,mmc_vendor)
,abc1 as
(select * from dbo.tmp_coremetrics_order_lookup x
where x.client_order_number in...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 27, 2011 at 4:14 pm
I had a thought about this last night and didn't want to proceed until I had an answer because, depending on the answer, we might be able to simplify your...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 27, 2011 at 10:09 am
Chelo (8/26/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 26, 2011 at 8:08 pm
Viewing 15 posts - 32,701 through 32,715 (of 59,102 total)