Here's one way to accomplish this:

create table #DateOverlaps (

ID int identity primary key,

StartDate datetime,

EndDate datetime,

Val int)

insert into #dateoverlaps (startdate, enddate, val)

select '01/01/2008', '03/15/2008', 7 union all

select '03/16/2008', '08/24/2008', 9 union...

DBA (7/29/2008)

---

thank you, what do you mean with a CTE, in my case i will use this function for a variable (int) , i don' think its necessary to create...

From what's posted, I can't tell why it would eliminate them. I've used that exact construct to manage duplicates in functions before, and it does work. It has...

Beyond the oddities of the Where clause with variables in it, you might also think about changing the Where Not In on the table variable to a Left Outer Join....

Yes. So long as both updates are in the same statement, like your example.

usman.tanveer (7/29/2008)

---

Actually the Inner Query (aliased as A) is not a subquery in my database, its a view, and users call this view with their where clause.... I just copied...

usman.tanveer (7/29/2008)

---

Actually the Inner Query (aliased as A) is not a subquery in my database, its a view, and users call this view with their where clause.... I just copied...

A trace would also show its run-time in hours pretty normally, so it might not even be something to worry about.

If you want to overwrite, then you can schedule a job that will back up the production database, copy it to the other server, and restore it there, with overwrite....

If, for example, you place the filegroups on different disks, and then place tables on one and indexes on another, you can do parallel writes/reads, which can give you greater...

Yes, this can be done relatively easily. Build a recursive CTE for the second table (Books Online has an article about it under "Common Table Expressions"), and you should...

Yeah, I do exactly that in what I call extended properties tables. PK and FK the same column.

I'm looking at the Device Manager on my computer right now...

An external DLL, like a CLR function/proc, might not show up as a separate process from SQL Server.

I've never seen it do that.

I tried looking for an option that might do something like that. All I can say is play around with the scripting options a...