Viewing 15 posts - 676 through 690 (of 1,183 total)
Hear Hear, Jeff!
And to add another catch phrase ... "You catch more flies with honey than with vinegar" 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 12, 2007 at 9:20 pm
My opinion is the INNER JOIN method above is more straight forward, but then again I'm biased 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 12, 2007 at 9:45 am
Move this into an INNER JOIN
SELECT SUM(EnrollCnt)
FROM ReportA
INNER JOIN Branch
ON (@ReportType = 1 AND BranchID = '10000023')
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 12, 2007 at 9:00 am
In SQL 2000 the only practical way to INSERT and UPDATE data in/into a table is with two individual statements. In 2005, the MERGE command can be used. I'm not...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 11, 2007 at 9:38 am
*hint* you can format your SQL by placing
"["code"]"
... your code here ...
"[/"code"]"
OK, if I've read your code correctly, you are updating all of the theText fields to...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 11, 2007 at 8:53 am
While I look at this, here's an answer to your question ....
Well, the rule of thumb is that there is no rule of thumb. :w00t:
Each and every problem has many...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 11, 2007 at 7:31 am
zamiran,
First of all, welcome to the site!
Secondly, can you post a bit more on what your wanting to do? In this case, give us the INSERT and UPDATE statements you're...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 11, 2007 at 7:07 am
You will not get an advantage when returning one row. This Hint is used for large (time intensive) result sets.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 11, 2007 at 6:53 am
If you think it through logically, if you had more than one INSTEAD OF trigger, how would the SQL Engine know which one to use? On the other hand, an...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 11, 2007 at 5:31 am
Try reversing the direction of your JOIN.
SELECT
MemDetail.Allocation AS Alloc,
SUM(ISNULL(vwTransactions.ActQuantity, 0)) AS UsedUp,
vwTransactions.MemberID,
MONTH(vwTransactions.TransDate) AS...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 11, 2007 at 5:05 am
It's briefly mention in this article and appears to return the first row of a result set to the user/application without waiting for the entire query to complete.
http://www.sqlservercentral.com/articles/Performance+Tuning/tablehints/667/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 11, 2007 at 5:01 am
No, you can not define the alias in the UPDATE section, you need it defined in the FROM part of the statement.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 10, 2007 at 7:26 am
UPDATE a
SET
a.BI_SSN = b.BI_SSN
FROM CIS_IVR_Master_200712100600 a
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 10, 2007 at 7:22 am
One difference is that NVARCHAR and VARCHAR store data differently. NVARCHAR uses two bytes per character vs. VARCHAR which stores it as one.
as in my example code ....
DECLARE @varChar VARCHAR(5)
DECLARE...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 10, 2007 at 4:44 am
Well, it's past my bed time. Just gave up on watching the Colts vs. Ravens... GO COLTS!
I can't help you tonight, but play around on your development bax. Look into...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 9, 2007 at 9:08 pm
Viewing 15 posts - 676 through 690 (of 1,183 total)