Viewing 15 posts - 14,866 through 14,880 (of 19,564 total)
Very interesting. It doesn't do that on mine but apparently it is supposed to be the default behavior.
http://technet.microsoft.com/en-us/library/cc646024.aspx
When debugging transact-sql statements it stops by default on the first line...
April 14, 2010 at 2:09 pm
Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.It looks like you can come back now.
And I did. Just waiting now to...
April 14, 2010 at 1:47 pm
There should have been no need to hit continue on the query.
EDIT: fixed typo.
April 14, 2010 at 1:35 pm
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.
It looks like you can come back now.
April 14, 2010 at 1:13 pm
Mister Ken (4/14/2010)
UPDATEt1
SET t1.ID = NULL
FROM dbo.table1 t1
WHERE EXISTS(SELECT * FROM #table2 t2...
April 14, 2010 at 1:09 pm
Mister Ken (4/14/2010)
Any ideas on using an external column within a derived table?
The external column throws an error every which way you try to configure it. My answer on...
April 14, 2010 at 12:45 pm
Have you checked statistics, execution plans, indexes? Have you checked for blocking? Do you have any traces running?
Please provide the query and actual execution plan - better answers...
April 14, 2010 at 12:41 pm
I missed it as well until I copied it ans pasted to my query window - then it became obvious.
Also, I was surprised to see the sudden responses all while...
April 14, 2010 at 12:37 pm
COldCoffee (4/14/2010)
Buddy, dint your subquery (which u used for the lookup alias) give the result u wanted?
The initial query would provide an error.
April 14, 2010 at 12:33 pm
That looks similar to what we are using. Meaning - we use the same kind of setup but different accounts obviously.
April 14, 2010 at 12:32 pm
Mister Ken (4/14/2010)
select #table1.field1, lookup.line_count
from #table1
inner join (
select field1, count(*) line_count from #table2 where field2 > #table1.field2 group by field1
) lookup
on...
April 14, 2010 at 12:28 pm
select t1.field1, lkp.line_count
from #table1 t1
inner join (
select t2.field1, count(*) line_count
from #table2 t2
Inner Join #table1 tt
On tt.field1 = t2.field1
where t2.field2 > tt.field2
group by t2.field1
) lkp
on t1.field1 = lkp.field1
I believe...
April 14, 2010 at 12:27 pm
You're welcome.
April 14, 2010 at 12:18 pm
Viewing 15 posts - 14,866 through 14,880 (of 19,564 total)