Viewing 15 posts - 50,071 through 50,085 (of 59,078 total)
I'd like to know why people use Date Serials in such a fashion to begin with. 😉
June 12, 2008 at 7:17 pm
shivsen (6/11/2008)
Just want to know How is the Job market now for SQL Server 2000 DBA in US. I'm hearing from friends that the Job market is slowing down.Thanks,
shivsen
How's the...
June 12, 2008 at 6:55 pm
catriona_brown (6/11/2008)
How can I retrieve the date of the last Sunday of every month?
All these wonder formula's for calculating the last sunday of a month and I'm not sure we...
June 12, 2008 at 5:44 pm
Blinking is good... keeps the bloodshot eyes in shape 😛
June 12, 2008 at 3:55 pm
Lynn Pettis (6/12/2008)
Which track is right, the coding of the delete (I offered 2 solutions) or the fragmentation (disk and data)?
I was talking about the DELETE code... but, yes, I...
June 12, 2008 at 2:54 pm
catriona_brown (6/12/2008)
I figured it out. An no still not an exam question.
Heh... ok, your turn... let's see it... 😉
June 12, 2008 at 2:46 pm
Jeff Moden (6/12/2008)
June 12, 2008 at 2:43 pm
Matt Miller (6/12/2008)
--test data
declare @date datetime
set @date='01/01/2008';
select top 500 @date+n as date
into #tblDate
from tally
where n<501
--last sunday of the...
June 12, 2008 at 2:42 pm
You're right... I missed where the OP said that. Thanks, Christopher. And, yes... lookup Cross Tab Reports...
June 12, 2008 at 2:28 pm
Ummm... there's some responsibility required on the part of the user... you make them enter it twice and not allowed to proceed unless they match. If they get it...
June 12, 2008 at 2:26 pm
That's a common mistake that many developers make... they comment something like that out so they can test and do a rollback... but they forget to put things back the...
June 12, 2008 at 2:19 pm
Lynn Pettis (6/12/2008)
Jeff Moden (6/12/2008)
The real fact of the matter is...
June 12, 2008 at 2:14 pm
Good question... I've never seen that behavior before... Of course, it's been several revisions of SQL Server since I've actually had to write any GUI code.
June 12, 2008 at 2:08 pm
Not sure the use of a correlated subquery (a form of hidden RBAR) will speed anything up here... Maybe...
The real fact of the matter is the OP says it...
June 12, 2008 at 8:37 am
Viewing 15 posts - 50,071 through 50,085 (of 59,078 total)