Viewing 15 posts - 586 through 600 (of 1,183 total)
Use TOP with ORDER BY ....
SELECT TOP 2
START_DT, END_DT
FROM
dbo.yourTable
WHERE
END_DT <= GETDATE()
ORDER BY
END_DT DESC
______________________________________________________________________
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 8:49 am
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 8:14 am
More info here .. http://msdn2.microsoft.com/en-us/library/aa275767(SQL.80).aspx
______________________________________________________________________
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 21, 2008 at 12:29 pm
My humble recomendation is ...
C: OS + SQL Binaries
D: Data Files - RAID 1 or 10 (like Steve Suggested)
E: Temp DB & Log Files - RAID 0
F: Index Files -...
______________________________________________________________________
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 21, 2008 at 12:14 pm
I say just do a full backup after every UPDATE or DELETE. :w00t:
______________________________________________________________________
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 20, 2008 at 3:02 pm
Only to show that there is more than one way to get something done.....
-- First create some test data
DECLARE @testUserLoginDuration TABLE (starttime DATETIME, userid INT)
INSERT @testUserLoginDuration
SELECT...
______________________________________________________________________
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 20, 2008 at 2:39 pm
SQL ORACLE (3/18/2008)
If so, adding your query in your stored...
______________________________________________________________________
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 18, 2008 at 11:11 am
First, the answer to the question: NOPE
Second, a possible solution: Get Red Gates' SQL Compare and SQL Data Compare. Create an empty SQL 2000 database and use SQL Compare 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 18, 2008 at 11:06 am
There is always more than one way to skin a cat, and the same applies to TSQL.
One way...
SELECT unitid
FROM demotbl AS d
LEFT JOIN nesunit 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. SelburgMarch 18, 2008 at 9:32 am
http://www.sqlreportingservices.net/BookSrs2000/default.aspx
______________________________________________________________________
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 16, 2008 at 3:55 pm
Yes, it works with 2000 and I believe it's on the SQL Server media. Oh, it's FREE and not too dificult to set up. Search these forums, or the web...
______________________________________________________________________
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 15, 2008 at 8:01 am
Sounds like a perfect situation for a Reporting Services Fileshare Susbscription. 😀
______________________________________________________________________
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 14, 2008 at 10:49 am
Check this out...
http://www.amazon.com/Hitchhikers-Reporting-Services-Microsoft-Windows/dp/0321268288
______________________________________________________________________
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 12, 2008 at 11:46 am
I believe it is a semi colon ;
______________________________________________________________________
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 7, 2008 at 10:56 am
LOL, that's now on my wall!
______________________________________________________________________
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 4, 2008 at 8:43 am
Viewing 15 posts - 586 through 600 (of 1,183 total)