Hi,

Here is what I would use, the row_number function partitioned by your datetime.

Try this script carefully before you uncomment the delete section.

;

WITH cte

...

Good, happy it helped, and thanks for the feedback, it's much appreciated!

Have a nice day!

Hi Andrew,

If I understood correctly, the reason you cannot update the column as not null is because you already have nulls in your table. I think you should manually change...

CirquedeSQLeil (2/9/2010)

---

I don't believe in this scenario that you need to use all of those options. Here is a modified query that returns the same result set. The...

CirquedeSQLeil (2/9/2010)

---

J-F Bergeron (2/9/2010)

---

Ehh, I wish I would've seen that comment before I posted the solution,

Why be so...

Ehh, I wish I would've seen that comment before I posted the solution,

Why be so rude anyway, I...

BaldingLoopMan (2/9/2010)

---

=====================================================================

SELECT name

FROM sys.tables t

WHERE t.is_ms_shipped = 0

AND object_ID NOT IN ( SELECT major_ID

...

There are some extended properties that tell you wether the tables were created for schema-modeling.

Here's what I quickly came up with, someone can tune this:

SELECT name

FROM ...

Thanks for the info, seems I never got a situation where I could test this. This sounds a bit weird to me, but in the end, it does make sense.

I...

Lookup "DateADD" function, in BOL, it does exactly what you are looking for.

SG-348334 (1/29/2010)

---

Well it gets worse before it gets better.

I ended up reinstalling SQL Server and tried to attach the mdf/ldf file.

However, now I get this error message when accessing...

Why post twice? It only fragments answers and does not help you in the end.

Please post further answers here :

http://www.sqlservercentral.com/Forums/Topic856335-1292-1.aspx

Where do you work at, and where do you live?

I'm happy it helped! Yes, Cte are very useful, they act like subqueries, but in my opinion, are a lot easier to read, it's just a top down approach. It...

Great, the query returns exactly that information.

Have you tried it?