Viewing 15 posts - 1,801 through 1,815 (of 3,232 total)
Sales truely is a more profitable profession. In fact, it is the most profitable profession, plus you are in total control of your income. It also does not...
April 17, 2008 at 10:59 am
There isn't anything else I know better that pays more! You see, all I am trying to do is make as much money as possible here and leave this place!...
April 17, 2008 at 9:13 am
So what was the waittype of your self-blocked process?
April 16, 2008 at 11:21 am
ksullivan is correct, you must alias the table in order to qualify the column names.
As a side note, I hope your servers and customers tables are not huge....
April 15, 2008 at 10:22 pm
You'll need to work with using dynamic SQL to make that work properly. But beware, there are some things to consider when working with dynamic SQL. Here's a...
April 15, 2008 at 10:19 pm
A process shows up as blocking itself when it is waiting on resources (usually I/O). Take a look at the lastwaittype from sysprocesses for that spid and it will...
April 15, 2008 at 10:16 pm
The advantage of using stored procedures is that SQL Server keeps the execution plan in cache so that subsequent executions of that SP do not require a recompilation, in theory....
April 14, 2008 at 4:16 pm
Why are they not including the transaction when executing? You may want to have them run the BEGIN TRAN and the UPDATE without the COMMIT/ROLLBACK. Once they verify...
April 10, 2008 at 9:11 am
Have you went through all of the new formatting/style settings in Management Studios?
April 9, 2008 at 12:57 pm
What features are you looking for? If all you want is intellisense, use SQL Prompt as G2 suggested.
Are you saying that having Management Studios open bogs down...
April 9, 2008 at 12:29 pm
Something is very wrong here.
When both id's are found the code does not work. SQL Server showed an error when both conditions were true. So the code did...
April 9, 2008 at 12:25 pm
What's wrong with using Management Studios for your T-SQL coding?
April 9, 2008 at 12:12 pm
I think it's worth noting here that what you see happening in Matt's example, is that for the OUTER JOIN, if you reference the outer table in the WHERE clause,...
April 3, 2008 at 4:54 pm
So you want to select rows that only exist in TableA? This is an OUTER JOIN.
SELECT a.*
FROM TableA a
LEFT JOIN TableB b
...
April 3, 2008 at 4:35 pm
Viewing 15 posts - 1,801 through 1,815 (of 3,232 total)