Viewing 15 posts - 21,211 through 21,225 (of 26,490 total)
happycat59 (5/3/2009)
May 4, 2009 at 9:54 am
I'm slightly confused as to what is being asked. In addition to data and expected results, the DDL for the tables involved and your current code would also be...
May 4, 2009 at 9:50 am
RBarryYoung (5/4/2009)
PhilM99 (5/4/2009)
It's hard to remember you started out to drain the swamp when you're up to your *** in alligators. --old IT saying
Sorry if I have offended the...
May 4, 2009 at 8:59 am
Hearing the differences between Oracle and SQL Server, although interesting, is getting a bit old.
Let's remember one crucial thing SQL Server Oracle.
Let's stop complaining about the differences and just...
May 4, 2009 at 8:22 am
laailalalaa (5/4/2009)
how can i cancel the operation that triggered.. a trigger in some cases?
say i have an after insert trigger for a Students(id int, name varchar(15)) table and if i...
May 4, 2009 at 8:02 am
Excellent question. This is one of the things you have to watch for when converting a query that uses the old style outer joins to the ANSI standard outer...
May 4, 2009 at 6:54 am
Excellent article Roy. We are just now starting to look at the possibility of moving to SQL Server 2008. Turns out in the next tools release of PeopleSoft...
May 3, 2009 at 10:41 pm
Hopefully you also noticed in your reading that a table may only have 1 clustered index. You can learn more about the indexes by using the INDEXPROPERTY. You...
May 3, 2009 at 12:43 pm
The only answer I can come up with is this; It Depends.
What does it depend on? The application and how it is used. Unfortunately you haven't provided any...
May 3, 2009 at 12:37 pm
Jeff Moden (5/2/2009)
In earlier versions of Microsoft® SQL Server™ 2000,...
May 3, 2009 at 12:27 am
Jeff Moden (5/2/2009)
If there's another thread with more detailed information, why the hell are we trying to answer anything on this thread? We're just spitting resources here.;-)
A) I...
May 3, 2009 at 12:19 am
dave b (5/2/2009)
I'm hoping that someone can help me calculate a monthly billing total. I'm writing a report where I need to account for a minimum price in the total...
May 2, 2009 at 6:53 pm
Part of the filter criteria needs to move up to the join criteria. Try this query and compare it to the results of the original.
SELECT DISTINCT
...
May 2, 2009 at 7:33 am
Please read the first article referenced in my signature block below.
May 2, 2009 at 12:34 am
I did a little more testing and wanted to post the results of the testing. These are in the same order as the queries in my previous post:
CpuMs ...
May 1, 2009 at 3:47 pm
Viewing 15 posts - 21,211 through 21,225 (of 26,490 total)