Viewing 15 posts - 18,286 through 18,300 (of 22,220 total)
josephptran2002 (2/19/2009)
Hi Thereyou are right, my mistake
But After I fix the DDS of one table then it says "Invalid Object Name 'dbo.BOCLEARED' "
DO YOU KNOW WHY
Usually that means that...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 1:22 pm
GilaMonster (2/19/2009)
Grant Fritchey (2/19/2009)
Lynn Pettis (2/19/2009)
Put down the keyboard and back away slowly and noone will get hurt...How do you think this OP would do in our mock interview?
I'm going...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 1:18 pm
josephptran2002 (2/19/2009)
Hi there,How can I copy the script of my CREATE TABLE?
THank you
P.S: I'm new to SQL, sorry I try to learn as fast as I can
Right click the table...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 1:17 pm
josephptran2002 (2/19/2009)
Select Sum(b.BOCLEARED) AS BOTotal, Sum(c.CTCLEARED) AS CTTotal, Sum(m.MECLEARED) AS METotal, Sum(n.NHCLEARED) AS NHTotal, Sum(r.RICLEARED) AS RITotal, Sum(w.WOCLEARED) AS WOTotal,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 1:12 pm
Why move all the data to a new table? You can just query the existing tables. I assume the DDS column is some kind of key?
SELECT SUM(b.BOCLEARED) AS BOTotal
,SUM(c.CTCLEARED) AS...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 12:30 pm
Lynn Pettis (2/19/2009)
Put down the keyboard and back away slowly and noone will get hurt...How do you think this OP would do in our mock interview?
I'm going in. This could...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 12:26 pm
GilaMonster (2/19/2009)
Edit: Or maybe not. How have I managed to not notice this guy so far?
Alvin Ramard (2/19/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 12:23 pm
I'm carrying about 15 pounds I don't need (and no, it's not my head. I need it. I need two) and it does slow you down. I used to run...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 11:44 am
It's on the standard toolbar by default. Button all the way at the end looks like a chart of the stock market.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 11:14 am
Lynn Pettis (2/19/2009)
GilaMonster (2/19/2009)
Grant Fritchey (2/19/2009)
I'm testing for my 3rd degree on the 14th of March.
3rd Degree black? Woot! Good luck.
My sensei's been pushing me to do 2nd for...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 11:11 am
samalex (2/19/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 11:06 am
I know of four ways to do this, a function, a tally table, ad hoc queries or changing the data to XML. You have a function. This article [/url]is by...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 10:36 am
GilaMonster (2/19/2009)
What's this? I practice a defensive style. He's the one who knows how to punch
I deny everything.... 😛
I'm testing for my 3rd degree on the 14th of March.
And we're...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 10:29 am
GSquared (2/19/2009)
Also, Seattle may not be Dallas, but bow hunting was a big deal in...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 10:25 am
Steve Jones - Editor (2/19/2009)
Hit you?!?!?! She shoots arrows. Not sure the other side of the room will help.:w00t:
I'm assuming customs will prevent her from getting through with the sword...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2009 at 9:33 am
Viewing 15 posts - 18,286 through 18,300 (of 22,220 total)