Welsh Corgi (12/28/2015)

---

I very much appreciate all of the help.

I'm only dealing with 50,,, records.

When I performed the archive I had a lookup table that stored the Batch Size etc.

Can...

Welsh Corgi (12/28/2015)

---

Ed Wagner (12/28/2015)

---

I would start by verifying the rows you want to delete like this. You didn't post the DDL, so I don't have your column list....

Okay, but I don't know that you can delete from two...

Delicious

time 2390 (12/28/2015)

---

I am trying to create a report to receive a text string parameter, such as :

'American Dad', 'Archer', 'Family Guy', 'King of the Hill', 'Robot Chicken', 'Simpsons', 'Venture...

I would start by verifying the rows you want to delete like this. You didn't post the DDL, so I don't have your column list. You'll need to...

Jason A. Long (12/28/2015)

---

Grant Fritchey (12/28/2015)

---

I have two presentations I do on best practices. Both slide decks are available on slideshare.net. That could act as a guide. Just give me...

Seafood

Excellent point, Luis. Thanks.

Bogey

Glad to hear it. Thanks for the feedback.

I learned something new today, so thank you.

I hope everyone had a very Merry Christmas and enjoyed time with family.

Steve Jones - SSC Editor (12/24/2015)

---

TomThomson (12/24/2015)

---

I thought "nice easy question for Christmas Eve" and then I saw the number of wrong answers and was surprised. Default login mapping...

If I'm reading this correctly, it looks like you want the time required for each step.

You're on SQL 2008, so you don't get the LEAD/LAG functions. Instead, you can...