Viewing 15 posts - 121 through 135 (of 418 total)
Nope, it doesn't work. Doubleclicking the titlebar of the window just snaps it backed to TAB-view.
I'm very vexed.
Tnx for answering.
May 19, 2009 at 8:37 am
I could have sworn I used all combinations of +7... I really swear I did...
I guess I forgot some...
Tnx all!
May 13, 2009 at 7:05 am
Interesting...
Maybe I should take a serious look at your solution.
Tnx again.
May 13, 2009 at 6:46 am
OK, tnx for answering; this would work, but it looks mightily expensive. I know I can use a CTE, but I fear that would also be mightily expensive.
I'll check it...
May 13, 2009 at 6:29 am
Hi ALZDBA,
Have you ever benchmarked this MS_ForEachDB? I have, it's not good. And basically it's just another loop.
But as I mentioned before: it is not about a 'realistic' situation, just...
April 30, 2009 at 11:55 am
Hi, tnx for answering all.
Glenn,
I tried something like you suggest, could not get it working. I'll have another try next week, gotta do some work for the next few days:-P
Tnx...
April 29, 2009 at 11:58 am
Tnx for answering.
Nah, this is an intellectual excercise to see how far 1 can go to eliminate loops/cursors. I think I can do something with a UDF, but that would...
April 29, 2009 at 12:50 am
Nobody any comments?:crying:
EDIT: Never mind, found an article on the subject: http://technet.microsoft.com/en-us/library/ms147834.aspx
April 14, 2009 at 2:34 am
Imu,
You are right, an XML file does not necessarily represents the (complete) destinationtable, there are more issues. Still, what I am looking at is a way to use the info...
April 11, 2009 at 9:42 am
Right...
I knew about this column, did not realize multi-dimensional arrays were included...
Tnx
November 17, 2008 at 7:54 am
Something funny is going on, I have to go deeper into this.
Jeff, the statement is as given in my first post. I get about 13000 1-row-effected messages in my resultpane.
However,...
October 21, 2008 at 2:55 am
Again,
Tnx for answering all.
There is a 1-on-1 relation between the 2 tables. There are 2 indices, 1 of them the PrimKey on t1, only 1 PrimKey on t2. Statistics are...
October 20, 2008 at 3:27 am
Tnx for answering all.
I will try the suggestions given here.
The number of records having woonplaats IS NULL is exactly the number of records in the table T2: almost 13000....
October 18, 2008 at 1:28 am
Tnx for answering all.
Garadin, your COALESCE suggestion is interesting, never thought of using that this way, I think I never used COALESCE in my life!
On the use of UNION(ALL): I...
October 2, 2008 at 6:05 am
Viewing 15 posts - 121 through 135 (of 418 total)