With regard to headaches on how to write dates back to the DB, this is a must read:

'How do I delimit/format dates for database entry?'

http://classicasp.aspfaq.com/date-time-routines-manipulation/how-do-i-delimit/format-dates-for-database-entry.html

/Kenneth

This isn't an issue with ORDER BY at all, it's a case of CASE 🙂

Here's what is happening...

This works: select cast(2 as datetime)

This doesn't work: select cast(40520631 as datetime)

..recognize the...

Maybe I misunderstood what you're trying to do...

I assumed that you have a variable that is 'optional', that is the variable may have a value, and if it does, then...

You can find an explanation about how milliseconds are rounded in BOL if you search for 'datetime data type, overview [SQL Server - T-SQL]'

It looks like you're trying to get...

You need to reverse the order in your coalesce's..

You have (column, variable that my be null)

You should have (variable, column)

/Kenneth

'should' is the keyword when talking about checksum functions.

You must be aware that CHECKSUM() doesn't guarantee 100% to always generate a different output.

There is a chance to two different inputs...

Are you looking for something similar to this?

select'Hello' + char(13) + char(10) + 'and goodbye'

------------------

Hello

and goodbye

(1 row(s) affected)

/Kenneth

PERMISSIONS return a number, and from that number we check if a certain bit is set or not.

(That's what the bitwise operator & is used for)

So, for execute proc permissions,...

Also, if you know specifically which objectname you want to check against

(in this case exec on a proc) you could use the PERMISSIONS() function for that purpose

use master

declare @proc sysname

set...

You are aware that 92520071744 isn't a valid datetime value?

Also, if the day was for example the fifth of september....

Would it then be 9520071744 or 90520071744 ?

And the same thing...

Lester Policarpio (9/18/2007)

---

Another thing sir about full,diff and tlog is there a detailed site about this? I mean a detailed steps for every choices?

example:

1. FOr fast recovery - <this...

It's not due to slowness - RAID1 is the preferred raid level...

Jules Bonnot (9/25/2007)

---

so i should order more disks smaller physical disks rather than 1 extra large one? to put in the raid 5. we currently have 3.

will it use the extra disks/spindles...

Actually no.. When thinking about it, I don't consider single- or multi-instances on the same box being any different from an 'app' point of view.

Most, if not all routine things...

Jules Bonnot (9/25/2007)

---

Also what are the implications of multiple versus one instance for load on tempdb?

i have 2 physical disks.

c = raid 1 for OS and log files.

d = raid...