Viewing 15 posts - 571 through 585 (of 1,183 total)
Yep, it's LEFT OUTER. I found where I had to reference it before.
Thanks guys....
______________________________________________________________________
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. SelburgApril 1, 2008 at 12:20 pm
In answer to your question, I would say that it's nothing more than a matter of preference. If either of the developers are telling you that theirs is "faster" or...
______________________________________________________________________
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. SelburgMarch 26, 2008 at 2:48 pm
Ahmad Osama (3/26/2008)
How are you getting on with this, Ahmad? It would be interesting to hear which method you finally chose and how you fared with it 😀
Cheers
ChrisM
I have chosen...
______________________________________________________________________
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. SelburgMarch 26, 2008 at 11:52 am
Steve Jones - Editor (3/26/2008)
Good excuse to see if the procedures work! Put on your serious face and "sell it"!
I understand and would agree with that statement, but I'm too...
______________________________________________________________________
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. SelburgMarch 26, 2008 at 9:42 am
Thanks Michael, that clears it up a bit.
And the spids have finally dropped out of activity monitor. The transaction logs are now running as normal. So for now, it's ok.
It's...
______________________________________________________________________
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. SelburgMarch 26, 2008 at 9:41 am
Steve Jones - Editor (3/26/2008)
______________________________________________________________________
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. SelburgMarch 26, 2008 at 8:52 am
Jeff Moden (3/25/2008)
______________________________________________________________________
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. SelburgMarch 25, 2008 at 6:38 am
Depending on what your actually trying to accomplish, you might want to look into the new WINDOWED funstions like SUM() OVER (PARTITION BY ...)
i.e...
DECLARE @t TABLE (code INT, descr VARCHAR(10),...
______________________________________________________________________
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. SelburgMarch 24, 2008 at 6:01 pm
You're already doing it in some other cases, like the quest_name line ...
but anyway ...
set @phone=ISNULL((select phone from guest where account=@account and room=@room_code group by phone),'')
______________________________________________________________________
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. SelburgMarch 24, 2008 at 3:08 pm
Are the UserNames unique? This appears to be the case in your example.
DECLARE @t TABLE (UserName VARCHAR(25), StartTime DATETIME, UserID INT)
INSERT @t
SELECT 'Sally', '2008-03-24 10:09:13', 89...
______________________________________________________________________
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. SelburgMarch 24, 2008 at 3:04 pm
FYI, I only asked what you've tried to make sure this wasn't homework. It still may be, but you've shown that you've put forth effort.
So ....
SELECT
*
FROM
...
______________________________________________________________________
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. SelburgMarch 24, 2008 at 2:42 pm
Which does the ItemTypeID relate to? TableMain or TableDetail? You shouldn't have it in all three tables. It's redundant. If it applies to the row, then put the type id...
______________________________________________________________________
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. SelburgMarch 24, 2008 at 2:33 pm
What have you tried?
______________________________________________________________________
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. SelburgMarch 24, 2008 at 2:23 pm
I missed that "one row" requirement. ARGH!!!
SELECT
MIN(START_DT) AS START_DT
,MAX(END_DT) AS END_DT
FROM (SELECT
DENSE_RANK()...
______________________________________________________________________
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. SelburgMarch 24, 2008 at 9:50 am
ok, that was written with the assumption that there would be only one row per range.
-- create some test data
DECLARE @t TABLE (START_DT DATETIME, END_DT DATETIME)
INSERT @t
...
______________________________________________________________________
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. SelburgMarch 24, 2008 at 9:33 am
Viewing 15 posts - 571 through 585 (of 1,183 total)