From a second thread so that everything is here:

PhilM99 (5/1/2009)

---

I could use some design direction here:

Original design of my db for this client:

One person has 126 numeric scores from a...

Please don't double post. You already started a thread here.

Let's keep everything in one place.

Edit: I copied the above to the other thread since it appears you added...

Just a few more things are really needed. Sample data for the tables in a readily consumable format, expected results based on that sample data, and the code you...

Warren Peace (5/1/2009)

---

I have the following...

Declare @TempTable As VarChar(200)

Set @TempTable = 'UserName200951125126427'

EXEC('Select * Into #' + @TempTable From [MySourceTable])

I get the result...

(253 row(s) affected)

I try and query the temp table...

Okay, simple test, both returned the same actual execution plan.

Functions:

CREATE FUNCTION dbo.ufnDayOnly(@DateValue DateTime)

RETURNS table

AS

RETURN (select dateadd(dd, datediff(dd,0, @DateValue),0) as DateOnly )

GO

CREATE FUNCTION dbo.fn_DayOnly_DateTime (@DateValue DateTime)

RETURNS DateTime

WITH SCHEMABINDING

AS

BEGIN

RETURN dateadd(dd,...

I think we just went full circle back to Paul's comment about it being intuitive.

Okay, same here. Read the questions, figured it out, posted an answer. The force was with us!

Tao Klerks (5/1/2009)

---

Alright, alright, point taken - no more converting to float... now I need to go explain the dateadd/datediff thing to my developers...

I was hoping to be able...

Florian Reischl (5/1/2009)

---

Lynn Pettis (5/1/2009)

---

WayneS (5/1/2009)

---

I guess it's a good thing that I didn't ask you how to...

So, denizens of The Thread, when do you think we'll hit 4,000 posts?

WayneS (5/1/2009)

---

I guess it's a good thing that I didn't ask you how to get to it :-)...

Jeff Moden (5/1/2009)

---

Florian Reischl (5/1/2009)

---

TheSQLGuru (5/1/2009)

---

Flo, are you getting your reads from SET STATISTICS IO ON? IIRC UDFs don't report IO correctly in this manner. Try getting them...

jcrawf02 (5/1/2009)

---

Lynn Pettis (4/29/2009)

---

Now for something totally the same...

How...

Any additional criteria for the delete would also be helpful.

Can you post the generalized schema of the tables, indexes, RI (if any), some sample data (readily consumable)?

This looks like fun.