So, in essence, given @SerNum1 (let us call it A) and @SerNum2 (call it B) you want to insert @SerNum2 with all the values of @SerNum1. Is this correct?

ScottPletcher (3/7/2013)

---

Sorry, not to rain on the parade, but to me now is not the time to celebrate.

Getting the job is good, but it's just the start.

Dedicate yourself...

wolfkillj (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

Sean Lange (3/7/2013)

---

Lynn Pettis (3/6/2013)

---

Several years ago my oldest daughter's JV soccer coach once confieded "I knew we were in trouble when half the team asked what...

Sean Lange (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

Sean Lange (3/7/2013)

---

Lynn Pettis (3/6/2013)

---

Several years ago my oldest daughter's JV soccer coach once confieded "I knew we were in trouble when half the team asked...

That means something happened on the server resulting in SQL Server restarting. You need to find out...

Sean Lange (3/7/2013)

---

Lynn Pettis (3/6/2013)

---

Several years ago my oldest daughter's JV soccer coach once confieded "I knew we were in trouble when half the team asked what was offsides?"

Well, I've...

aakash214 (3/7/2013)

---

Hi,

I have a procedure which has a code something like

My SP is dynamic something like

WHILE(@i <= @max-2)

BEGIN

SELECT @db_name = db_name,...

Again, why? It...

alan_lynch (3/7/2013)

---

right Lynn I will try again.

I have had a look at your merge statement which has been useful the only thing is i have one error from the query...

kapfundestanley (3/7/2013)

---

I need to be corrected here,I have databases that will be recovering but as soon as I restart they regain online state after spending after hours in recovering.I have...

Brad Marsh (3/7/2013)

---

No So what I mean by comments is the comments field in the SQL.

So all of this data I have is created by customers, and because of that...

Or this one: http://www.sqlservercentral.com/articles/T-SQL/67898/.

Really?? You have to be kidding.

Here is my suggestion. Drop the table variables in favor of properly indexed temporary tables. Let us know how it works.

Does this get you started?

with TopDates as (

select top (100)

MyDates

from

dbo.MyTable

order by

MyDates desc

)

select min(MyDates) from TopDates;