There is a word about saying never, never say it. You should always consider limitations...

And what happens when you get to Z and need more?

CREATE TABLE #tmpTbl1

(Casenumber int,

Edgnumber int,

ssn varchar(100))

INSERT INTO #tmpTbl1

VALUES (100025730, 54390, '958754681')

INSERT INTO #tmpTbl1

VALUES (100025730, 54393, '958754681');

INSERT INTO #tmpTbl1

VALUES (100025730, 54399, '958754681');

DECLARE @inputcasenumbers [Interface].[udttOTISCaseNumber]

INSERT INTO @INPUTCASENUMBERS (CaseNumber, SSN, EdgNumber)

SELECT

Casenumber

,SSN

,Edgnumber

FROM #tmpTbl1

EXEC [Interface].[uspGenerateOTISCaseNumbers]...

I like your modification better than mine. I left out the check of @@TRANCOUNT in the code I reposted in my attachment. Definitely a good idea to have...

Hey Phil, can you add a rollback in the CATCH block? I just noticed that I forgot that in the code I uploaded.

I fixed the code I had uploaded...

Thanks, Phil.

EdVassie (1/27/2016)

---

One minute to evaluate a CV... luxury! In my last job I worked for a large UK job board, and we frequently asked recruiters for feedback on how...

Tried posting how I might approach writing this update, but couldn't do it directly from work. When I got home last night, didn't even get on my computer so...

WayneS (1/22/2016)

---

Brandie Tarvin (1/22/2016)

---

Okay. This is driving me batty.

New code (with datatypes fixed) works fine ....

(code snipped)

...until I remove that damn driveletter column.

(code snipped again)

Where it fails on that DBFileName...

Brandie Tarvin (1/20/2016)

---

Eirikur Eiriksson (1/20/2016)

---

Alvin Ramard (1/20/2016)

---

Ed Wagner (1/20/2016)

---

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this...

Grant Fritchey (1/20/2016)

---

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb thread. It...

And the same in SQL Server 2014. No indicator that the index is disabled.

datsun (1/15/2016)

---

Any thoughts on why the SSMS Table Object explorer tree - GUI not show any indicator (colour change or down arrow)

for Disabled Index?

Even RightClick menu option does not...

ilikawa (1/15/2016)

---

I've came up with the idea about how is database sizing done.

I've read the information provided by Microsoft on its website (https://msdn.microsoft.com/en-us/library/ms175991.aspx) about how to make estimations about sizing,...

Letron Brantley (1/12/2016)

---

I have a question regarding the Microsoft Balanced Data Distributor.

http://blogs.msdn.com/b/sqlperf/archive/2011/05/25/the-balanced-data-distributor-for-ssis.aspx

Does anyone have any insight into how SQL Server handles target table locking if you use the...