Viewing 15 posts - 1,606 through 1,620 (of 5,685 total)
Chrissy,
One approach to this that helps keep your code intact and allows for manipulatable result ordering is using temp tables. If you do something like the following:
CREATE PROC abc
@sortdescriptor...
April 25, 2012 at 2:36 pm
aballard (4/24/2012)
SELECT m.* FROM dbo.t_main m INNER JOIN dbo.t_main_ref ref on (m.id = ref.mainid) WHERE (ref.FK1 = @Condition1) and (ref.FK2 = @Condition2) and (m.Column5 = @Condition3) and (m.Column6 < GETDATE())
The...
April 25, 2012 at 2:30 pm
It can be a bit confusing, but basically what you end up having to do is clean off the 'year' and replace it.
There's a few approaches, but direct datediff/dateadd math...
April 24, 2012 at 7:33 pm
Grant Fritchey (4/24/2012)
GilaMonster (4/24/2012)
The Dixie Flatline (4/24/2012)
I just finished reading "Shadows In Flight", if you've ever read Orson Scott Card and like Bean better than Ender. Recommended.
Intriguing......
April 24, 2012 at 7:29 pm
aballard (4/24/2012)
I have a table with the structure
(ID Guid
FK1 Guid
FK2 Guid
FK3 Guid
Priority Bit)
The ID in this table...
April 24, 2012 at 7:19 pm
GilaMonster (4/24/2012)
Evil Kraig F (4/24/2012)
Heh, you guys reminded me that I want to order up the final books in the Dresden series and finish that... 🙂
Final? <sob>
If it finishes where...
April 24, 2012 at 7:12 pm
Chrissy,
Is this to allow passing the sorting components down to a pagination proc? That's the time I see items like this the most often. If it is, there's...
April 24, 2012 at 5:41 pm
GilaMonster (4/24/2012)
The Dixie Flatline (4/24/2012)
I just finished reading "Shadows In Flight", if you've ever read Orson Scott Card and like Bean better than Ender. Recommended.
Intriguing... I loved...
April 24, 2012 at 4:28 pm
Heh, you guys reminded me that I want to order up the final books in the Dresden series and finish that... 🙂
April 24, 2012 at 4:23 pm
GilaMonster (4/19/2012)
Considering trying out EVE. Thought I'd download the client while I'm in the UK and see how it goes, nothing much to lose.
I should have mentioned Eve, I played...
April 19, 2012 at 5:56 pm
GilaMonster (4/19/2012)
#declare NewTopic;
Who plays MMOs and which ones?
I've just quit the one I played for a few years, they added a 'pay to...
April 19, 2012 at 5:19 pm
GilaMonster (4/19/2012)
Evil Kraig F (4/19/2012)
*sniff*http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/
Ah hah! There it is. I got my keywords all confuzzled. :crying: Thanks Gail (both for the blog post AND linking it for...
April 19, 2012 at 4:10 pm
SkyBox (4/19/2012)
So basically, if you can create or keep an index that can cover serveral others, then queries can use the larger index with more coverage just as efficiently?
If...
April 19, 2012 at 3:53 pm
The Dixie Flatline (4/19/2012)
Evil Kraig F (4/19/2012)
The Dixie Flatline (4/19/2012)
Well I was... except for the part about dying at PASS. 😉
Please remember this year that "Extreme programming...
April 19, 2012 at 3:44 pm
The Dixie Flatline (4/19/2012)
Well I was... except for the part about dying at PASS. 😉
Please remember this year that "Extreme programming styles" does not usually include stunt...
April 19, 2012 at 3:35 pm
Viewing 15 posts - 1,606 through 1,620 (of 5,685 total)