Actually, I don't expect perfection from everyone, but I would expect it to be done right. Right does not equal perfection.

I have written code that was right, it met...

Okay. Never use a float type to...

Here is some code to start working with:

declare @ADatetime float,

@DatePart int,

@TimePart int

set @ADatetime =...

jarceri (6/13/2008)

---

I have a datamodel that I am doing some reporting on and the datetime stamps are stored in the table as a float.

Example: 20080613123001

Trying to convert this to...

Matt, I think to characterize this as a religious war is a little dramatic. I'd simply call it a strong difference of opinion.

As I said earlier, I'll agree...

You can also zip the plan to a .zip file and upload that to SSC.

😎

Unfortunately, it doesn't look like the OP has been on SSC since yesterday morning. Hope he checks this thread and let's us know what's happening.

😎

select 59/60 -- is doing integer division, that is why it returns 0

try: select 59/60.0

😎

Matt Miller (6/12/2008)

---

Makes me wonder if it wouldn't be easier to just to the select...INTO on stuff you want to keep, blow out the original table and reinsert the items...

Jeff Moden (6/12/2008)

---

Lynn Pettis (6/12/2008)

---

Jeff Moden (6/12/2008)

---

Not sure the use of a correlated subquery (a form of hidden RBAR) will speed anything up here... Maybe...

The real fact of the...

It appears that you are using a recursive CTE to do something that could be easily done with a Tally table.

Here is an article that will help you with this:...

Not knowing what application you are running I can only give you this suggestion: shutdown the app server then do your restore on the database server. I am assuming...

David,

I really liked the helicopter story. Well played!

😎

Actually, since it looks like you are using Access as a front end to a SQL Server 2000 database, you should be able to do the same thing with Access...

You really shouldn't cross post. This looks like it has been posted in three separate forums.

Edit:

I suggest using the following forum: http://www.sqlservercentral.com/Forums/Topic516075-145-1.aspx

😎