Now triple posted. Please reply here.

Now triple posted. Please reply here.

With the multiple database solution, you have to be sure that users are "synced" between databases. Using separate schemas and filegroups may actually be easier. To give a...

Then there are the newbie's on the site who get impatient because no one is answering them, so they just start posting in other forums hoping to get a response.

Edit:...

This doesn't look like something you need a constraint for as much as looking at it differently. What you describe fits a design that would use a ValidFrom, ValidTo...

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?