Still not giving enough info. Perhaps reading this will help:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

😎

You really have missed part of what I asked for earlier. The definition for your tables, some sample data for the tables, the expected output based on the sample...

And this helps us know what you've done so far how? Please reread my post and Jeff's post. Based on the information you have provided us so far,...

We'd love to help you with your school project, but it would be better if you showed us what you have already done to try and solve the problem and...

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:...