Viewing 15 posts - 406 through 420 (of 1,183 total)
Sergiy (3/29/2010)
Jason Selburg (3/29/2010)
Still looking into the "WHY"
It's a bug in SQL Server.
Instead of applying ORDER BY condition to the outcome of OUTER join (as it should be according 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. SelburgMarch 30, 2010 at 6:38 am
l543123 (3/29/2010)
I am sorry but isn't Java free? and isn't it a career path?
Java may be free, and a Java Developer may be a career path, but I don't know...
______________________________________________________________________
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 29, 2010 at 8:57 am
Did somebody say Free Beer?
______________________________________________________________________
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 29, 2010 at 8:54 am
Jason Selburg (3/29/2010)
Still looking into the "WHY" but remove the Order by from the second query and that gives you the expected results.
DUH! f I would have read the title...
______________________________________________________________________
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 29, 2010 at 7:28 am
Still looking into the "WHY" but remove the Order by from the second query and that gives you the expected results.
______________________________________________________________________
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 29, 2010 at 7:19 am
I was thinking about that after my post.
One thought is to EXEC the altered script. Then the under the hood actions are View created or altered by application, trigger fires...
______________________________________________________________________
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, 2010 at 7:37 am
Rick Osgood-429286 (3/25/2010)
Jason,I am up for that idea. Any chance you have a snippet of code?
Well, I don't have the exact code, but here's a trigger I've used to track...
______________________________________________________________________
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, 2010 at 3:04 pm
I still say DDL. You can "catch" the CREATE or ALTER view statement and strip away the WHERE from there before the view gets created/altered.
But that's just my 2 cents
______________________________________________________________________
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, 2010 at 2:04 pm
Lynn Pettis (3/25/2010)
Oh, and since this looks like homework, you may want to use John's solution as I'm sure mine won't work as you probably don't have a tally table.
Actually,...
______________________________________________________________________
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, 2010 at 1:27 pm
And Psion, don't take my comments ........{edited}........ as attacking.
I/we encourage you to use this site to help in your learning. It can be an invaluable resource, just don't abuse it....
______________________________________________________________________
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, 2010 at 1:23 pm
Psion (3/25/2010)
______________________________________________________________________
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, 2010 at 1:21 pm
Psion (3/25/2010)
ID int PK Identity
Q1 int null,
Q2 int null,
Q3 int null
the data inside the columns range from 1 to 7
example
Answer
---------
Q1 Q2 Q3
---------
1...
______________________________________________________________________
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, 2010 at 1:17 pm
A DDL Trigger would be one possible approach.
______________________________________________________________________
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, 2010 at 1:09 pm
Matthew Lehn (3/25/2010)
______________________________________________________________________
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, 2010 at 11:26 am
Depending on how you want to group....
1. if you want to group all of the 5 o'clocks for an entire timespan together then use:
SELECT DATEPART(hh,'3/23/2010 3:00 PM')
2. if you want...
______________________________________________________________________
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 23, 2010 at 1:01 pm
Viewing 15 posts - 406 through 420 (of 1,183 total)